Buy

Buy

List of Posts

Get this widget
To get notifications, Please like our Facebook Page >>>>>>

Use Search box to find a topic in this Blog!!!

SAP BW Production Support Issues (Long running ODS/DSO Activation)

How to analyze a long running ODS activation step in this post.
STEP 1
Lets assume that we encountered the long running ODS/DSO step in a

 Process Chain
 (T-code: RSPC1)
 as shown in below pic.
   
STEP 2
 
Right Click on the ODS activation step in PC and select ‘Administer Data Target‘ from the context menu options as shown below.
 
STEP 3
Now you will be in ‘manage’ screen of the ODS. Here, copy the activation request number ( ODSR_…..) of the request that is currently in activation status (yellow status) 

as shown below. 
   

STEP 4
Now go to Table: ‘RSODSACTREQ’ (T-code: SE16) and input the activation request number (obtained in STEP 3) in ‘ACTREQUEST‘ field selection. Now hit the ‘Number of Entries’ button and the number we obtain is the total number of DataPackets to be activated. (1658 in our case, as shown in below pic.)
 
STEP 5
Now, in the same table browser screen, input ‘status‘ selection condition as ≠0 as shown below and hit ‘execute‘ button at top.
 
STEP 6
Now look at the ‘DATAPAKID values for non-zero ‘STATUS‘ entries ( DataPackets 836-838 in our case, as shown below)

 
The conclusion can be that the activation step has finished about 835 DataPackets out of 1658 total DataPackets (about half way) and based on the time it took to reach this point, we can estimate the how long its going to take to complete the ODS activation.

4 comments:

Note

This blog is solely for the purpose of getting educated in SAP. This blog does not encourage distribution of SAP hold copyright and any other publication and/or materials bearing SAP mark. If you find any copyright materials, please mail me so I can remove them. This blog is not in association with SAP.

ALL Posts

Get this widget