SAP Knowledge Base Article - Preview

2304508 - Orphaned aggregate tables

Symptom

Transaction DB02 diagnostics alert missing tables. The tables are of type /BIC/D<numbers>, /BIC/F<numbers> or /BIC/E<numbers>; e.g /BIC/D1000103 or /BIC/F100010. These are tables of cube aggregates (where <numbers> indicate the aggregate ID). However, no such aggregate exists for any InfoCube in the system - hence, orphaned tables.
The situation may vary; the only common thing usually is that the aggregate does not appear in RSA1 or RSDDV. Hence it is not possible to resolve the situation by reactivating the aggregate. For instance, it may be the case that the aggregate table only appears in transaction SE14, but cannot be displayed in transaction SE11. The table can be empty or filled with data. The aggregate may still be present in table RSDCUBE, but missing in table RSDDAGGRDIR or the other way round.


Read more...

Environment

  • SAP Netweaver - all version

Product

SAP NetWeaver all versions

Keywords

RSDDV, RSA1 , KBA , BW-BEX-OT-AGGR , Aggregates (Definition and Filling) , BW-BEX-OT-DBIF , Interface to Database , 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.