Skip to Content
Author's profile photo Former Member

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.

Done. 🙂

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Mario Tibollo
      Mario Tibollo

      And if the answer is not YES, what do we do then?