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
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.