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

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle ESB - 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

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