Skip to main content
ajayp702
ajayp702
May 10, 2024
Solved

Execute Store Procedure Smart Service Error to recognize db sp

  • May 10, 2024
  • 6 replies
  • 0 views

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 !

Best answer by karumurua531442

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
richardm900458
May 10, 2024

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
May 13, 2024

Yes, I did.

karthikk538
karthikk538
May 11, 2024

Hi Ajay,

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

ajayp702
ajayp702Author
May 13, 2024

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
karumurua531442Answer
May 11, 2024

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
    May 13, 2024

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

      Terms & ConditionsAccessibility statement