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.

Symptoms:

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.

Actions:

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

“INSERT_ODS”.

The main program was “SAPMSSY1 “.

ORA-01502: index ‘SAPSR3./BIC/B0000XXXXXX~0’ or partition of such index is in unusable state

Solution:

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.

Done. 🙂