Error Occurs, "There are no connections available from pool for provider SystemDatabase"
(Doc ID 787619.1)
Last updated on MARCH 05, 2024
Applies to:
Oracle WebCenter Content - Version 7.5.1 to 10.1.3.3.3 [Release Stellent to 10gR3]Oracle WebCenter Content - Version 12.2.1.3.0 to 12.2.1.3.0 [Release 12c]
Information in this document applies to any platform.
Symptoms
The database is inaccessible and/or the available connections to the database are completely expended.
Additionally, the following error messages (or others that are similar) may be displayed:
Unable to execute service <service_name> and function <function_name>.
System Error: There are no connections available from pool for provider `SystemDatabase`
System Error: There are no connections available from pool for provider `SystemDatabase`
NOTE: The <service_name> and <function_name> are specific to the request that was being processed at the time of the error and may not be the same with each occurrence/user.
An example of this error is shown below when trying to checkin a document through the Batchloader application.
Content item '(null)' was not successfully checked in. (System Error: There are no connections available from pool for provider 'SystemDatabase'.) [ Details ]
An error has occurred. The stack trace below shows more information.
!csUnableToCheckIn,(null)!csSystemError,\!csNoConnectionsAvailable\,SystemDatabase
intradoc.common.ServiceException: !csUnableToCheckIn,(null)!csSystemError,\!csNoConnectionsAvailable\,SystemDatabase
at intradoc.server.Service.buildServiceException(Unknown Source)
at intradoc.server.Service.createServiceExceptionEx(Unknown Source)
at intradoc.server.Service.createServiceException(Unknown Source)
at intradoc.server.Service.doActions(Unknown Source)
at intradoc.server.Service.doRequest(Unknown Source)
at intradoc.server.ServiceManager.processCommand(Unknown Source)
at intradoc.apps.shared.StandAloneApp.executeService(Unknown Source)
at intradoc.apps.shared.AppLauncher.executeService(Unknown Source)
at intradoc.apps.shared.AppLauncher.executeService(Unknown Source)
at intradoc.apputilities.batchloader.BatchLoaderApp.processRecord(Unknown Source)
at intradoc.apputilities.batchloader.BatchLoaderApp.processBatchLoaderFile(Unknown Source)
at intradoc.apputilities.batchloader.BatchLoaderApp$1.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)
Caused by: intradoc.data.DataException: !csNoConnectionsAvailable,SystemDatabase
at intradoc.jdbc.JdbcWorkspace.beginTran(Unknown Source)
An error has occurred. The stack trace below shows more information.
!csUnableToCheckIn,(null)!csSystemError,\!csNoConnectionsAvailable\,SystemDatabase
intradoc.common.ServiceException: !csUnableToCheckIn,(null)!csSystemError,\!csNoConnectionsAvailable\,SystemDatabase
at intradoc.server.Service.buildServiceException(Unknown Source)
at intradoc.server.Service.createServiceExceptionEx(Unknown Source)
at intradoc.server.Service.createServiceException(Unknown Source)
at intradoc.server.Service.doActions(Unknown Source)
at intradoc.server.Service.doRequest(Unknown Source)
at intradoc.server.ServiceManager.processCommand(Unknown Source)
at intradoc.apps.shared.StandAloneApp.executeService(Unknown Source)
at intradoc.apps.shared.AppLauncher.executeService(Unknown Source)
at intradoc.apps.shared.AppLauncher.executeService(Unknown Source)
at intradoc.apputilities.batchloader.BatchLoaderApp.processRecord(Unknown Source)
at intradoc.apputilities.batchloader.BatchLoaderApp.processBatchLoaderFile(Unknown Source)
at intradoc.apputilities.batchloader.BatchLoaderApp$1.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)
Caused by: intradoc.data.DataException: !csNoConnectionsAvailable,SystemDatabase
at intradoc.jdbc.JdbcWorkspace.beginTran(Unknown Source)
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 |
| Cause |
| Solution |