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?