Question Re: MP: exception caught with cause com.sap.engine.interfaces.messaging.api.exception.MessagingException in Technology Q&A

MP: exception caught with cause com.sap.engine.interfaces.messaging.api.exception.MessagingException

asangidevaraj — Wed, 25 May 2022 14:26:35 GMT

Am Getting the following error..

MP: exception caught with cause com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. SAP_HANDLING_UNITS_PKG.POPULATE_HU_TABLES (structure Stored_Procedure): java.sql.SQLException: ORA-06519: active autonomous transaction detected and rolled back

ORA-06512: at "LINCAPP.SAP_HANDLING_UNITS_PKG", line 964
ORA-06512: at line 1

Transmitting the message to endpoint <local> using connection SOAP_http://sap.com/xi/XI/System failed, due to: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. SAP_HANDLING_UNITS_PKG.POPULATE_HU_TABLES (structure Stored_Procedure): java.sql.SQLException: ORA-06519: active autonomous transaction detected and rolled back
ORA-06512: at "LINCAPP.SAP_HANDLING_UNITS_PKG", line 964
ORA-06512: at line 1

Exception caught by adapter framework: Error processing request in sax parser: Error when executing statement for table/stored proc. SAP_HANDLING_UNITS_PKG.POPULATE_HU_TABLES (structure Stored_Procedure): java.sql.SQLException: ORA-06519: active autonomous transaction detected and rolled back
ORA-06512: at "LINCAPP.SAP_HANDLING_UNITS_PKG", line 964
ORA-06512: at line 1

Unable to execute statement for table or stored procedure. SAP_HANDLING_UNITS_PKG.POPULATE_HU_TABLES (Structure Stored_Procedure) due to java.sql.SQLException: ORA-06519: active autonomous transaction detected and rolled back
ORA-06512: at "LINCAPP.SAP_HANDLING_UNITS_PKG", line 964
ORA-06512: at line 1

Re: MP: exception caught with cause com.sap.engine.interfaces.messaging.api.exception.MessagingException

AlexGourdet — Wed, 25 May 2022 14:26:52 GMT

Thank you for visiting SAP Community to get answers to your questions.

Since you're asking a question here for the first time, I'd like to recommend you with the following steps so you can get the most out of your community membership:

Please see: https://community.sap.com/resources/questions-and-answers as this resource page provides tips for preparing questions that draw responses from our members
Consider to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html. as that will help you when submitting questions to the community.

I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,
-Alex

Re: MP: exception caught with cause com.sap.engine.interfaces.messaging.api.exception.MessagingException

ErvinSzolke — Thu, 26 May 2022 08:57:42 GMT

Hello Devraja,

please note that I have added further tags to reach proper subject matter experts.

Regards,
Ervin (moderator)

Re: MP: exception caught with cause com.sap.engine.interfaces.messaging.api.exception.MessagingException

JamesZ — Fri, 27 May 2022 02:36:48 GMT

Here is the oracle meaning:
<
06519, 00000, "active autonomous transaction detected and rolled back"

// *Cause: Before returning from an autonomous PL/SQL block, all autonomous

// transactions started within the block must be completed (either

// committed or rolled back). If not, the active autonomous

// transaction is implicitly rolled back and this error is raised.

// *Action: Ensure that before returning from an autonomous PL/SQL block,

// any active autonomous transactions are explicitly committed

// or rolled back.

>

So needs to engage application, how developed SAP_HANDLING_UNITS_PKG? Need to tag them if it is SAP's program.