SAP Knowledge Base Article - Preview

2268610 - Aggregate Tables or Indexes are missing in the Data Dictionary

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

SAP NetWeaver all versions

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.