On a Clustered Installation of UCM, When Trying to Create a Virtual Folder From the User Interface, This Error Occurs: "Unable to execute service COLLECTION_ADD and function addCollectionInCo (Doc ID 1137211.1)

Last updated on JUNE 21, 2017

Applies to:

Oracle WebCenter Content - Version: 10.1.3.5.0 and later   [Release: 10gR3 and later ]
Information in this document applies to any platform.

Symptoms


On a clustered Linux Content Server version 10.1.3.5.0, when attempting to create a new folder using the User Interface, the following error occurs:


ewbsacovn43: Event generated by user 'sysadmin' at host 'ewbsacovn43.ebiz.verizon.com:81'. Unable to execute service COLLECTION_ADD and function addCollectionInCollection.
(System Error: Unable to execute query 'Icollection(INSERT INTO Collections (dCollectionID, dCollectionGUID, dParentCollectionID, dCollectionName, dCollectionType,
dCollectionQueries, dCollectionEnabled, dPromptForMetadata, dCollectionInherit, dChildManipulation, dCollectionCreator, dCreateDate,
dCollectionModifier, dCollectionMark, dCollectionOwner, dLastModifiedDate,
dDependent, dInDate, dOutDate, dReleaseDate, dDocName, dDocType, dDocTitle, dDocAuthor, dRevLabel, dSecurityGroup, dDocAccount)
values(1, '017E8708-AE16-28F3-1D3C-9A51A91FAD25', 793000002, 'DevTeam Test', 0, 1, 1, 0, 0, 1, 'sysadmin', {ts '2010-05-26 17:20:26.402'}, 'sysadmin', '', 'sysadmin', {ts '2010-05-26 17:20:26.402'}, '', null, null, null, '', '', '', '', '', '', ''))'. ORA-00001: unique constraint (EDMS_AUTH.PK_COLLECTIONID) violated) Unable to execute query 'Icollection(INSERT INTO Collections (dCollectionID, dCollectionGUID, dParentCollectionID, dCollectionName, dCollectionType,
dCollectionQueries, dCollectionEnabled, dPromptForMetadata, dCollectionInherit, dChildManipulation, dCollectionCreator, dCreateDate,
dCollectionModifier, dCollectionMark, dCollectionOwner, dLastModifiedDate,
dDependent, dInDate, dOutDate, dReleaseDate, dDocName, dDocType, dDocTitle, dDocAuthor, dRevLabel, dSecurityGroup, dDocAccount)
values(1, '017E8708-AE16-28F3-1D3C-9A51A91FAD25', 793000002, 'DevTeam Test', 0, 1, 1, 0, 0, 1, 'sysadmin', {ts '2010-05-26 17:20:26.402'}, 'sysadmin', '', 'sysadmin', {ts '2010-05-26 17:20:26.402'}, '', null, null, null, '', '', '', '', '', '', ''))'. ORA-00001: unique constraint (EDMS_AUTH.PK_COLLECTIONID) violated
java.sql.SQLException: ORA-00001: unique constraint (EDMS_AUTH.PK_COLLECTIONID) violated [ Details ]
An error has occurred. The stack trace below shows more information.
$ewbsacovn43: !csUserEventMessage,sysadmin,ewbsacovn43.ebiz.verizon.com:81!$!csServiceDataException,COLLECTION_ADD,addCollectionInCollection!$!csSystemError,\!csDbUnableToExecuteQuery\,Icollection(INSERT INTO Collections (dCollectionID\\\, dCollectionGUID\\\, dParentCollectionID\\\, dCollectionName\\\, dCollectionType\\\,<br> dCollectionQueries\\\, dCollectionEnabled\\\, dPromptForMetadata\\\, dCollectionInherit\\\, dChildManipulation\\\, dCollectionCreator\\\, dCreateDate\\\,<br> dCollectionModifier\\\, dCollectionMark\\\, dCollectionOwner\\\, dLastModifiedDate\\\,<br> dDependent\\\, dInDate\\\, dOutDate\\\, dReleaseDate\\\, dDocName\\\, dDocType\\\, dDocTitle\\\, dDocAuthor\\\, dRevLabel\\\, dSecurityGroup\\\, dDocAccount)<br> values(1\\\, '017E8708-AE16-28F3-1D3C-9A51A91FAD25'\\\, 793000002\\\, 'DevTeam Test'\\\, 0\\\, 1\\\, 1\\\, 0\\\, 0\\\, 1\\\, 'sysadmin'\\\, {ts '2010-05-26 17:20:26.402'}\\\, 'sysadmin'\\\, ''\\\, 'sysadmin'\\\, {ts '2010-05-26 17:20:26.402'}\\\, ''\\\, null\\\, null\\\, null\\\, ''\\\, ''\\\, ''\\\, ''\\\, ''\\\, ''\\\, ''))\!$ORA-00001: unique constraint (EDMS_AUTH.PK_COLLECTIONID) violated<br>!csDbUnableToExecuteQuery,Icollection(INSERT INTO Collections (dCollectionID\, dCollectionGUID\, dParentCollectionID\, dCollectionName\, dCollectionType\,<br> dCollectionQueries\, dCollectionEnabled\, dPromptForMetadata\, dCollectionInherit\, dChildManipulation\, dCollectionCreator\, dCreateDate\,<br> dCollectionModifier\, dCollectionMark\, dCollectionOwner\, dLastModifiedDate\,<br> dDependent\, dInDate\, dOutDate\, dReleaseDate\, dDocName\, dDocType\, dDocTitle\, dDocAuthor\, dRevLabel\, dSecurityGroup\, dDocAccount)<br> values(1\, '017E8708-AE16-28F3-1D3C-9A51A91FAD25'\, 793000002\, 'DevTeam Test'\, 0\, 1\, 1\, 0\, 0\, 1\, 'sysadmin'\, {ts '2010-05-26 17:20:26.402'}\, 'sysadmin'\, ''\, 'sysadmin'\, {ts '2010-05-26 17:20:26.402'}\, ''\, null\, null\, null\, ''\, ''\, ''\, ''\, ''\, ''\, ''))!$ORA-00001: unique constraint (EDMS_AUTH.PK_COLLECTIONID) violated<br>!syExceptionType2,java.sql.SQLException,ORA-00001: unique constraint (EDMS_AUTH.PK_COLLECTIONID) violated<br>
intradoc.common.ServiceException: !csServiceDataException,COLLECTION_ADD,addCollectionInCollection!$!csSystemError,\!csDbUnableToExecuteQuery\,Icollection(INSERT INTO Collections (dCollectionID\\\, dCollectionGUID\\\, dParentCollectionID\\\, dCollectionName\\\, dCollectionType\\\,
dCollectionQueries\\\, dCollectionEnabled\\\, dPromptForMetadata\\\, dCollectionInherit\\\, dChildManipulation\\\, dCollectionCreator\\\, dCreateDate\\\,
dCollectionModifier\\\, dCollectionMark\\\, dCollectionOwner\\\, dLastModifiedDate\\\,
dDependent\\\, dInDate\\\, dOutDate\\\, dReleaseDate\\\, dDocName\\\, dDocType\\\, dDocTitle\\\, dDocAuthor\\\, dRevLabel\\\, dSecurityGroup\\\, dDocAccount)
values(1\\\, '017E8708-AE16-28F3-1D3C-9A51A91FAD25'\\\, 793000002\\\, 'DevTeam Test'\\\, 0\\\, 1\\\, 1\\\, 0\\\, 0\\\, 1\\\, 'sysadmin'\\\, {ts '2010-05-26 17:20:26.402'}\\\, 'sysadmin'\\\, ''\\\, 'sysadmin'\\\, {ts '2010-05-26 17:20:26.402'}\\\, ''\\\, null\\\, null\\\, null\\\, ''\\\, ''\\\, ''\\\, ''\\\, ''\\\, ''\\\, ''))\!$ORA-00001: unique constraint (EDMS_AUTH.PK_COLLECTIONID) violated


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms