none
834 to SQL stored procedure not found RRS feed

  • Question

  • I am mapping 834 to a SQL stored procedure Schema. I keep getting cannot find stored procedure 'ST'. I have recreated and mapped the destination schema a few times and keep getting this error. The SP name is 'usp_load_tblFileMessage' not sure where it is getting 'ST' from.

    Any help would be greatly appreciated!

    Error message below...

    The adapter failed to transmit message going to send port "Insert_Enrollment_Data_5010_SP" with URL "SQL://Enrollment/". It will be retransmitted after the retry interval specified for this Send Port. Details:"HRESULT="0x80040e14" Description="Could not find stored procedure 'ST'."

    Wednesday, February 20, 2013 2:39 PM

All replies

  • The Adapter assumes that the Stored Procedure name is identical to the name of the Root element of the XML sent to the Adapter.

    Could you post what your "Soap Action Header" is set to and also the exact XML you are sending to the Adapter (you can do this by chaning Adapter Type to File).

    Morten la Cour

    Wednesday, February 20, 2013 3:06 PM
  • I forgot to mention I am using an orchestration as well...

    Not sure how to do what you waid with orchestration?

    Wednesday, February 20, 2013 3:43 PM