How To Fix RSCV638 - DB2/400: Indexes from fact tables are missing

RSCV638 - Overview

• 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

What causes this issue?

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.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

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

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message 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