My Oracle Support Banner

RT publishing failing due to "java.sql.SQLException: Connection has already been closed." on weblogic (Doc ID 1914000.1)

Last updated on JULY 07, 2017

Applies to:

Oracle WebCenter Sites - Version 11.1.1.8.0 and later
Information in this document applies to any platform.

Symptoms

Realtime publishing is failing.

On the publishing source it reports:

[2014-07-28 14:00:34,200 EDT] [ERROR] [.kernel.Default (self-tuning)'] [logging.cs.xcelerate.publish] Transport error -100: Created temporary table tt1386277770056
...
Command failed:replacerows
Added row: id = 1385087934184
Added row: id = 1385087934192
Added row: id = 1385087934200
Added row: id = 1385087934160
Added row: id = 1385087934162
Added row: id = 1385087934164
Deleted temporary table tt1386277770056
<br>
Mirroring operation complete

[2014-07-28 14:00:34,200 EDT] [ERROR] [.kernel.Default (self-tuning)'] [logging.cs.xcelerate.publish] Exception occurred while mirroring
com.fatwire.cs.core.realtime.DataException: Error transporting data, errno=-100
    at com.fatwire.realtime.AbstractTransporter.execute(AbstractTransporter.java:123)
    at com.fatwire.realtime.PubMain._standardPublish(PubMain.java:340)
    at com.fatwire.realtime.PubMain.execute(PubMain.java:107)
    at jsp_servlet._jsp._cs_deployed._openmarket._xcelerate._prologactions._publish._advpub.__publishapprovedassets._jspService(__publishapprovedassets.java:110)
...
[2014-07-28 14:00:35,681 EDT] [ERROR] [.kernel.Default (self-tuning)'] [logging.cs.xcelerate.publish] Error during publish: java.lang.Exception: com.fatwire.cs.core.realtime.DataException: Error transporting data, errno=-100
com.fatwire.cs.core.realtime.DataException: java.lang.Exception: com.fatwire.cs.core.realtime.DataException: Error transporting data, errno=-100
    at com.fatwire.realtime.AbstractTransporter.execute(AbstractTransporter.java:157)
    at com.fatwire.realtime.PubMain._standardPublish(PubMain.java:340)
    at com.fatwire.realtime.PubMain.execute(PubMain.java:107)
    at jsp_servlet._jsp._cs_deployed._openmarket._xcelerate._prologactions._publish._advpub.__publishapprovedassets._jspService(__publishapprovedassets.java:110)
...
Caused by: java.lang.Exception: com.fatwire.cs.core.realtime.DataException: Error transporting data, errno=-100
    ... 64 more
Caused by: com.fatwire.cs.core.realtime.DataException: Error transporting data, errno=-100
    at com.fatwire.realtime.AbstractTransporter.execute(AbstractTransporter.java:123)
    ... 63 more
[2014-07-28 14:00:35,739 EDT] [INFO ] [.kernel.Default (self-tuning)'] [logging.cs.xcelerate.publish] FAILED RealTime publish session 1385087934060
[2014-07-28 14:00:38,488 EDT] [INFO ] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.xml] Publish failed for approved assets (error number: -508).

And on publishing target it reports:

[2014-07-28 14:00:03,215 EDT] [INFO ] [.kernel.Default (self-tuning)'] [beans.factory.xml.XmlBeanDefinitionReader] Loading XML bean definitions from class path resource [AdvPub.xml]
...
[2014-07-28 14:00:27,097 EDT] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] Exception updating a row in table tt1386277770056
java.sql.SQLException: Connection has already been closed.
    at weblogic.jdbc.wrapper.PoolConnection.checkConnection(PoolConnection.java:62)
    at weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:100)
    at weblogic.jdbc.wrapper.PoolConnection.setAutoCommit(PoolConnection.java:151)
    at com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:163)
    at COM.FutureTense.CatalogManager.CatalogEngine.replaceRows_trans(CatalogEngine.java:1558)
    at COM.FutureTense.CatalogManager.CatalogEngine.replaceRows(CatalogEngine.java:1355)
    at COM.FutureTense.Common.CatalogManager.execute(CatalogManager.java:1987)

 

Changes

The datasource of the publishing target environment has Inactive Connection Timeout set to a short period of time, e.g. 120 (seconds):

   <inactive-connection-timeout-seconds>120</inactive-connection-timeout-seconds>

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


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