Win a copy of Cloud Native PatternsE this week in the Cloud forum
or Natural Language Processing in the AI/ML forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Devaka Cooray
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Paul Clapham
  • Knute Snortum
  • Rob Spoor
Saloon Keepers:
  • Tim Moores
  • Ron McLeod
  • Piet Souris
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Frits Walraven
  • Ganesh Patekar

DB Connectivity Issue : XAER_RMERR : A resource manager error has occured in the transaction branch

 
Ranch Hand
Posts: 119
Oracle Opera Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!