My Oracle Support Banner

Unable to Register an ESB Service when Using a Database Slide Repository (Doc ID 854082.1)

Last updated on MARCH 06, 2019

Applies to:

Oracle Enterprise Service Bus - Version 10.1.3.1 to 10.1.3.4 [Release AS10gR3]
Information in this document applies to any platform.
***Checked for relevance on 26-Sep-2011***


Symptoms

On SOA Suite 10.1.3 when attempting to register an ESB service using ANT scripts or JDeveloper, the following error occurs:

ERROR
[deployESBProjects] <description>An unhandled exception has been thrown in the ESB
system. The exception reported is: "javax.transaction.RollbackException: Timed out
[deployESBProjects] at
com.evermind.server.ApplicationServerTransaction.checkForRollbackOnlyWhileInCommit(ApplicationServer
Transaction.java:664)
[deployESBProjects] at
com.evermind.server.ApplicationServerTransaction.doCommit(ApplicationServerTransaction.java:273)
[deployESBProjects] at
com.evermind.server.ApplicationServerTransaction.commit(ApplicationServerTransaction.java:162)
....
[deployESBProjects] Deployment Failed ...Unhandled Exception
[deployESBProjects] java.lang.Exception: Deployment attempt failed, please review deployment
attempt response above
[deployESBProjects] at
oracle.tip.esb.client.anttasks.DeploymentHelper.deploy(DeploymentHelper.java:112)
[deployESBProjects] at
oracle.tip.esb.client.anttasks.DeploymentHelper.deploy(DeploymentHelper.java:159)

...


Also, in $ORACLE_HOME/j2ee/<ESB Designtime container, e.g. oc4j_soa or oc4j_esbdt>/log/oc4j_*_default_group_1/oc4j/log.xml, you should see:

<PAYLOAD>
<MSG_TEXT>Exception occured while enqueuing control event</MSG_TEXT>
<SUPPL_DETAIL><![CDATA[javax.jms.JMSException: allocateConnection: javax.resource.spi.EISSystemException: Error occurred when attempting to create a JMS connection: oracle.jms.AQjmsException: Error creating the db_connection.: oracle.jms.AQjmsException: Error creating the db_connection
at oracle.j2ee.ra.jms.generic.RAUtils.make(RAUtils.java:525)
at oracle.j2ee.ra.jms.generic.RAUtils.toJMSException(RAUtils.java:199)
at oracle.j2ee.ra.jms.generic.CommonFactoryWrapper.localCreateConnection...

....
<PAYLOAD>
<MSG_TEXT>Commit Failed due to Timed out</MSG_TEXT>
<SUPPL_DETAIL><![CDATA[javax.transaction.RollbackException: Timed out
at com.evermind.server.ApplicationServerTransaction.checkForRollbackOnlyWhileInCommit(ApplicationServerTransaction.java:664)
at com.evermind.server.ApplicationServerTransaction.doCommit(ApplicationServerTransaction.java:273)
at com.evermind.server.ApplicationServerTransaction.commit(ApplicationServerTransaction.java:162)
at com.evermind.server.ApplicationServerTransactionManager.commit(ApplicationServerTransactionManager.java:472)


The issue can be reproduced with the following steps:

1. Configure SOA Suite to use the database slide repository

See Oracle ® Application Server Enterprise Deployment Guide
10g Release 3 (10.1.3.3.0)
Part Number E10294-02

3.23 Configuring JNDIs for the Topic and Topic Connection Factory
3.24 Updating the Oracle Enterprise Service Bus Metadata
3.25 Configuring the Slide Repository to use the Database as the Repository

2. Try to register an ESB service using an ANT script (or JDeveloper)

<MSG_TEXT>Exception occured while enqueuing control event</MSG_TEXT>
<SUPPL_DETAIL><![CDATA[javax.jms.JMSException: allocateConnection:
javax.resource.spi.EISSystemException: Error occurred when attempting to create a JMS connection:
oracle.jms.AQjmsException: Error creating the db_connection.: oracle.jms.AQjmsException: Error
creating the db_connection
at oracle.j2ee.ra.jms.generic.RAUtils.make(RAUtils.java:525)

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
References

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