How to Fix the Error, "There are no connections available from pool for provider SystemDatabase" (Doc ID 787619.1)

Last updated on MARCH 21, 2017

Applies to:

Oracle WebCenter Content - Version 7.5.1 to 10.1.3.3.3 [Release Stellent to 10gR3]
Information in this document applies to any platform.
Checked for currency 30-JUL-2013

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`


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)

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