I have two orchestartions
Orchestration 1: 1. I receive a message on the incomming port , I call a send-receive SQL Adapter, If the SQL server is not available or the stored procedure does not exist the SQL XML message is routed to my second orchestration. I have failed message routing enabled on my SQL Adapter pot
Orchestration 2: I Subscibe directly to all error messages and I send an email out with error details.
My question now is I would like to include the original message which I have received in Orchestration 1 andinclude this message as an email attachment. Currently I can only access the SQL Xml message and its error properties.
If anyone can help me on how to retrieve the original message which was submitted in orchestration 1 in orchestration 2 based on the SQL Xml error message.