We are facing an strange issue in weblogic
JDBC Connection. Daily for our application we run "End of Day" (EOD). This EOD includes several branches and tasks for Interest calculation branch wise.
We have around 150+ branches for which this tasks are scheduled and completes one by one. It is observerd that our EOD gets stuck and below error is observed in weblogic logs.
When we retry the job it continues, this happens daily now. we are not able to figure why this happens.
Sharing the log below, please assist if any one knows a solution here.
2019-03-30 03:12:05,399 ERROR [[ACTIVE] ExecuteThread: '55' for queue: 'weblogic.kernel.Default (self-tuning)'] [transaction-id=933b69d3e018eb33:1cb19089:169cb4de31b:-16c0|RequestConvId=933b69d3e018eb33X1cb19089X169cb4de31bX-16c1] JDBCExceptionReporter Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_RMERR start() failed on resource 'ZONE_TIPLUS_PROD': XAER_RMERR : A resource manager error has occured in the transaction branch
oracle.jdbc.xa.OracleXAException
at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1110)
at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:240)
at weblogic.jdbc.jta.DataSource.start(DataSource.java:811)
at weblogic.transaction.internal.XAServerResourceInfo.start(XAServerResourceInfo.java:1250)
We are using weblogic 11g and our database is oracle 11 g version.