Hi,
Try through sql backdoor, if you can run the procedure by following command
exec <procedure name>
I think, you will get the same error as you are getting in the logs.
This will mean, you need to get the procedure corrected before triggering it through application [Automation agents]