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

You cannot find the aggregates 1000695 or 100088 on your 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 , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.