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.