Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member

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. :smile:

1 Comment
Labels in this area