Skip to Content
4
Jul 08, 2022 at 11:27 AM

Updating from 2105 to 2205, unique index violation

1971 Views

Hi,

we're trying to update from SAP Commerce 2105.11 to 2205.0. While performing the ant updatesystem task in our ccv2 deployment, we're getting the following error message:

problem executing sql [reason: StatementCallback; uncategorized SQLException for SQL [ CREATE UNIQUE INDEX cmsItemByUidCvIDX_99 ON genericitems (p_uid, p_catalogversion);  CREATE INDEX i4a4122c8_typecode_84 ON maptypes3 (InternalCode);  CREATE INDEX i4a4122c8_typecodelowercase_84 ON maptypes3 (InternalCodeLowerCase);  CREATE UNIQUE INDEX cmsItemByUidCvIDX_1076 ON pagetemplate (p_uid, p_catalogversion);  CREATE UNIQUE INDEX cmsItemByUidCvIDX_1074 ON restriction (p_uid, p_catalogversion);  CREATE INDEX SlotsForPagePageIdx_1071 ON slotsforpage (p_page);  CREATE UNIQUE INDEX cmsRelationByUidCvIdx_1071 ON slotsforpage (p_uid, p_catalogversion);  CREATE INDEX SlotsForTempTempIdx_1069 ON slotsfortemplate (p_pagetemplate);  CREATE UNIQUE INDEX cmsRelationByUidCvIdx_1069 ON slotsfortemplate (p_uid, p_catalogversion);  CREATE INDEX i4a4122c8_nameidx_typesystemprops3 ON typesystemprops3 (NAME);  CREATE INDEX i4a4122c8_itempk_typesystemprops3 ON typesystemprops3 (ITEMPK);  CREATE INDEX i4a4122c8_realnameidx_typesystemprops3 ON typesystemprops3 (REALNAME)]; SQL state [S0001]; error code [1505]; The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.genericitems' and the index name 'cmsItemByUidCvIDX_99'. The duplicate key value is (<NULL>, <NULL>).; nested exception is java.sql.BatchUpdateException: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.genericitems' and the index name 'cmsItemByUidCvIDX_99'. The duplicate key value is (<NULL>, <NULL>).]

We're seeing that in the cms2-items.xml the new index cmsItemByUidCvIDX was introduced. Otherwise we are not seeing anything related to our custom implementation.

Is anyone else having this issue?