Message “Cannot insert multiple records in Retail category containment lookup (RetailCategoryContainmentLookup). Category: 0, 0. The record already exists.” is displayed while closing form category hierarchy after insert node


Symptoms


Message “Cannot insert multiple records in Retail category containment lookup (RetailCategoryContainmentLookup). Category: 0, 0. The record already exists.” is displayed while closing form category hierarchy after insert node

Resolution


Change  "join" to "exists join" that if there are records in the table "hierarchyRole", the record will be inserted into the table "containmentLookup" for only once instead of several times.

 

More information


Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained here in is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.