ODS activation job taking long time to complete.
Hi BW experts!
We are facing a strange problem with one of the ODS while activation for quite sometime now.
The activation job remains active for a long time and the log goes like this,,,
Step 001 started (program RSODSACT1, variant &0000000000285, user ID ALETBDTD1C)
Log for activation request ODSR_41TN552OYEAOVLOM6DZ56LTF3 data package 000001...000001
Activation of data records from ODS object ZTO_SD06 sucessfully completed
The job gets stuck here, but the activation would have been completed in the ODS and even available for reporting.
The job will be waitin for the below 2 steps :
Activation queue for ODS object ZTO_SD06 has been deleted successfully
Is this because of a table space issue with ODS ?
Moreover this problem is happening with only this ODS while its fine with all other ODSs in the system.
Any help is appreciated.
Thanks a lot in Advance!!