It's been published in several places, I guess but for the sake of simplicity:
Websphere 8.5, Oracle 11.2, datasource and transactions. You start your WAS server and see this in the logs:
[20.01.14 13:36:43:670 CET] 0000004f WSRdbXaResour E DSRA0304E: Wystapil wyjatek XAException. Tresc i szczególy wyjatku XAException: The cause is : null.
[20.01.14 13:36:43:671 CET] 0000004f WSRdbXaResour E DSRA0302E: Wystapil wyjatek XAException. Kod bledu: XAER_RMERR (-3). Wyjatek: <null>
[20.01.14 13:36:43:671 CET] 0000004f XARminst E WTRN0037W: Usluga transakcji napotkala blad w operacji xa_recover. Zasób: com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl@c6a9f4fb. Kod bledu: XAER_RMERR. Dane sledzenia stosu wyjatku: javax.transaction.xa.XAException
at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:709)
at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.recover(WSRdbXaResourceImpl.java:1116)
at com.ibm.ws.Transaction.JTA.XARminst.recover(XARminst.java:141)
at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecoveryData.java:716)
at com.ibm.tx.jta.impl.PartnerLogTable.recover(PartnerLogTable.java:431)
at com.ibm.tx.jta.impl.RecoveryManager.resync(RecoveryManager.java:1534)
at com.ibm.tx.jta.impl.RecoveryManager.performResync(RecoveryManager.java:2267)
at com.ibm.ws.tx.jta.RecoveryManager.performResync(RecoveryManager.java:117)
at com.ibm.tx.jta.impl.RecoveryManager.run(RecoveryManager.java:2220)
at java.lang.Thread.run(Thread.java:772)
the key is:
javax.transaction.xa.XAException
at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:709)
as there are some pending, unrecoverable transaction in the transaction log. there are two ways to deal with it:
- start your server, nevermind your business applications not working, go to console, Application servers > server1 > Transaction service, then to Runtime tab and there you can see some options to manually manage pending troublesome transactions:
- or alternate: stop server, go to <profileroot>/tranlog/(respective path)/tranlog & partnerlog, delete tranlog and partnerlog files. start server.
Now, the way no. 2 is advisable for development systems, where any data loss is irrelevant. For production, proceed with care and try way no.1 first. Should it fail, go hardcore and delete tranlog.
Good luck.
Websphere 8.5, Oracle 11.2, datasource and transactions. You start your WAS server and see this in the logs:
[20.01.14 13:36:43:670 CET] 0000004f WSRdbXaResour E DSRA0304E: Wystapil wyjatek XAException. Tresc i szczególy wyjatku XAException: The cause is : null.
[20.01.14 13:36:43:671 CET] 0000004f WSRdbXaResour E DSRA0302E: Wystapil wyjatek XAException. Kod bledu: XAER_RMERR (-3). Wyjatek: <null>
[20.01.14 13:36:43:671 CET] 0000004f XARminst E WTRN0037W: Usluga transakcji napotkala blad w operacji xa_recover. Zasób: com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl@c6a9f4fb. Kod bledu: XAER_RMERR. Dane sledzenia stosu wyjatku: javax.transaction.xa.XAException
at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:709)
at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.recover(WSRdbXaResourceImpl.java:1116)
at com.ibm.ws.Transaction.JTA.XARminst.recover(XARminst.java:141)
at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecoveryData.java:716)
at com.ibm.tx.jta.impl.PartnerLogTable.recover(PartnerLogTable.java:431)
at com.ibm.tx.jta.impl.RecoveryManager.resync(RecoveryManager.java:1534)
at com.ibm.tx.jta.impl.RecoveryManager.performResync(RecoveryManager.java:2267)
at com.ibm.ws.tx.jta.RecoveryManager.performResync(RecoveryManager.java:117)
at com.ibm.tx.jta.impl.RecoveryManager.run(RecoveryManager.java:2220)
at java.lang.Thread.run(Thread.java:772)
the key is:
javax.transaction.xa.XAException
at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:709)
as there are some pending, unrecoverable transaction in the transaction log. there are two ways to deal with it:
- start your server, nevermind your business applications not working, go to console, Application servers > server1 > Transaction service, then to Runtime tab and there you can see some options to manually manage pending troublesome transactions:
- or alternate: stop server, go to <profileroot>/tranlog/(respective path)/tranlog & partnerlog, delete tranlog and partnerlog files. start server.
Now, the way no. 2 is advisable for development systems, where any data loss is irrelevant. For production, proceed with care and try way no.1 first. Should it fail, go hardcore and delete tranlog.
Good luck.
This comment has been removed by a blog administrator.
ReplyDeleteMiddleware And Security Technical Blog: Dsra0302E: Xaexception. Error Code: Xaer_Rmerr (-3). Exception: >>>>> Download Now
Delete>>>>> Download Full
Middleware And Security Technical Blog: Dsra0302E: Xaexception. Error Code: Xaer_Rmerr (-3). Exception: >>>>> Download LINK
>>>>> Download Now
Middleware And Security Technical Blog: Dsra0302E: Xaexception. Error Code: Xaer_Rmerr (-3). Exception: >>>>> Download Full
>>>>> Download LINK GK
Great article ...Thanks for your great information, the contents are quiet interesting. I will be waiting for your next post.
ReplyDeleteBoligalarm uten binding
This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me..
ReplyDeletepython training in pune | python training institute in chennai | python training in Bangalore
Appreciating the persistence you put into your blog and detailed information you provide
ReplyDeleteJava training in Annanagar | Java training in Chennai
Java training in Chennai | Java training in Electronic city
I would assume that we use more than the eyes to gauge a person's feelings. Mouth. Body language. Even voice. You could at least have given us a face in this test.
ReplyDeleteData Science Training in Chennai | Data Science course in anna nagar
Data Science course in chennai | Data science course in Bangalore
Data Science course in marathahalli | Data Science course in btm layout
This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me..
ReplyDeletebest rpa training in chennai | rpa online training |
rpa training in chennai |
rpa training in bangalore
rpa training in pune
rpa training in marathahalli
rpa training in btm
This isn't correct. The reason why XAResource.recover usually fails with Oracle is because of a permissions issue - by default Oracle does not allow a standard userid that can connect to the database and perform SQL statements to execute XAResource.recover - those permissions need to be granted explicitly (see https://www-01.ibm.com/support/docview.wss?uid=swg21196663). Also there is no guarantee when deleting the logs that transactional consistency will be maintained. A standard modern transaction manager acting as the root (ie controller of the transaction outcome rather than a downstream subordinate branch) does not log the transaction until after preparing resources. The upside of this is it saves a forced write to the logs, the downside is that if the TM fails before this point it may have prepared resources but have no record of them in the log. To square the circle TM->resource protocols such as JTA-XA allow a TM to recover all indoubt transactions from the resources (that the TMs do log before this point), identify which they own (via a UUID in the XID) and rollback those which belong to the TM but it has no record of. This means that simply checking if the TM knows about the transaction and then deleting the logs risks leaving an indoubt transaction branch (holding locks in the Resource Manager) uncompleted forever (or at least until the RM administrator heuristically completes the tran branch - at which point they are taking a consistency risk with their data since they cannot be sure of the real outcome - though rollback is a fair bet). NOTE future recoveries of the TM don't typically recover these indoubt transaction branches since the UUID in the XID is associated with the logs and a new one is typically created when new logs are created after the existing ones are deleted.
ReplyDeleteLong story short - fix the permissions issue.
I found your blog while searching for the updates, I am happy to be here. Very useful content and also easily understandable providing.. Believe me I did wrote an post about tutorials for beginners with reference of your blog.
ReplyDeleterpa training in bangalore
best rpa training in bangalore
RPA training in bangalore
rpa course in bangalore
rpa training in chennai
rpa online training
I have visited this blog first time and i got a lot of informative data from here which is quiet helpful for me indeed.
ReplyDeletepython Online training in chennai
python Online training in bangalore
python interview question and answers
Nice post. By reading your blog, i get inspired and this provides some useful information. Thank you for posting this exclusive post for our vision.
ReplyDeleteAWS Training in pune
AWS Online Training
This blog is the general information for the feature. You got a good work for these blog.We have a developing our creative content of this mind.Thank you for this blog. This for very interesting and useful.
ReplyDeletedevops online training
aws online training
data science with python online training
data science online training
rpa online training
very nice information....!
ReplyDeleteinplant training in chennai
inplant training in chennai
inplant training in chennai for it
brunei darussalam web hosting
costa rica web hosting
costa rica web hosting
hong kong web hosting
jordan web hosting
turkey web hosting
gibraltar web hosting
The given information very impressed for me really so nice content.
ReplyDeleteAWS training in chennai | AWS training in annanagar | AWS training in omr | AWS training in porur | AWS training in tambaram | AWS training in velachery
Great article with creative blog.
ReplyDeleteJava training in Chennai
Java training in Bangalore
Java training in Hyderabad
Java Training in Coimbatore
Java Online Training
keep sharing your information regularly for my future reference. This content creates a new hope and inspiration with me.
ReplyDeletejava training in chennai
java training in tambaram
aws training in chennai
aws training in tambaram
python training in chennai
python training in tambaram
selenium training in chennai
selenium training in tambaram
Excellent information i really loved reading this article. Keep Sharing such wonderful information.
ReplyDeleteweb designing training in chennai
web designing training in annanagar
digital marketing training in chennai
digital marketing training in annanagar
rpa training in chennai
rpa training in annanagar
tally training in chennai
tally training in annanagar
I just loved your article on the beginners guide to starting a blog.If somebody take this blog article seriously in their life, he/she can earn his living by doing blogging.thank you for this article.
ReplyDeletedata science training in chennai
data science training in velachery
android training in chennai
android training in velachery
devops training in chennai
devops training in velachery
artificial intelligence training in chennai
artificial intelligence training in velachery
This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me..
ReplyDeletesap training in chennai
sap training in omr
azure training in chennai
azure training in omr
cyber security course in chennai
cyber security course in omr
ethical hacking course in chennai
ethical hacking course in omr
Are you looking for Oracle DBA training in Chennai with placement opportunities? Then we, Infycle Technologies are with you to make your dream into reality. Infycle Technologies is one of the best Oracle Training Institute in Chennai, which offers various programs along with Oracle such as Big Data, Python, Java, AWS, Hadoop, etc., in complete hands-on practical training with trainers, those are specialists in the field. Once after the training, the mock interviews will be arranged for the candidates for the upgradation of the best knowledge. Of all that, 100% placement assurance will be given here. To have the words above in the real world, call 7502633633 to Infycle Technologies and grab a free demo to know more.Best Oracle Training Institute in Chennai
ReplyDeleteLearn Big Data for excellent job opportunities from Infycle Technologies, the best Big Data training institute in Chennai. Infycle Technologies gives the most trustworthy Big Data Training in Chennai, with full hands-on practical training from expert trainers in the field. Along with that, the placement interviews will be arranged for the candidates, so that, they can meet the job interviews without missing them. Transform your career to the next level by dialing 7502633633 to Infycle Technologies and grab a free demo to know more
ReplyDeleteReach to the best Data Science Training institute in Chennai for skyrocketing your career, Infycle Technologies. It is the best Software Training & Placement institutes in and around Chennai. that also gives the best placement training for personality tests, interview preparation, and mock interviews for leveling up the candidate's grades to a professional level.
ReplyDeleteTitle:
ReplyDeleteBest Software Training Institute in Chennai | Infycle Technologies
Description:
Is a software job your dream? Then we, Infycle Technologies are with you to make your dream into existence. Infycle Technologies the best Software Training Institute in Chennai, which offers multiple courses such as Oracle, Python, Java, AWS, etc., with 100% practical training besides specialized trainers in the field. Furthermore, the mock interviews will be arranged for the students, so they can face the job interviews without any fear. Additionally, 100% placement assurance will be given here. Call 7502633633 to Infycle Technologies and grab a free demo to know more.
Best training in Chennai
Infycle Technologies, the best software training institute in Chennai offers the No.1 Data Science training in Chennai for Students, tech professionals, and freshers. In addition to the Data Science Training Course, Infycle also offers other professional courses such as Cyber Security, Python, Oracle, Java, Power BI, Digital Marketing, Big Data, etc., which will be trained with 100% practical classes. After the completion of training, the trainees will be sent for placement interviews in the top MNC's. Call 7502633633 to get more info and a free demo.
ReplyDeleteMiddleware And Security Technical Blog: Dsra0302E: Xaexception. Error Code: Xaer_Rmerr (-3). Exception: >>>>> Download Now
ReplyDelete>>>>> Download Full
Middleware And Security Technical Blog: Dsra0302E: Xaexception. Error Code: Xaer_Rmerr (-3). Exception: >>>>> Download LINK
>>>>> Download Now
Middleware And Security Technical Blog: Dsra0302E: Xaexception. Error Code: Xaer_Rmerr (-3). Exception: >>>>> Download Full
>>>>> Download LINK