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.
SAP Knowledge Base Article - Preview