If Item Is in Workflow and in a Folder, Error Returned When Checking In a New Revision Named the Same as Another File in That Folder: $ORA-00001: unique constraint (Doc ID 2101720.1)

Last updated on SEPTEMBER 21, 2023

Applies to:

Symptoms

On: 11.1.1.8.0 version BP 13, Content Server

An item is in a folder and is in workflow.

The reviewer checks the item out and checks in a new revision. When the new revision is checked in, the file selected has the same name as a file that already exists in the folder.

The checkin fails with an error.

Note that this only happens if the item is in Workflow. If the item is not in workflow, it can be checked out and checked back in with a file named the same as one that already exists in the folder. In this case, the file is renamed automatically to "copy of..." in order to keep the filenames contained in the folder unique.

Error in browser states:

Content Server Request Failed
Error Unable to execute service WORKFLOW_EDIT_REV and function addFiles. The error was caused by an internally generated issue. The error has been logged.


Error from Log:
-----------------------
>services/3 08.28 11:38:30.017 IdcServer-62 !csUserEventMessage,user1,<HostName>:16200!$intradoc.common.ServiceException: !csServiceDataException,WORKFLOW_EDIT_REV,addFiles!$
 services/3 08.28 11:38:30.017 IdcServer-62 *ScriptStack WORKFLOW_EDIT_REV
 services/3 08.28 11:38:30.017  IdcServer-62  3:doSubService,dID=XXX,dDocName=XXXXXXWORKFLOW_CHECKIN_SUB,dID=1XXXX,dDocName=XXXXXX:determineWorkflowCheckin,dID=XXX,dDocName=XXXXXXWORKFLOW_EDIT_REV,dID=XXX,dDocName=XXXXXX:addFiles,dID=XXX,dDocName=XXXXXX
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.ServiceRequestImplementor.buildServiceException(ServiceRequestImplementor.java:2176)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.Service.buildServiceException(Service.java:2410)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.Service.createServiceExceptionEx(Service.java:2404)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.Service.createServiceException(Service.java:2399)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.ServiceRequestImplementor.handleActionException(ServiceRequestImplementor.java:1816)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1766)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.Service.doAction(Service.java:566)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1483)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.Service.doActions(Service.java:561)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.ServiceRequestImplementor.executeSubServiceCode(ServiceRequestImplementor.java:1346)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.Service.executeSubServiceCode(Service.java:4190)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.ServiceRequestImplementor.executeServiceEx(ServiceRequestImplementor.java:1222)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.Service.executeServiceEx(Service.java:4185)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.Service.executeService(Service.java:4169)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.DocServiceHandler.determineWorkflowCheckin(DocServiceHandler.java:4645)
 services/3 08.28 11:38:30.017 IdcServer-62         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 services/3 08.28 11:38:30.017 IdcServer-62         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
 services/3 08.28 11:38:30.017 IdcServer-62         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 services/3 08.28 11:38:30.017 IdcServer-62         at java.lang.reflect.Method.invoke(Method.java:606)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:86)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.common.ClassHelperUtils.executeMethodReportStatus(ClassHelperUtils.java:324)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.ServiceHandler.executeAction(ServiceHandler.java:79)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.Service.doCodeEx(Service.java:622)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.Service.doCode(Service.java:594)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1693)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.Service.doAction(Service.java:566)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1483)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.Service.doActions(Service.java:561)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.ServiceRequestImplementor.executeSubServiceCode(ServiceRequestImplementor.java:1346)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.Service.executeSubServiceCode(Service.java:4190)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.ServiceRequestImplementor.executeServiceEx(ServiceRequestImplementor.java:1222)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.Service.executeServiceEx(Service.java:4185)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.Service.executeService(Service.java:4169)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.Service.doSubService(Service.java:4079)
 services/3 08.28 11:38:30.017 IdcServer-62         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 services/3 08.28 11:38:30.017 IdcServer-62         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
 services/3 08.28 11:38:30.017 IdcServer-62         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 services/3 08.28 11:38:30.017 IdcServer-62         at java.lang.reflect.Method.invoke(Method.java:606)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:86)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:310)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.common.ClassHelperUtils.executeMethod(ClassHelperUtils.java:295)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.Service.doCodeEx(Service.java:639)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.Service.doCode(Service.java:594)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1693)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.Service.doAction(Service.java:566)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1483)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.Service.doActions(Service.java:561)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1415)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.Service.executeActions(Service.java:547)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:751)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.Service.doRequest(Service.java:1982)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.ServiceManager.processCommand(ServiceManager.java:486)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.IdcServerThread.processRequest(IdcServerThread.java:265)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.idcwls.IdcServletRequestUtils.doRequest(IdcServletRequestUtils.java:1355)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.idcwls.IdcServletRequestUtils.processFilterEvent(IdcServletRequestUtils.java:1732)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.idcwls.IdcIntegrateWrapper.processFilterEvent(IdcIntegrateWrapper.java:223)
 services/3 08.28 11:38:30.017 IdcServer-62         at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source)
 services/3 08.28 11:38:30.017 IdcServer-62         ... 35 more
 services/3 08.28 11:38:30.017 IdcServer-62 Caused by: intradoc.data.DataException:!csDbUnableToExecuteQuery,UfldFileUnPublishedParams(UPDATE FolderFiles SET fFileName='df1.txt'\, dRevisionID=1 WHERE fFileGUID in ('XXXXXXXXXXXXXXXXXXXXXXXXXXX'))!$ORA-00001: unique constraint (DEV_OCS.UNIQUEFILENAME_FOLDERFILES) violated
 services/3 08.28 11:38:30.017 IdcServer-62
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2680)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.jdbc.JdbcWorkspace.execute(JdbcWorkspace.java:671)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.folders.FoldersFilterImplementor.updateContentModification(FoldersFilterImplementor.java:1426)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.folders.FoldersFilterImplementor.addFiles(FoldersFilterImplementor.java:1002)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.folders.FoldersFilterImplementor.doFilter(FoldersFilterImplementor.java:132)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.shared.PluginFilters.filterWithAction(PluginFilters.java:114)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.shared.PluginFilters.filter(PluginFilters.java:68)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.DocServiceHandler.addFiles(DocServiceHandler.java:509)
 services/3 08.28 11:38:30.017 IdcServer-62         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 services/3 08.28 11:38:30.017 IdcServer-62         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
 services/3 08.28 11:38:30.017 IdcServer-62         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 services/3 08.28 11:38:30.017 IdcServer-62         at java.lang.reflect.Method.invoke(Method.java:606)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:86)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.common.ClassHelperUtils.executeMethodReportStatus(ClassHelperUtils.java:324)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.ServiceHandler.executeAction(ServiceHandler.java:79)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.Service.doCodeEx(Service.java:622)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.Service.doCode(Service.java:594)
 services/3 08.28 11:38:30.017 IdcServer-62         at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1693)
 services/3 08.28 11:38:30.017 IdcServer-62         ... 86 more
>(internal)/6 08.28 11:38:30.038 IdcServer-62 File to be removed: /Oracle/Middleware/user_projects/domains/base_domain/ucm/cs/vault/~temp/XXXXXX.txt
>systemdatabase/6 08.28 11:38:30.039 IdcServer-62 !csMonitorActiveDbConnections,0
>systemdatabase/6 08.28 11:38:30.039 IdcServer-62 Connection with id of 'IdcServer-62([ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (selftuning)').6' is removed from active connections with key of '[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)''.
>systemdatabase/6 08.28 11:38:30.039 IdcServer-62 release pool connection
>requestaudit/6 08.28 11:38:30.039 IdcServer-62 WORKFLOW_CHECKIN [dID=XXX][dDocName=XXXXXX][dDocTitle=test2][dUser=user1][dWfID=XXX][dWfName=user1][dSecurityGroup=Public][QueryText=dAFBusinessObjectType<matche>`null` <AND> dAFBusinessObject<matches>`null` <AND> dAFApplication<matches>`null`][StatusCode=-32][StatusMessage=Unable to execute service WORKFLOW_EDIT_REV and function addFiles.<br>The error was caused by an internally generated issue. The error has been logged.] 0.152878999710083(secs)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a simple Criteria workflow with one step, where the Reviewer can Review and Edit the files.
2. Check a file into a folder. Make sure the item is Released.
3. Check another, differently-named file into the same folder, but set the metadata so it goes into the workflow.
4. As the reviewer, check the second item out.
5. Check the item back in, but on the Check-in form, select a file named the same as the first file already in the folder.
6. The checkin will fail, and the error will be displayed.

Cause

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