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.