How To Fix RSCV547 - INFORMIX: Index &1 does not have the expected type: 'Detached Index'

RSCV547 - Overview

• Message type: E = Error

• Message class: RSCV - Analysis of BW objects (InfoCubes...)

• Message number: 547

• Message text: INFORMIX: Index &1 does not have the expected type: 'Detached Index'

What causes this issue?

Index &v1& does not have the expected type 'detached' (Index data
created separately of table data). Instead, the index was created
'attached', meaning that the index data is created together with the
table data. In certain circumstances, this can lead to poor
performance.

How to fix this error?

The index has to be repaired. Use a repair routine, that is assigned to
this analysis routine (function <PF>Remove errors </>in the transaction
<ZH>RSRV</>).

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSCV547 - INFORMIX: Index &1 does not have the expected type: 'Detached Index' ?

  The SAP error message RSCV547 related to Informix indicates that there is an issue with an index in the database. Specifically, the error states that the index does not have the expected type of 'Detached Index'. This can occur in scenarios where the database schema or the index definitions are not aligned with what SAP expects.
  
  Cause:
  
  Index Type Mismatch: The index in question is not of the type that SAP expects. In this case, it should be a 'Detached Index', but it is not.
  Database Schema Changes: If there have been recent changes to the database schema or the index definitions, this could lead to inconsistencies.
  Corruption or Misconfiguration: There may be corruption in the index or misconfiguration in the database settings.
  
  
  Solution:
  
  Check Index Definition: Verify the definition of the index in the Informix database. Ensure that it is defined as a 'Detached Index'. You may need to consult the database documentation or your