Getting Error "UCM-CS-000009 Intradoc.data.DataException: !csIdcCacheNotUniqueKeyError" (Doc ID 2527817.1)

Last updated on MAY 01, 2023

Applies to:

Symptoms

Using WebCenter Portal Cloud Service and the logs are flooded with the below error messages:

[2019-04-04T22:58:47.841+00:00] [<MANAGED_SERVER>] [ERROR] [] [oracle.ucm.idccs] [tid: Auto-Suggest index update.folderfolders.ffoldername] [ecid: <ECID>] [APP: Oracle Universal Content Management - Content Server] [partition-name: DOMAIN] [tenant-name: GLOBAL] UCM-CS-000009[[intradoc.data.DataException: !csJdbcGenericError
at intradoc.provider.ProviderPoolManager.assignConnection(ProviderPoolManager.java:893)
at intradoc.provider.ProviderPoolManager.getConnectionEx(ProviderPoolManager.java:385)
at intradoc.jdbc.JdbcWorkspace.getJdbcConnectionEx(JdbcWorkspace.java:361)
at intradoc.jdbc.JdbcWorkspace.getJdbcConnection(JdbcWorkspace.java:355)
at intradoc.jdbc.JdbcWorkspace.createResultSet(JdbcWorkspace.java:713)
at intradoc.server.cache.IdcCacheStore.loadEx(IdcCacheStore.java:131)
at intradoc.server.cache.IdcCacheStore.store(IdcCacheStore.java:261)
at intradoc.server.cache.IdcDefaultCacheRegion.put(IdcDefaultCacheRegion.java:157)
at intradoc.autosuggest.datastore.CacheStorage.update(CacheStorage.java:79)
at intradoc.autosuggest.datastore.GramStorage.update(GramStorage.java:41)
at intradoc.autosuggest.indexer.FieldContextIndex$FieldContextIndexWriter.indexTerm(FieldContextIndex.java:382)
at intradoc.autosuggest.indexer.FieldContextIndex$FieldContextIndexWriter.indexTerm(FieldContextIndex.java:346)
at intradoc.autosuggest.indexer.FieldContextIndex$FieldContextIndexWriter.index(FieldContextIndex.java:284)
at intradoc.autosuggest.indexer.AutoSuggestIndexHandler.index(AutoSuggestIndexHandler.java:134)
at intradoc.autosuggest.AutoSuggestManager.index(AutoSuggestManager.java:536)
at intradoc.autosuggest.AutoSuggestManager.index(AutoSuggestManager.java:243)
at intradoc.autosuggest.indexer.AutoSuggestIndexerThread.run(AutoSuggestIndexerThread.java:52)
at java.lang.Thread.run(Thread.java:748)
Caused by: intradoc.common.ServiceException: !csUnableToExecMethod,getConnection
at intradoc.common.ClassHelperUtils.convertToStandardException(ClassHelperUtils.java:202)
at intradoc.common.ClassHelperUtils.convertToStandardExceptionAndThrow(ClassHelperUtils.java:179)
at intradoc.common.ClassHelperUtils.executeIdcMethodConvertToStandardExceptions(ClassHelperUtils.java:410)
at intradoc.provider.ProviderPoolManager.getExternalRawConnection(ProviderPoolManager.java:939)
at intradoc.provider.ProviderPoolManager.getNextAvailablePoolConnection(ProviderPoolManager.java:906)
at intradoc.provider.ProviderPoolManager.assignConnection(ProviderPoolManager.java:878)
... 17 more
Caused by: weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool CSDS is Suspended, cannot allocate resources to applications..
at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:275)
at weblogic.jdbc.common.internal.RmiDataSource.getPoolConnection(RmiDataSource.java:552)
at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:643)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:594)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:587)
at sun.reflect.GeneratedMethodAccessor738.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:86)
at intradoc.common.ClassHelperUtils.executeIdcMethodConvertToStandardExceptions(ClassHelperUtils.java:406)
... 20 more

]]

The message appears in the managed server diagnostic log from WebCenter Content (WCC) every 10 seconds or so.

Cause

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