SAP Knowledge Base Article - Preview

3547260 - Inconsistency Error 5994: Bad Index in HANA Database Table

Symptom

  • An inconsistency error code 5994 is encountered during a consistency check in the SAP HANA database.
  • The error message indicates a bad index with the name IDX_P_PSE_PROVIDERS_OID.
    e tcc_result_write Request.cc(02714) : Errors are detected
    e tcc_result_write Request.cc(02715) : SchemaName,TableName, ColumnName, ErrorCode, ErrorMessage, ActionName, AffectedCount, Details
    SYS,P_PSE_PROVIDERS_,,5994,Inconsistency found: Bad index;name=IDX_P_PSE_PROVIDERS_OID;type=CPB+-tree (unique);invalid key at entry: (1/1) with exception: exception 2120042: An unexpected error occurred. For further information on this error search SAP notes for one of the following tags: loc=0xc6466e1cd7379ef3, ctx=0x5d06b0f414b6baa5. If you don't find an according note, open a support ticket and include the trace files containing correlation id 0x6cbe3a24f0e02431. 
  • You have followed note 2901237 - Bad Index inconsistency with HANA DB table to execute SQL:
    ALTER INDEX "SYS"."IDX_P_PSE_PROVIDERS_OID" REBUILD; 
    But failed due to:
    Could not execute 'ALTER INDEX "SYS"."IDX_P_PSE_PROVIDERS_OID" REBUILD'
    SAP DBTech JDBC: [258]: insufficient privilege: only internal SYS user can modify objects in SYS and _SYS_AUDIT schema 


Read more...

Environment

SAP HANA Database 2.0

Product

SAP HANA, platform edition 2.0

Keywords

Inconsistency, Error 5994, Bad Index, HANA Database, Table, IDX_P_PSE_PROVIDERS_OID, CHECK_TABLE_CONSISTENCY, SAP HANA Monitoring. , KBA , HAN-DB-SEC , SAP HANA Security & User Management , 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.