SAP BI/BW System Refresh/Copy Issues

In a typical SAP BW system landscape, often the the lower systems ( Sandbox, Dev,Quality) are refreshed with the Production copy. Here we will discuss some of the common issues and the solutions.

1. In a BI 7.0 system, the DTP's in the refreshed system will result in pointing to the Production system.

Solution: To convert the DTP's pointing to your refreshed system, run the program RSBKDTP_BDLS in SE38. Now you will be able to see all your DTPs are pointing to your refreshed system logical name.

2. Opening the Infopackages for the delta loads result in shortdump in ST22 in the refreshed system.

Solution: Go to SE38, run RSSM_OLTP_INIT_DELTA_UPDATE to update the init conditions back in the source system (ECC..). Go to RSA7 in the source and verify the particular datasource is in green state.

3. In a typical SAP BI landscape, BW Accelerator is attached to the Production system. Your Quality system is refreshed from Production which has BWA Appliance and when you try to load the data into the Infocubes, the rollup steps result in error and the running the queries also ends up with error saying there is no RFC to BWA.

Solution: You see the TREX RFC in RSCUSTA screen pointing to Production in the Quality system. Remove the destination and ask your Basis to create a dummy RFC for the BWA in Quality system and place the RFC details in RSCUSTA screen. You can say that you can delete the incorrect TREX RFC from the RSCUSTA screen but the queries copied from Prod will not work.

4. When you to load the new request to the DSO, it says the request has been duplicated/Activated and the reason is the inconsistency in the metadata tables. Your DTP will try to load all the requests from the PSA table even though they were already loaded to the target.

Solution: Go to the manage screen of the data target and look for the recent request and open up the monitor for that particular DTP, check the request id in the selections and go to the PSA and look for that request id. Now, you can delete all the PSA requests starting with this request id and all previous requests. Run the DTP again to load the request that you were trying to load.