BW: Infopackage Request is showing no. of fetched records but is in Yellow State for too long
This is a very common error which can drive you nuts.
You have executed the infopackage and it is showing number of records transferred. Now this number is not increasing but request is in still yellow state.
1- Check ST22 in BW system.
2- Please check If there is any recent “CX_SY_OPEN_SQL_DB” dump having short text “SQL error in the database when accessing a table”.
3- Select “Information on where terminated ” option from your left in ST22 transaction.
4- Please check if you receive following information regarding termination.
Termination occurred in the ABAP program “GPD9MD1Y7LHYIY4YXUTXTHJ9VM8” – in
The main program was “SAPMSSY1 “.
ORA-01502: index ‘SAPSR3./BIC/B0000XXXXXX~0’ or partition of such index is in unusable state
If your answer to all points mentioned in above “Actions” is YES then following solution is for you.
1- Goto : SE14 on BW Side
2- Adjust and activate you PSA Table.
3- Adjust and activate primary/secondary index of this table.