Skip to Content
0
Former Member
Jun 04, 2018 at 10:54 PM

Database error during update SYNCIDX_619

471 Views

Hi experts

We are migrating hybris 6.0 to 6.5, but during the update process, we mark the option "Update running system" but during the update cannot continue because we have an issue with ITEMSYNCTIMESTAMPS type the detail of the error:

INFO | jvm 1 | main | 2018/05/22 12:01:58.836 | [m[1;31mERROR [hybrisHTTP26] [10.1.137.74] [DefaultDbScriptsExecutor] problem executing sql [reason: StatementCallback; uncategorized SQLException for SQL [CREATE UNIQUE INDEX syncIDX_619 ON ITEMSYNCTIMESTAMPS (P_SOURCEITEM, P_TARGETVERSION, P_SYNCJOB)]; SQL state [HY000]; error code [349]; SAP DBTech JDBC: [349]: cannot CREATE UNIQUE INDEX; duplicate key found: [5] Several documents with the same ID exist in the index;MABD:ITEMSYNCTIMESTAMPS.$uc_SYNCIDX_619$ content not unique, cannot define unique constraint. rowCount != distinctCount ; nested exception is com.sap.db.jdbc.exceptions.BatchUpdateExceptionSapDB: SAP DBTech JDBC: [349]: cannot CREATE UNIQUE INDEX; duplicate key found: [5] Several documents with the same ID exist in the index;MABD:ITEMSYNCTIMESTAMPS.$uc_SYNCIDX_619$ content not unique, cannot define unique constraint. rowCount != distinctCount ] INFO | jvm 1 | main | 2018/05/22 12:01:58.836 | [m[1;31mERROR [hybrisHTTP26] [10.1.137.74] [Initialization] problem executing sql [reason: StatementCallback; uncategorized SQLException for SQL [CREATE UNIQUE INDEX syncIDX_619 ON ITEMSYNCTIMESTAMPS (P_SOURCEITEM, P_TARGETVERSION, P_SYNCJOB)]; SQL state [HY000]; error code [349]; SAP DBTech JDBC: [349]: cannot CREATE UNIQUE INDEX; duplicate key found: [5] Several documents with the same ID exist in the index;MABD:ITEMSYNCTIMESTAMPS.$uc_SYNCIDX_619$ content not unique, cannot define unique constraint. rowCount != distinctCount ; nested exception is com.sap.db.jdbc.exceptions.BatchUpdateExceptionSapDB: SAP DBTech JDBC: [349]: cannot CREATE UNIQUE INDEX; duplicate key found: [5] Several documents with the same ID exist in the index;MABD:ITEMSYNCTIMESTAMPS.$uc_SYNCIDX_619$ content not unique, cannot define unique constraint. rowCount != distinctCount ]

We are using Hana as database

Regards!