Symptom
The DB02 diagnostics tool to check inconsistencies between Database and Data Dictionary reports missing tables and/or indexes. The alerted objects may look like this:
- /BIC/D1000695 - in case of missing tables
- /BIC/D100088P~020 - in case of missing indexes
- /BIC/F2000123 - for temporary table used during aggregate reconstruction
The aggregates 100069 or 100088 cannot be found in the system. A check in transaction SE14 proves that the object only exists on the Database.
Read more...
Environment
- SAP NetWeaver - All versions
- Non-HANA Database
Product
Keywords
ORA-00942: table or view does not exist; (SQL error 942); Early Watch Analysis; EWA, index, indexes, indices, aggregate, aggregat, aggregates, missing, , KBA , BW-BEX-OT-DBIF , Interface to Database , BW-BEX-OT-AGGR , Aggregates (Definition and Filling) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.