Monday, October 24, 2016

Datasource / Infopackage level Failures

Infopackage Failures

  • "Transfer (IDocs and TRFC): Errors occurred " "Request IDoc : IDoc with errors added 
      • Check the Idoc in WE02 . If it says "EDI: Partner profile not active"  it means that the connection is inactive
      • EDPP1 - MATLVL is inactive.
    • Solution : Go to WE20  - Select corresponding system in Partner Type and look for Classification Tab on the R.H.S and change the Partner Status to Active.
  • Queue is not available in the source system
    • Run program  RSSM_OLTP_INIT_DELTA_UPDATE to correct the error.
  • Inconsistency in delta administration.
      • RSSM_OLTP_INIT_DELTA_UPDATE
      • The delta administration for DataSource <datasource> from the source system <source system>.
      • The table RSSDLINIT in the BW system contains at least one entry for initialization. However the table ROOSPRMSC in the source system does not contain any entries for this DataSource in this source system.
  • No Delta Records
      • ROOSGENDLM - Generic Delta Management for DataSources ( Gives details of when the last delta was run)
      • Run FM to change the delta pointer
  • 0FI_AA_12 and 0FI_AA_11 has 0 delta records.
Process Overdue / Request remains yellow
  • One of the reason would be that there are heavy loads running in the source system and there are no background process in the source. Check with Basis.

  • Sometimes, the request gets completed in the source system but the status in BW is still yellow. Check SM58 in source system.
    •  If there are any LUWs there, try to execute them manually ( Menu - Edit - Execute LUW )
    • If you want to delete all the LUWs, ( Log File - Reorganize ). This will delete all the LUWs hanging.
  • You can see the job being completed in the source system but, no idocs generated in target system.In the below screenshot, you can see that the OLTP idocs are generated , but there are no corresponding BW Idos - Again, this might be because of lack of resources.






  • One more scenario is that, when you check the tRFC in SM58, you see the below error.
        • Errors : Open SQL array insert produces duplicate records
        • Errors : EDI: Error during database insert in table EDIDC
        • Here , these errors are because of number ranges. Basis has to reset the table EDIDC

  • There is no request from BW to ECC. Full loads run fine, but delta / Init with data transfer fail. This might be because SMQ1 entries are pointing to wrong client
  • Info IDoc 1 : sent, not arrived ; Error passing data to port   
    • In this case you can see that the IDocs are not getting generated in BW. The job gets completed in ECC and ECC IDocs are also generated but, data does not come to BW due to Error at the Port.
    • Go to ECC -> BD87

Here it says, Port does not exist in the table. 
Check the port number in WE20 -> Select Partner Type - Logical system and select the system you are looking for.
On the R.H.S., look for outbound parameters - Click on Message type RSINFO and gives the Receiver Port number. Take this number and see if it matches the Port number in WE21 - Transactional RFC for the client you are looking for. 
If the port numbers are different, change the number in WE20 to match WE21. 
Check for Message type RSSEND also and do the same .The issue should be resolved.

  • Error occurred in the source system 
    • No transfer structure is available for InfoSource 2LIS_13_VDHDR in the source system.
      • When any client copies are done or in any other scenario , we get the above error.
      • This might be because of the entries missing in ROOSGEN table.
      • For temporary fix, each datasource which is failing can be replicated and activated again which adds entry to ROOSGEN table and the initialization will go through fine.
      • Basis can run a mass activation and this can be fixed. 
  • Data was extracted from incorrect client
    • Datasource is pointing to wrong client. This happens mostly with Classification datasources where, when client is changed, the number doesn't change automatically. Values need to changed in CTBW, for these datasources.
Error: No Extract Structure Active or no BW Connected

Solution: This can be due to BW not being completely setup. Incomplete control parameter for commmunication with the BW system. Basis need to check this.

Infopackage dumping when opening. MESSAGE_TYPE_X
Refer to link : HERE





Friday, October 21, 2016

0CO_PC_PCP_10

0CO_PC_PCP_10 : Product Cost Analysis: Overview


SAP Link
http://help.sap.com/saphelp_afs64/helpdata/en/a1/4367c4f84e40828a41c1d1f1ed0fe4/content.htm


Notes
When creating a DSO on this datasource, use Plant, Material, Costing Date, Date from ( and Date To ) As Key fields to receive the correct granularity.

Wednesday, October 19, 2016

Remodelling Infocube and DSO

Corresponding Notes / Links

https://wiki.scn.sap.com/wiki/display/profile/2007/06/28/Remodeling+Tool+in+BI+7.0



Issues Faced
InfoCube remodelling failed with below error


DSO remodelling failed with below error
" No remodeling log found (check job log in SM37 or short dumps in ST22) "



Tuesday, October 4, 2016

ALV declarations

*& Declarations.
DATA: lt_fieldcat TYPE  slis_t_fieldcat_alv,
      lw_fieldcat TYPE slis_fieldcat_alv.


*& ---- Displaying the ALV.
PERFORM f_field_catalog.
*PERFORM f_top.
PERFORM f_display_alv.


*& Performs
*&---------------------------------------------------------------------*
*&      Form  F_FIELD_CATALOG
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*  -->  p1        text
*  <--  p2        text
*----------------------------------------------------------------------*
FORM f_field_catalog .

DATA : lv_pos TYPE i VALUE 1.

  CLEAR : lw_fieldcat.
  lw_fieldcat-col_pos         = lv_pos.
  lw_fieldcat-fieldname       = 'IOBJ'.
  lw_fieldcat-seltext_l       = 'InfoObject'.
  lw_fieldcat-key             = 'X'.
*  lw_fieldcat-outputlen       = 15.
  append lw_fieldcat to  lt_fieldcat.

  lv_pos = lv_pos + 1.
  CLEAR : lw_fieldcat.
  lw_fieldcat-col_pos         = lv_pos.
  lw_fieldcat-fieldname       = 'USED_TYPE'.
  lw_fieldcat-seltext_l       = 'Used Type'.
* lw_fieldcat-outputlen       = 20.
  append lw_fieldcat to  lt_fieldcat.


ENDFORM.


*&---------------------------------------------------------------------*
*&      Form  F_DISPLAY_ALV
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
*  -->  p1        text
*  <--  p2        text
*----------------------------------------------------------------------*
FORM f_display_alv .

lw_flayout-colwidth_optimize = 'X'.

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
 EXPORTING
*   I_INTERFACE_CHECK                 = ' '
*   I_BYPASSING_BUFFER                = ' '
*   I_BUFFER_ACTIVE                   = ' '
   I_CALLBACK_PROGRAM                = sy-repid
*   I_CALLBACK_PF_STATUS_SET          = ' '
*   I_CALLBACK_USER_COMMAND           = ' '
*   I_CALLBACK_TOP_OF_PAGE            = 'TOP'
*   I_CALLBACK_HTML_TOP_OF_PAGE       = ' '
*   I_CALLBACK_HTML_END_OF_LIST       = ' '
*   I_STRUCTURE_NAME                  =
*   I_BACKGROUND_ID                   = ' '
   I_GRID_TITLE                      = 'This is Report Title'
*   I_GRID_SETTINGS                   =
   IS_LAYOUT                         = lw_flayout
   IT_FIELDCAT                       = lt_fieldcat
*   IT_EXCLUDING                      =
*   IT_SPECIAL_GROUPS                 =
*   IT_SORT                           =
*   IT_FILTER                         =
*   IS_SEL_HIDE                       =
*   I_DEFAULT                         = 'X'
*   I_SAVE                            = ' '
*   IS_VARIANT                        =
*   IT_EVENTS                         =
*   IT_EVENT_EXIT                     =
*   IS_PRINT                          =
*   IS_REPREP_ID                      =
*   I_SCREEN_START_COLUMN             = 0
*   I_SCREEN_START_LINE               = 0
*   I_SCREEN_END_COLUMN               = 0
*   I_SCREEN_END_LINE                 = 0
*   I_HTML_HEIGHT_TOP                 = 0
*   I_HTML_HEIGHT_END                 = 0
*   IT_ALV_GRAPHICS                   =
*   IT_HYPERLINK                      =
*   IT_ADD_FIELDCAT                   =
*   IT_EXCEPT_QINFO                   =
*   IR_SALV_FULLSCREEN_ADAPTER        =
* IMPORTING
*   E_EXIT_CAUSED_BY_CALLER           =
*   ES_EXIT_CAUSED_BY_USER            =
  TABLES
    T_OUTTAB                          = lt_output
 EXCEPTIONS
   PROGRAM_ERROR                     = 1
   OTHERS                            = 2
          .
IF SY-SUBRC <> 0.
* Implement suitable error handling here
ENDIF.