Commit failed, Rollback executed

[Former Member]

Hi.

I have triggered two IPs (X and Y) in parallel frm the receiver determination of another IP (say Z)

The last step of both these IPs update the database with status 'X process is closed' and 'Y process is closed' respectively.

One IP is successfully updating the database but for the other the error in BPM graphical flow is "Commit failed, Rollback executed". I have used same syn-interfaces in the last step of both the IPs.

Besides, I've tested by incorporating the "wait" step in one IP so that it'll update the database after sometime. But stilll the error is same.

Any ideas/inputs to resolve are highly appreciable. Kindly respond at the earliest.

Thanks for the co-operation,.

-Praveen.

[prateek]

Are both the send step acting on the same table? If yes, then in my opinion it would be better if you could merge the two BPM calls into one (multiple access tags) or use stored procedure in this case. Otherwise u may also use multiple Statement tags.

Regards,

Prateek