How to capture the error details from JTA Command/Commit/Rollback/End

[former_member206397]

Hi All,

I have used JTA to insert data in multiple tables of a Data source. At the end of BLS I have used Commit, Rollback and End based on the condition. But I need to capture the error details of data insertion failure. The output of Command action block are JTATransactionStartSource

SQLCommand

CommandDatasource

RowsAffected

Success

InputLinksSuccess

OutputLinksSuccess

and Output of Commit, Rollback and End action block are

JTATransactionStartSource

Success

InputLinksSuccess

OutputLinksSuccess

Can anybody tell me how can I capture the error details.

Thanks in Advance

Chandan

[salvatore_castro · Accepted solution]

Chandan,

Thanks for pointing that out, I have since updated the custom JRA actions, back in February, to support "LastErrorMessage" as an Outgoing link from the JTACommand action block but must have forgotten to post the update to the SDN. The link on the Wiki will be updated shortly to reflect the updated content and in the mean time I will email you the updated action JAR.

Thanks again,

Sam

[former_member206397 · Accepted solution]

Hi Salvatore,

Thank you so much for quick help. In new JAR file I have got the "LastErrorMessage" property as an Outgoing link from the JTACommand action block.

Thanks & Kind Regards,

Chandan

[shaji_chandran · Accepted solution]

Thanks Sam,

When I can expect the email

Thanks & Regards

Shaji Chandran

[salvatore_castro · Accepted solution]

Shaji,

The actions are available on the MII Wiki ([https://wiki.sdn.sap.com/wiki/display/xMII|https://wiki.sdn.sap.com/wiki/display/xMII]) in the Customization section.

Sam

[Former Member]

Hi Chandan,

Not sure what you mean by JTA (Java Transaction API?). Do you mean JRA? I am not familiar with any JTA actions in the MII product, unless these were custom built actions. Can you give a bit more detail? Also, what version and SP of MII are you using?

Update: I see these are custom actions from the SDN. I see no "LastErrorMessage" property. You may want to contact the author of these actions for further information (perhaps he will see this post).

Kind Regards,

Diana Hoppe

Edited by: Diana Hoppe on May 11, 2011 3:50 PM

[shaji_chandran]

HI,

Yes you are right JTA is a custom action. I need to contact the author of MII.

I am using MII 12.1.6 version

Thanks again

Shaji Chandran