SAP Knowledge Base Article - Preview

3699235 - Table conversion fails in STEP-2 with SQL error 289

Symptom

A table conversion fails in STEP-2 when renaming the original table to QCM<table_name>. The error occurs when renaming indexes that are not defined in the ABAP Dictionary. In this scenario, the rename operation can fail with "SQL error 289: duplicate index name". For example:

RENAME INDEX "SAPHANADB"."esh:ftx~saphanadb~prps~post1~001" TO "QCMPRPS~001"
RENAME INDEX "SAPHANADB"."esh:ftx~saphanadb~prps~posid~001" TO "QCMPRPS~001"
SQL Exception with SQL code 289:
cannot use duplicate index name: QCMPRPS~001 or constraint name: QCMPRPS~001

Remark: Table PRPS was only used as an example in the above scenario. This error can occur for different standard tables.


Read more...

Environment

SAP S/4HANA

Product

ABAP platform all versions ; SAP NetWeaver all versions ; SAP S/4HANA all versions

Keywords

prps table adjustment, ci_prps field domain change, ddic_comptype_inconsistent, sql exception 289, duplicate index name, prps-step2 error, sap s/4hana, abap dictionary, table conversion, secondary indexes, esh-indexes, sap hana database , KBA , BC-DWB-DIC-AC , ABAP Dictionary Activation and Conversion , 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.