21 January 2014

DSRA0302E: XAException. Error code: XAER_RMERR (-3). Exception:

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.

25 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
    Replies
    1. Middleware And Security Technical Blog: Dsra0302E: Xaexception. Error Code: Xaer_Rmerr (-3). Exception: >>>>> Download Now

      >>>>> 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

      Delete
  2. Great article ...Thanks for your great information, the contents are quiet interesting. I will be waiting for your next post.
    Boligalarm uten binding

    ReplyDelete
  3. 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.. 
    python training in pune | python training institute in chennai | python training in Bangalore

    ReplyDelete
  4. 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.


    Data 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

    ReplyDelete
  5. 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.. 

    best 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

    ReplyDelete
  6. 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.
    Long story short - fix the permissions issue.

    ReplyDelete
  7. 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. 
    rpa training in bangalore
    best rpa training in bangalore
    RPA training in bangalore
    rpa course in bangalore
    rpa training in chennai
    rpa online training

    ReplyDelete
  8. I have visited this blog first time and i got a lot of informative data from here which is quiet helpful for me indeed. 
    python Online training in chennai
    python Online training in bangalore
    python interview question and answers

    ReplyDelete
  9. 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. 
    AWS Training in pune
    AWS Online Training

    ReplyDelete
  10. 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.

    devops online training

    aws online training

    data science with python online training

    data science online training

    rpa online training

    ReplyDelete
  11. 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.
    data 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

    ReplyDelete
  12. 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

    ReplyDelete
  13. Learn 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

    ReplyDelete
  14. Reach 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.

    ReplyDelete
  15. Title:
    Best 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

    ReplyDelete
  16. 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.

    ReplyDelete
  17. Middleware And Security Technical Blog: Dsra0302E: Xaexception. Error Code: Xaer_Rmerr (-3). Exception: >>>>> Download Now

    >>>>> 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

    ReplyDelete