BizTalk Error: Could not find stored procedure
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:
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:
