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!