Message type: E = Error
Message class: RSCV - Analysis of BW objects (InfoCubes...)
Message number: 638
Message text: DB2/400: Indexes from fact tables are missing
With the conversion it is determined that standard indexes are missing.
The report SAP_INFOCUBE_INDEXES_CHG_DB4 adjusts only existing indexes
to the new index concept and deletes obsolete indexes. Missing indexes
are not created.
The system issues an error message and will not allow you to continue with this transaction until the error is resolved.
You can repair missing indexes with the report
SAP_INFOCUBE_INDEXES_REPAIR. Since this can take a long time with large
tables, we recommend that you schedule the report as a batch job.
You can read units about the indexing schema for BW fact tables from
DB2/400 in <ZH>SAP Note 407528</>.
Error message extract from SAP system. Copyright SAP SE.
RSCV638
- DB2/400: Indexes from fact tables are missing ?The SAP error message RSCV638, which indicates that "Indexes from fact tables are missing" in the context of DB2/400, typically arises in the context of SAP BW (Business Warehouse) or SAP BI (Business Intelligence) environments. This error suggests that the system is unable to find the necessary indexes for the fact tables, which are crucial for efficient data retrieval and reporting.
Cause: Missing Indexes: The primary cause of this error is that the required indexes for the fact tables in the database are not present. This can happen due to various reasons, such as: Incomplete data loading processes. Manual deletion or corruption of indexes. Issues during the data extraction, transformation, and loading (ETL) process. Database
Configuration Issues: There may be configuration issues with the DB2/400 database that prevent the creation or recognition of indexes. Data Model Changes: Changes in the data model or structure of the InfoCube or DataStore Object (DSO) may lead to inconsistencies in the
Get instant SAP help. Sign up for our Free Essentials Plan.
RSCV637
DB2/400: The indexes were successfully converted
Self-Explanatory Message Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of...
RSCV636
&2 indexes are missing in the database from the fact table of InfoCube &1
Self-Explanatory Message Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of...
RSCV639
Read Note 407528 on the indexing schema of BW fact tables on IBM i
Self-Explanatory Message Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of...
RSCV640
SAP DB: Table &1 has not been analyzed
Self-Explanatory Message Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of...
Click on this link to search all SAP messages.