"Failed to setAutoCommit to true for pool connection" Error In the WebCenter Content (formally UCM) Application (Doc ID 1369489.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle WebCenter Content - Version 11.1.1.3.0 and later
Information in this document applies to any platform.
Checked for Relevancy 05-JUL-2013

Symptoms

In the Content Server, errors like the following are being thrown:

Unable to publish the schema. There are no connections available from pool for provider 'SystemDatabase'. Unable to execute service method 'getConnection'. Unable to execute service method 'getConnection'. Runtime error: java.lang.RuntimeException: Failed to setAutoCommit to true for pool connection. [ Details ]
An error has occurred. The stack trace below shows more information.

!csSchemaUnableToPublish!csNoConnectionsAvailable,SystemDatabase!csUnableToExecMethod,getConnection!csUnableToExecMethod,getConnection!syServiceRuntime,java.lang.RuntimeException: Failed to setAutoCommit to true for pool connection.
intradoc.data.DataException: !csNoConnectionsAvailable,SystemDatabase!csUnableToExecMethod,getConnection
at intradoc.provider.ProviderPoolManager.assignConnection(ProviderPoolManager.java:850)
at intradoc.provider.ProviderPoolManager.getConnectionEx(ProviderPoolManager.java:359)
at intradoc.jdbc.JdbcWorkspace.getJdbcConnectionEx(JdbcWorkspace.java:356)
at intradoc.jdbc.JdbcWorkspace.getJdbcConnection(JdbcWorkspace.java:350)
at intradoc.jdbc.JdbcWorkspace.getTableList(JdbcWorkspace.java:1407)
at intradoc.server.schema.StandardSchemaManager.refresh(StandardSchemaManager.java:369)
at intradoc.server.schema.StandardSchemaManager.refresh(StandardSchemaManager.java:324)
at intradoc.server.schema.StandardSchemaPublisher.doPublishing(StandardSchemaPublisher.java:241)
at intradoc.server.schema.StandardSchemaPublisherThread.run(StandardSchemaPublisherThread.java:256)
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:896)
at intradoc.provider.ProviderPoolManager.getNextAvailablePoolConnection(ProviderPoolManager.java:863)
at intradoc.provider.ProviderPoolManager.assignConnection(ProviderPoolManager.java:835)
... 8 more
Caused by: java.lang.RuntimeException: Failed to setAutoCommit to true for pool connection.
at weblogic.jdbc.wrapper.PoolConnection.init(PoolConnection.java:49)
at weblogic.jdbc.common.internal.RmiDataSource.getPoolConnectionObj(RmiDataSource.java:379)
at weblogic.jdbc.common.internal.RmiDataSource.getPoolConnection(RmiDataSource.java:346)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:360)
at sun.reflect.GeneratedMethodAccessor101.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at intradoc.common.IdcMethodHolder.invokeMethod(IdcMethodHolder.java:87)
at intradoc.common.ClassHelperUtils.executeIdcMethodConvertToStandardExceptions(ClassHelperUtils.java:406)
... 11 more


After a restart of the UCM managed server, the errors will go away for a limited time but then they will return.

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