Showing posts with label SOA. Show all posts
Showing posts with label SOA. Show all posts

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.

ConnectionDeadSQLException & common.ResourceException


Error Log Trace:
internal Exception: weblogic.jdbc.extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException:0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: IO Error: The Network Adapter could not establish the connection.

Reason: 
The DB Service went down abrublty as This exception is generated when an application request to get a connection fails because the connection selected to be returned to the application from the pool fails the configured tests.
Weblogic tests a connection before it is given to a client.

Solution : 

Oracle DB Service need to be restarted !!