SAP Knowledge Base Article - Preview

2104317 - SAP BW on ASE: DBACOCKPIT returning Missing Database Objects after migration

Symptom

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

KBA_DBACockpit1.jpg

KBA_DBACockpit2.jpg

 


Read more...

Environment

SAP Business Wharehouse (BW) on SAP Adaptive Server Enterprise (ASE)

Product

SAP NetWeaver 7.4

Keywords

BW SYBASE ASE aggregate DBACockpit missing secondary indexes , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , 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.