VERSIONING EXCEPTION IN BCC

EXCEPTION: 

Update of head versions for bidirectional property  OwnedProperty=fixedParentCategories ReciprocalProperty=fixedChildCategories ReciprocalItemDescriptor=category during checkin for table "SetTable-43-dcs_cat_chldcat" on item-descriptor "category" for asset id 100000  in workspace workspace:25016 failed due to:
CAUGHT AT:
CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (PUB.DCS_CAT_CHLDCAT_P) violated


CAUSE: 

You have many to many mapping  and when ATG tries to insert a record it failed because there is already a same asset version available  in any of  the tables either in  first one or in third.

SOLUTION:

Manually delete that extra version  from that table for that particular records .

Invalidate the cache .

Try now.