Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Summit 2023 [19th to 23rd March, Las Vegas and Virtual] | Complete AEM Session & Lab list

Archive Import Fails because Primary Key Constraint on table TB_REP_RESOURCECOLLECTION is violated

Avatar

Not applicable
After applying SP2, I can no longer remove a LiveCycle Archive, and then

import an new version of the Archive. The failure is caused by a

primary key violation on table TB_REP_RESOURCECOLLECTION. When I remove

the Archive, the associated resource get removed from the TB_REP_RESOURCE

table, however, table TB_REP_RESOURCECOLLECTION does not get cleaned up.



When I re-import the Archive, it tries to add the resource directories to the

TB_REP_RESOURCECOLLECTION table, but they already exist and the import fails.



Has anybody else experienced this problem?
0 Replies