How-to document on ALE pointers causing delta issues for master data Datasources – post Suppor

Issue Details

Basis team is doing a support pack upgrade from
BI 701-007 to 701-012. After this upgrade done in Sandbox, Development, Quality and Pre-production we are facing
Delta Load issues for some of the Master Data DataSources.

Error messages popping are “Error in the source system” and “Requesting the last delta for master data is not supported”.

Effected Master Data DataSources are:

• 0COSTELMNT_ATTR
• 0COSTCENTER_TEXT
• 0GL_ACCOUNT_ATTR
• 0MATERIAL_ATTR
• 0VENDOR_TEXT

Error Message Screen Shots:

Resolution Steps

This is happening after the SP upgrade because the new storage location for ALE change pointers (table BDCP2) was changed by the basic component after upgrade. Previous this is BDCP.

We have to make the BDCP2_ACT field of the TBDA2 table as "X" because this BDCP2_ACT indictor decides whether the table BDCPS or BDCP2 table will be considered for deleting the entries. To make this field X, we have to activate
message types of corresponding Master Data DataSources.

BD61 is to activate change pointers and it should be activated in our system

Steps to follow for Resolution

::ECC-side::

1)   1.
Find Message types(MSGTYP) for each DataSource in table ROOSGEN

Below list is the from ERC system

OLTPSOURCE                     SLOGSYS                           RLOGSYS                    MSGTYP
-----------------------------------------------------------------------------------------------------------------------------------------------------
0COSTELMNT_ATTR         ERCCLNT100                       BWCCLNT100                     RS0053

0COSTCENTER_TEXT       ERCCLNT100                       BWCCLNT100                     RS0058
0GL_ACCOUNT_ATTR       ERCCLNT100                       BWCCLNT100                     RS0054
0MATERIAL_ATTR            ERCCLNT100                       BWCCLNT100                     RS0055
0VENDOR_TEXT               ERCCLNT100                       BWCCLNT100                     RS0059

2. Check for BDCP2_ACT field status of the TBDA2 table

In table TBDA2 you can activate or deactivate the writing of change pointers for a specific master data object.

Before activation this field will be blank. Once activated using below report this field is filled with “X”

Check below before activation of message types

MANDT                MESTYP                ACTIVE                 BDCP2_ACT
----------------------------------------------------------------------------------------------------------
100                         RS0053                  X                             [blank]

100                         RS0058                  X                             [blank]
100                         RS0054                  X                             [blank]
100                         RS0055                  X                             [blank]
100                         RS0059                  X                             [blank]

3)   3.
After upgrade, Migrate the stored change pointers using report,
RBDCPMIG_ALL_WITHOUT_MIG_FLAG in Test Mode to check which message types require a migration to what extent.

To migrate the change pointers, execute the report in production mode (unselect Test run check box) for all specified message types. You can start the report for individual message types; this splits the entire runtime.

Now ensure that flag BDCP2_ACT in table TBDA2 is now active ('X')

::SAP BI side::

1)     
Delete Initialization and perform re-initialization without data transfer.

2)     
Perform Delta loads for those DataSources

References:-

SAP Note- 1165059

SDN Discussion link-

http://scn.sap.com/thread/3252754