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

[asangidevaraj]

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

[AlexGourdet]

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

[ErvinSzolke]

Hello Devraja,

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

Regards,
Ervin (moderator)

[JamesZ]

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.