Friday, December 14, 2012

Timed out when making request to XAResource

Error Log Trace :

[2012-09-11T19:58:01.053+05:30] [AdminServer] [ERROR] [] [oracle.soa.adapter] [tid: weblogic.work.j2ee.J2EEWorkManager$WorkWithListener@1d4729d] [userId: <anonymous>] [ecid: 0000Jap5w7iCSs05Rz^Ayd1GJm2d000002,0] [APP: soa-infra] weblogic.transaction.RollbackException: Transaction has timed out when making request to XAResource 'EBSDS_base_domain'.[[
javax.resource.ResourceException: weblogic.transaction.RollbackException: Transaction has timed out when making request to XAResource 'EBSDS_base_domain'.atoracle.tip.adapter.fw.jca.messageinflow.MessageEndpointImpl.afterDelivery(MessageEndpointImpl.java:308) atoracle.tip.adapter.aq.v2.database.AbstractDequeueAgent$AQDeliveryBean.afterOnMessage(AbstractDequeueAgent.java:607)at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent$AQDeliveryBean.access$100(AbstractDequeueAgent.java:473)
at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.run(AbstractDequeueAgent.java:157)

Reason :

oracle.soa.adapter : indicates the error had resulted from JCA Adapter .

 XAResource 'EBSDS_base_domain :   EBSDS is datasource being used to make  database connection to EBS Suite( in my case ) for  base_domain.

JDBC datasource was not able connect to database with which it was configured at design time.

Solution : 

Try to check if the database in being up or down with help of Toad or Oracle SQL Developer.
Or Try to make new JDBC DataSource in Weblogic console using the same same database name, hostname, port, password  and try to test the connection.

No comments:

Post a Comment