Unable To Checkin Content Due To "ORA-00001:unique constraint (<OCS>.PK_FILESTORAGE) violated" Exceptions

(Doc ID 2244276.1)

Last updated on MARCH 17, 2017

Applies to:

Oracle WebCenter Content - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Symptoms

Receive the following error when trying to checkin content:

"Unable to execute query 'lfileStorage'. ORA-00001:unique constraint (<OCS_Schema>.PK_FILESTORAGE) violated"

 

The following stack trace was found in the UCM diagnostic log.

[2017-02-17T08:42:06.482-05:00] [UCM_server2] [ERROR] [UCM-CS-000001] [oracle.ucm.idccs] [tid: [ACTIVE].ExecuteThread: '9' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: cwoods] [ecid: 2e4f18bd6d3b3fa1:1055e978:15a489cc49d:-8000-00000000000d7936,0] [APP: Oracle Universal Content Management - Content Server] [DSID: 0000LdCJXxy0FwYFLr6UOA1OdWhp00000D] general exception[[
intradoc.common.ServiceException: !csFsSaveFileError,/dev/shm/1902728273.png
*ScriptStack CHECKIN_NEW_SUB
3:doSubService,**no captured values**CHECKIN_UNIVERSAL_SUB,**no captured values**3:doScriptableAction,**no captured values**3:determineCheckin,**no captured values**CHECKIN_NEW_SUB,**no captured values**3:addFiles,dID=156090,dDocName=ID_154134
       at intradoc.filestore.jdbc.JdbcStorage.saveStream(JdbcStorage.java:194)
       at intradoc.filestore.jdbc.JdbcStorage.storeFromInputStream(JdbcStorage.java:147)
       at intradoc.filestore.jdbc.JdbcStorage.storeFromLocalFile(JdbcStorage.java:96)
       at intradoc.filestore.filesystem.FileSystemAccessImplementor.storeFromLocalFile(FileSystemAccessImplementor.java:92)
       at intradoc.filestore.filesystem.BaseAccessImplementor.storeFromStreamWrapper(BaseAccessImplementor.java:149)
       at intradoc.filestore.BaseFileStore.storeFromStreamWrapper(BaseFileStore.java:468)
       at intradoc.server.DocServiceHandler.addFileToFileStore(DocServiceHandler.java:4002)
...
Caused by: intradoc.data.DataException: !csDbUnableToExecuteQuery,IfileStorage!$ORA-00001: unique constraint (UCMHA_OCS.PK_FILESTORAGE) violated

       at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2729)
       at intradoc.jdbc.JdbcWorkspace.execute(JdbcWorkspace.java:683)
       at intradoc.filestore.jdbc.JdbcStorage.executeStoreQuery(JdbcStorage.java:985)
       at intradoc.filestore.jdbc.JdbcStorage.saveStream(JdbcStorage.java:190)
       ... 128 more



Changes

 None

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