Error On An Xa Recover Operation
v601rnotes Technote (troubleshooting) Problem(Abstract) When WebSphere Application Server attempts to recover Oracle database transactions, the following exception is issued:
WTRN0037W: The transaction service encountered an error on an xa_recover operation. The resource was com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl@1114a62. The error code was XAER_RMERR. The exception stack trace follows: javax.transaction.xa.XAException
at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:726)
at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.recover(WSRdbXaResourceImpl.java:954)
at com.ibm.ws.Transaction.JTA.XARminst.recover(XARminst.java:137)
at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecoveryData.java:609)
at com.ibm.ws.Transaction.JTA.PartnerLogTable.recover(PartnerLogTable.java:511)
at com.ibm.ws.Transaction.JTA.RecoveryManager.resync(RecoveryManager.java:1784)
at com.ibm.ws.Transaction.JTA.RecoveryManager.run(RecoveryManager.java:2241) Cause Oracle requires that you have special permissions to attempt to perform the recovery. If there is a system crash during a distributed transaction, the WebSphere Application Server transaction manager will attempt to clean up any failed transactions which it finds in the transaction logs. When the recovery involves an Oracle XAResource, the Oracle JDBC driver oracle.jdbc.xa.OracleXAResource.recover function will make a call to DIST_TXN_SYNC. The above error occurs when the user trying to execute the .recover method does not have sufficient privileges to make a call to DIST_TXN_SYNC. Environment This problem can occur with all versions of Oracle: 8i, 9i, 10g, 11g, and 12g. Resolving the problem Run the following commands as user SYS: grant select on pending_trans$ to
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in Java - JDBC Archive All PlacesOracle CommunityArchived ForumsJava - JDBC Archive This discussion is archived http://www.ibm.com/support/docview.wss?uid=swg21196663 7 Replies Latest reply on Jun 22, 2011 6:35 PM by 870741 error on an xa_recover operation. 484415 Jan 22, 2015 9:20 AM Hi, We are using XA-Drivers for Oracle datasource as we are managing distributed 2-phase transactions in our application. Recently after the Appserver (Wepsphere 5.1.1, JDK https://community.oracle.com/thread/378954 1.4) crash i started getting the following error. i am using ojdbc14.jar. 3d603837 XARminst E WTRN0037W: The transaction service encountered an error on an xa_recover operation. The resource was CMXAResourceInfo: DataSource Properties [oracle.jdbc.xa.client.OracleXADataSource]: . The error code was XAER_RMERR. The exception stack trace follows: javax.transaction.xa.XAException at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:526) at com.ibm.ws.Transaction.JTA.XARminst.recover(XARminst.java:130) at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecoveryData.java:673) at com.ibm.ws.Transaction.JTA.RecoveryManager.resync(RecoveryManager.java:1407) at com.ibm.ws.Transaction.JTA.ResyncThread.run(RecoveryManager.java:1440) As stated in the following link (on ibm site) i issued the following grants on our development site and it solved my problem. http://www-1.ibm.com/support/docview.wss?rs=0&q1=3979190&uid=swg21196663&loc=en_US&cs=utf-8&cc=us&lang=en Oracle bug listing: 3979190 grant select on dba_pending_transactions to public; grant execute on dbms_system to public; However on production environments execute on dbms_system to public is not permitted. Is there another way out by which i can solve this ? Thanks, MP Edited by: Mukesh on Sep 20, 2009 9:57 PM 15081Views Tags: none (add) This content has been marked as fi
sophisticated digital experiences Web content & Customer Journey Sitefinity CMS Build engaging websites with intuitive web content management Application Development, Testing & Deployment DevCraft Leverage a http://knowledgebase.progress.com/articles/Article/P187826 complete UI toolbox for web, mobile and desktop development OpenEdge Build, https://coderanch.com/t/76395/Websphere/XA-Exception protect and deploy apps across any platform and mobile device Kendo UI Build rich, smart HTML5 and JavaScript apps for any platform, browser or device Telerik Platform Build mobile apps for iOS, Android and Windows Phone Nativescript Use Angular, TypeScript or JavaScript error on to build truly native mobile apps Rollbase Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud Test Studio Automate UI, load and performance testing for web, desktop and mobile Modulus Host, deploy and scale Node.js, Java and .NET Core apps on premise or in the cloud Data Connectivity DataDirect Connectors error on an Optimize data integration with high-performance connectivity Business Rules Management Corticon Automate decision processes with a no-code business rules engine View All Products Solutions Digital Business Transformation Transform your businesses in order to survive in a completely digitized and connected world driven by software innovation. Web Scale Globally scale websites with innovative content management and infrastructure approaches Modernization UX and app modernization to powerfully navigate todays digital landscape Omni-Channel Engagement Content-focused web and mobile solution for empowering marketers aPaaS Fuel agility with ever-ready applications, built in the cloud Enterprise Mobility Faster, tailored mobile experiences for any device and data source New & Trending E-book The Digital Ultimatum: Why Businesses Must Digitally Transform to Survive â€" and Thrive Survey Report The State of Digital Business Support & Learning Support Support Services Knowledge Base Customer Order Management Download Center Services Training Consulting Services Managed Database Offering Learning Documentation Webinars How-To Videos Whitepapers Community Blogs Success Stories Partners Company Login Progress Support
This Site Careers Other all forums Forum: WebSphere XA Exception Celine Wong Greenhorn Posts: 6 posted 11 years ago Hi, i've encounterd the following error message from WAS and having headache troubleshouting it. We're using WAS 5.1 and Oracle 9i. The datasource is configured to use oracle.jdbc.xa.client.OracleXADataSource in order to handle global transaction across different datasource. We obtain the data source connection through thin client. I have not been able to find out any specific pattern on when this exception is thrown. It seems to try doing some data recovery with Oracle yet failed. Between it seems to cause my server out of memory error. Appreciate if anyone can enlighten me in any aspect. Thanks. error extracted fr SystemOut.log [3/16/05 15:48:32:099 SGT] 1cae5b7 WSRdbDataSour I DSRA8203I: Database product name : Oracle [3/16/05 15:48:32:101 SGT] 1cae5b7 WSRdbDataSour I DSRA8204I: Database product version : Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production With the Partitioning option JServer Release 9.2.0.5.0 - Production [3/16/05 15:48:32:102 SGT] 1cae5b7 WSRdbDataSour I DSRA8205I: JDBC driver name : Oracle JDBC driver [3/16/05 15:48:32:103 SGT] 1cae5b7 WSRdbDataSour I DSRA8206I: JDBC driver versi on : 9.2.0.5.0 [3/16/05 15:48:32:116 SGT] 1cae5b7 WSRdbXaResour E DSRA0304E: XAException occu rred. XAException contents and details are: The cause is : null. [3/16/05 15:48:32:158 SGT] 1cae5b7 WSRdbXaResour E DSRA0302E: XAException occu rred. Error code is: XAER_RMERR. Exception is: