Skip to main content
ajayp702
New Participant
May 10, 2024 8:04 PM UTC
Solved

Execute Store Procedure Smart Service Error to recognize db sp

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 !

karumurua531442
Participating Frequently
May 11, 2024 4:32 AM UTC

hi,[mention:2f1cf256dafb4a48b240ede36271c712:e9ed411860ed4f2ba0265705b8793d05]  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?

6 replies

richardm900458
Inspiring
May 10, 2024 9:30 PM UTC

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." ?

ajayp702
ajayp702Author
New Participant
May 13, 2024 1:07 PM UTC

Yes, I did.

karthikk538
Inspiring
May 11, 2024 2:31 AM UTC

Hi Ajay,

can you help with sample code, looks like it might be pointed to wrong data source.

ajayp702
ajayp702Author
New Participant
May 13, 2024 1:10 PM UTC

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.

karumurua531442
Participating Frequently
May 11, 2024 4:32 AM UTC

hi,[mention:2f1cf256dafb4a48b240ede36271c712:e9ed411860ed4f2ba0265705b8793d05]  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?

ajayp702
ajayp702Author
New Participant
May 13, 2024 1:35 PM UTC

Thanks Abhishek, It was permission issue on the service account. Worked with DBA to get it fixed. working fine now. Thank you !