Database error during update SYNCIDX_619

[Former Member]

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!

[Former Member]

I found the solution, i check the syncIDX and its composed by source product code and target catalog version, i delete the duplicated register and then i could made the system update