Solution : https://service.sap.com/sap/support/notes/1094305 (SAP Service marketplace login required)
Summary :
In SAP transaction DB02, an issue arises where primary indexes for DataStore Object (DSO) tables appear missing but actually exist under different names due to erroneous renaming processes. This mislabeling occurs when the RSDU_TABLE_RENAME_ORA function is employed without correctly renaming associated primary indexes. Errors like ORA-01408 or ORA-01418 may appear when attempting to manage these indexes. The solution involves correcting index names using SQL or SAP Basis functions and applying corrective patches provided, such as Support Package 16 for SAP NetWeaver 7.0 BI or using the specific program ZSAP_INDEX_REPAIR_1094305 for widespread index issues.
Key words :
system reports missing primary indexes, statement alter index <wrong_index_name> rename, l_s_index-table cp '/bi 40', l_s_index-table cp '/cns 40', sap basis function db_rename_index, 0 bi import support package 16, standard bw system, create missing indexes, internal bw processes, structured query language
Related Notes :
| 1095506 | Upgrade to SAP NetWeaver 7.1 for banking services from SAP |
| 1074388 | SAPBINews NetWeaver 7.0 BI Support Package 16 |