Unable To Checkin Content Due To "ORA-00001:unique constraint (<OCS>.PK_FILESTORAGE) violated" Exceptions
(Doc ID 2244276.1)
Last updated on JULY 20, 2024
Applies to:
Oracle WebCenter Content - Version 11.1.1.9.0 and laterInformation in this document applies to any platform.
Symptoms
Receive the following error when trying to checkin content:
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |