While Trying to Publish Messages from SIM, 'PublishException: XAPublish()...could Not Close Database or Topic Connection' Error Is Encountered (Doc ID 1533194.1)

Last updated on NOVEMBER 30, 2016

Applies to:

Oracle Retail Store Inventory Management - Version 13.1 and later
Information in this document applies to any platform.

Symptoms

The following error is found in sim.log after trying to publish any messages from SIM:

2013-02-11 14:13:01,058 DEBUG [SystemThreadGroup-9][dataaccess.DataSourceDbThreadLocalConnectionFactory] getThreadLocalConnection clean(): closing thread local connection
2013-02-11 14:13:01,066 ERROR [SystemThreadGroup-9][polling-timers] error in processStagedMessages()!
java.lang.RuntimeException: com.retek.rib.binding.exception.PublishException: XAPublish()...could not close database or topic connection.
  at com.evermind.server.ejb.AbstractEJBObject.OC4J_handleUncheckedException(AbstractEJBObject.java:402)
  at ApplicationMessagePublisher_RemoteProxy_6787m9e.publish(Unknown Source)
  at sun.reflect.GeneratedMethodAccessor29.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:618)
  at com.evermind.server.rmi.RmiMethodCall.run(RmiMethodCall.java:53)
  at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
  at java.lang.Thread.run(Thread.java:810)
  at com.evermind.server.rmi.RMICall.warningExceptionOriginatesFromTheRemoteServer(RMICall.java:109)
  at com.evermind.server.rmi.RMICall.throwRecordedException(RMICall.java:129)
  at com.evermind.server.rmi.RMIClientConnection.obtainRemoteMethodResponse(RMIClientConnection.java:571)
  at com.evermind.server.rmi.RMIClientConnection.invokeMethod(RMIClientConnection.java:515)
  at com.evermind.server.rmi.RemoteInvocationHandler.invoke(RemoteInvocationHandler.java:63)
  at com.evermind.server.rmi.RecoverableRemoteInvocationHandler.invoke(RecoverableRemoteInvocationHandler.java:28)
  at com.evermind.server.ejb.StatelessSessionRemoteInvocationHandler.invoke(StatelessSessionRemoteInvocationHandler.java:43)
  at __Proxy4.publish(Unknown Source)

 

Changes

 

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