Symptom
When synchronization of cronjob is running long, the following error can be observed in logs:
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert duplicate key row in object 'dbo.contentslot' with unique index 'cmsItemByUidCvIDX_1066'. The duplicate key value is (CS_xxx_Section1, 8796xxxxxx649). |
Cannot insert duplicate key row in object 'dbo.cmscomponent' with unique index 'cmsItemByUidCvIDX_1084'. The duplicate key value is (cmsitem_00xxx019, 8796xxxxxx649).; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert duplicate key row in object 'dbo.cmscomponent' with unique index 'cmsItemByUidCvIDX_1084'. The duplicate key value is (cmsitem_00107019, 8796xxxxxx649). |
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Read more...
Environment
SAP Commerce Cloud V2
Product
SAP Commerce Cloud 2205 ; SAP Commerce Cloud 2211
Keywords
Unique Index, cmsItemByUidCvIDX_1066, cmsItemByUidCvIDX_1084, sync, dump medias, contentslot, cmscomponent , KBA , CEC-SCC-PLA-PL , Platform , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.