- DBACockpit is reporting missing indexes:
After a migration to SAP ASE you are getting from DBACockpit under Diagnostics -> "Missing Tables and Indexes" listed /BIC/E100xxxx tables.
DBACockpit Notes are up to date.
The RS_BW_POST_MIGRATION was executed after migration.
- Checking the concerned tables, by the table name you can deduce they are Aggregates
Note: Aggregates tables use to be named "/BIC/E100nnn" or "/BI0/E100nnn" for E fact aggregate tables and "/BIC/F100nnn" or "/BI0/F100nnn" for F fact aggregate tables.
The table names that make up the logical object that is the aggregate are derived in a similar manner, as are the table names of an InfoCube. For example, if the aggregate has the technical name 100001, the fact tables are called: /BIC/E100001 and /BIC/F100001
- The indexes appears on SE14 and when using the Check Objects from Database the message “Database object for <table_name> is inconsistent: (Secondary Indexes)” is returned on the header -> The indexes are not created on the database side.
- Checking the status on the BW RSA1, the green traffic light for "Check Indexes of Agg." is returned.
- Green traffic light also returned from RSRV -> All Elementary Tests -> Database -> Database Indeces of an Infocube and Its Aggregates.
- You confirmed that those Aggregates have no data.
SAP Business Wharehouse (BW) on SAP Adaptive Server Enterprise (ASE)
BW SYBASE ASE aggregate DBACockpit missing secondary indexes , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem
About this pageThis 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.