BizTalk Error: Could not find stored procedure

  • Article

SYMPTOMS

The SQL Adapter may fail and you may receive an error message that is similar to the following:
-------------------
Error details: HRESULT='xxxxx' Description="Could not find stored procedure 'sp_xxxxx". as below:

image

This problem may occur when there is no SP in Database or you changed the name of store procedure.

RESOLUTION

Once changed the name of the store procedure, make sure you finish the one of below steps:

1. Re-generate all related schemas and other artifacts.

Or 2. If you choose to modify the schema manually, you must change annotation value & node name to tailor the new SP's name.

As Below:

image