Configure node as mentioned in HERE for Execute Stored Procedure Smart Service but getting following error. I have created SP in SQL server and tested successfuly but couldn't call from processmodel.
Error:
No procedure found with name procUpdateDWAZipCodeParameter.
TIA !
Discussion posts and replies are publicly visible
naivly asked: did you maintain it like this as well?"A data source connected system constant. Or for Admin console data sources, the name of the data source." ?
Hi Ajay,
can you help with sample code, looks like it might be pointed to wrong data source.
hi,Ajay Pandey could you check if your SP is mapped to the right data source? could share the node configuration of the node, please? Also just a thought Do you have the right grants for executing the SP?
Yes, I did.
I did verify again and its correct datasource. To just double check i have incorrectly spell the database name and it throws a different error related to incorrect data source which make more sense that the datasource is correct but it’s not recognizing the stored procedure.
Thanks Abhishek, It was permission issue on the service account. Worked with DBA to get it fixed. working fine now. Thank you !