Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

Change Log/PSA Variant does not delete the Change Log/PSA requests.

Applies to:

SAP BI 7.0, SAP BI 7.01,SAP BI 7.30

Summary

Change Log/PSA Variant does not delete the Change Log/PSA requests. It turns green, i.e.  Executed successfully, but it does not pick any Change Log/PSA Request to Delete.

Author(s):  

   
Company:       Patni Computer System Ltd.
Created on:    17 Feb 2011
Author(s) Bio Himanshu Panchal is currently working in Patni Computer Systems Ltd as a SAP BW Consultant from last one year.

Scenario

Change Log/PSA Variant does not delete the Change Log/PSA requests. It turns green, i.e.  Executed successfully, but it does not pick any Change Log/PSA Request to Delete.

Cause

You have a upgraded from a BW 3.X or BW 7.0 system to BW 7.01 system or BW 7.11 system or BW 7.30 system. After the upgrade the Change Log/PSA deletion Variant does not delete the requests from the Change Log/PSA.

Technical Cause

From BW 7.00 and higher releases there was a field 'USERAPP' introduced in the PSA definition table 'RSTSODS'. 'USERAPP' is used for determining the application to which the PSA is associated with. In case of Change Log of DataStore the value of the field 'USERAPP' is 'CHANGELOG'.

But as this was not available in case of BW 3.X. so when you upgrade to BW 7.00 or higher releases from BW 3.X there is a possibility this field is blank if the report 'RSDG_ODSO_ACTIVATE' is not executed after the upgrade for the Standard DataStore Object which were created before the upgrade.

In the above case, Flexible Change Log deletion introduced in BW 7.01 and also available in BW higher releases, the Change Log deletion variant will not work i.e. requests will not be deleted from the Change Logs used in the Change Log variant as these Change Logs are filtered out from the deletion process as the USERAPP is blank in the metadata definition table of PSA i.e. RSTSODS for corresponding Change Logs.

Solution

Following are the Steps for resolving the Change Log Variant Issue:
1.     First check whether the note 1385479 is implemented in your system or not. If not please implement the same.
(OR)
Check the below code in the Form CHECK_DATASTORE_NAME in Program LRS_CLG_DEL_GUIF01.

 *---Note 1385479
*  if I_ODSNAME(1) <> '8'.
**   1. Normal datasource => skip
*    E_SUBRC = 1. exit.
*  endif.
*----should always be cross-checked in RSTSODS
    DATA: l_s_ods TYPE RSTSODS.
    SELECT SINGLE * FROM RSTSODS INTO l_s_ods WHERE ODSNAME = I_ODSNAME AND OBJSTAT = 'ACT'.
      IF sy-subrc = 0.
*----there is an entry in RSTSODS.
        IF l_s_ods-USERAPP ne 'CHANGELOG'.
*----normal datasource => skip
          E_SUBRC = 1.
          EXIT.
        ENDIF.
       ELSEIF sy-subrc <> 0.
*----something totally inconsistent
          E_SUBRC = 1.
          EXIT.
      ENDIF.
*---Note 1385479

If it does not exist, then replace the below code with above one:

   if I_ODSNAME(1) <> '8'.
*   1. Normal datasource => skip
    E_SUBRC = 1. exit.
  endif.

2.     Execute the report 'RSDG_ODSO_ACTIVATE' for the DataStore object corresponding to the Change Log for which Change Log deletion variant is not working checking the 'ACTIVATE' option.
3.     Once the above steps are taken check whether the USERAPP field is set as 'CHANGELOG' in the PSA definition table (RSTSODS) for the corresponding Change Log.
4.     If it is set then Change Log deletion variant will work correctly.
5.     If it is not set then please report the problem to SAP. Even if it is set and the Change Log deletion is still not working please report the problem to SAP.
 

Following are the Steps for resolving the PSA Deletion Variant Issue:
1.     If the DataStore Object is used in the PSA Deletion Variant, then replace that variant with the Change Log Variant.
2.     If this Change Log Variant does not work, then follow the step as described in above for Change Log Variant Issue.