How To Fix RS_DB_DB6560 - Inconsistent metadata for InfoCube &1

SAP Error Message - Details

• Message type: E = Error

• Message class: RS_DB_DB6 - DB6-Specific Messages in SAP BW

• Message number: 560

• Message text: Inconsistent metadata for InfoCube &1

What causes this issue?

In the BW metadata, the field DBORDNUM is usually used to store
information about the possible use and order of each column as MDC
dimension.
For column-organized tables, however, DBORDNUM is used in the following
way: The package dimension equals 89 and all other dimensions equal 0.
For the current table, there is an inconsistency: The package dimension
equals 89, but one of the other dimensions is unequal 0.

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?

Report an incident on component BW-SYS-DB-DB6.

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 RS_DB_DB6560 - Inconsistent metadata for InfoCube &1 ?

  The SAP error message RS_DB_DB6560 indicates that there is inconsistent metadata for an InfoCube in the SAP BW (Business Warehouse) system. This inconsistency can arise due to various reasons, such as changes in the InfoCube structure, issues during data loading, or problems with the metadata repository.
  Cause:
  
  Metadata Changes: If there have been changes to the InfoCube structure (like adding or removing characteristics or key figures) without proper adjustments in the metadata, inconsistencies can occur.
  Data Load Issues: If data was loaded into the InfoCube while the metadata was being changed, it could lead to inconsistencies.
  Transport Issues: If the InfoCube was transported from one system to another without the corresponding metadata, inconsistencies may arise.
  Database Issues: Corruption or issues in the underlying database can also lead to metadata inconsistencies.
  
  Solution:
  To resolve the RS_DB_DB6560 error, you can follow these steps:
  
  
  Check Metadata Consistency:
  
  Use transaction code RSA1 to access the Data Warehousing Workbench.
  Navigate to the InfoCube in question and check its metadata.
  Use the "Check" function to identify any inconsistencies.
  
  
  
  Repair Metadata:
  
  If inconsistencies are found, you can use the "Repair" function in the Data Warehousing Workbench to fix the metadata.
  Alternatively, you can use the transaction code RSADMIN and execute the report RS_DB_CHECK to check and repair inconsistencies.
  
  
  
  Rebuild the InfoCube:
  
  If the above steps do not resolve the issue, consider rebuilding the InfoCube. This involves deleting the InfoCube and recreating it, which can be a more drastic measure but may be necessary in some cases.
  
  
  
  Check Data Load Process:
  
  Review the data load process to ensure that it is not causing inconsistencies. Make sure that data is loaded only after the metadata is stable.
  
  
  
  Transport Consistency:
  
  If the InfoCube was transported, ensure that all related objects (like InfoObjects, DSO, etc.) were also transported correctly.
  
  
  
  Database Check:
  
  If you suspect database issues, perform a database consistency check and repair any issues found.
  
  
  
  Related Information:
  
  
  Transaction Codes: 
  
  RSA1: Data Warehousing Workbench
  RSADMIN: Administration for BW
  SE11: Data Dictionary (to check table structures)
  
  
  
  SAP Notes: Check for any relevant SAP Notes that may provide additional guidance or patches related to this error.
  
  
  Documentation: Refer to SAP BW documentation for best practices on managing InfoCubes and handling metadata.
  
  
  Support: If the issue persists, consider reaching out to SAP support for further assistance, especially if it involves complex metadata issues or database corruption.
  
  
  By following these steps, you should be able to identify and resolve the inconsistency causing the RS_DB_DB6560 error in your SAP BW system.