When Attempting to Repeatedly move the Content Items from one Framework Folder to another, the following error occurs (Doc ID 2185187.1)

Last updated on SEPTEMBER 21, 2023

Applies to:

Symptoms

On : 11.1.1.9.0 version, Content Server, with the latest patch applied (BP 160321)

When attempting to repeatedly move the content items from one Framework Folder to another,
the following error occurs.

ERROR
-----------------------

systemdatabase/6 03.18 05:51:55.190 IdcServer-634 !csDbUnableToExecuteQuery,UfldFileOwner(UPDATE FolderFiles SET fFileName='Copy(5) of cnt2418127.pdf'\, fPublishedFileName='Copy(5) of cnt2418127.pdf'\, fInhibitPropagation=0\, dDocName='CN003406'\, fOwner='weblogic'\,
systemdatabase/6 03.18 05:51:55.190 IdcServer-634 fLastModifier='weblogic'\, fLastModifiedDate={ts '2016-03-18 05:51:55.177'}\, fSecurityGroup='Public'\, fDocAccount=''\, fClbraUserList=''\, fClbraAliasList=''\, fClbraRoleList=''\, fParentGUID='B496F120E83F0E8C296E833F386A542B'\,
systemdatabase/6 03.18 05:51:55.190 IdcServer-634 fDocClass='Base'
systemdatabase/6 03.18 05:51:55.190 IdcServer-634 WHERE fFileGUID='7702F697D72B66FDE6D1D3732388A18D')!$ORA-00001: unique constraint (DEV_OCS.UNIQUEFILENAME_FOLDERFILES) violated

>systemdatabase/6 03.18 05:51:55.191 IdcServer-634 run: 7.62 ms. total 22 ms. [ORA-00001: unique constraint (DEV_OCS.UNIQUEFILENAME_FOLDERFILES) violated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Check in a Framework Folder a couple of content items, including the "cnt2418127.pdf" file.
2. From the folders "v Select" menu -> choose "All Files" and from the "v Actions" menu select "Move" and choose as destination another Framework Folder.
3. The move action initiated above, complete successful this time.
4. Check in again in the same folder the same content items as in point 1., plus a new content item.
5. From the "v Select" menu -> choose again "All files" and from the "v Actions" menu select Move to the same destination folder.
6. This time the operation is raising the above error,

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot check in all their content.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.