cancel
Showing results for 
Search instead for 
Did you mean: 

XA_Transaction Rollback issue.

shailesh1
Explorer
0 Kudos

Hi All,

We have scheduled a job which should run at certain number of times in a year. The job should run and delete the CE table content (We are using Composite Application Framework (CAF), and Business Objects (BOs)).That is, here the data is deleted from CAF table.

Problem is, scheduled job will run at given time and it works fine as we could see it in logs it is deleting each line of the table, but when the job is completed, the transaction will rollback and result in no deleteion. when we check in logs, we are getting following error,

  • Cannot end XA transaction: XID:<XID> in state ROLLBACK_ONLY
  • XAException occured during <CLIENT SESSION>Returned status is XAER_PROTO

We are using JEE for coding. When we checked this with Basis team, it looks like a Time out problem. As job is taking nearly 3 and half to complete when actually it should comlete within 45min. So we have thought may be this is because of more data in the table.

can anybody give a solution for this? or can anybody tell if there is any way by which we can COMMIT in code after every line instead of waiting for all the lines to get delete and then COMMIT.

Thanks in Advance.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

This is beacuse the XAActive Timeout value is low and the batch job is processing large data. Hence, the batch job times out and doesn't update. You can increase the XAAActiveTimeout value as your batch job needs.

  • Login to NWA
  • Search ( Java System properties)
  • On Templates click advanced properties
  • On Details TAB put name as JMS provider and click filter
  • On Extended details click on XAActiveTimeout and update value
  • Save
Former Member
0 Kudos

Hi,

Did you manage to resolve this issue? We are encountering the same problem.

Tnx! Regards,

Christophe

shailesh1
Explorer
0 Kudos

Hi Christophe,

No. We are still facing this issue. Trying alternative methods but still no solution for this issue.

If you find the solution, please post here.

Thanks & Regards,

Shailesh

0 Kudos

Did you find a solution to this problem?

I'm encountering the same.

Thanks.

Chris