Eduardo, I am unable to call a procedure from Process Model . The ABC User has a

surendrab over 9 years ago

Eduardo, I am unable to call a procedure from Process Model . The ABC User has all the permissions for this schema . I keep on getting below error:
There is a problem with task “Execute Stored Procedure” in the process “Ececute DB Stored Proc”. [The stored procedure "ABC.MCP_SPA_CLCK.tick" was not found. Check the name is valid, or try using UPPERCASE.]
Problem: An error occurred in executing an Activity Class.
Recommended Action: Examine the activity class to correct the error and then resume.
Priority of this problem: High Priority

Discussion posts and replies are publicly visible

0 gpolk over 9 years ago

I'm going to state the obvious, are you sure that the procedure is configured with the correct stored procedure name and that there is not a misspelled word someplace.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Christine Shen
A Score Level 1
over 9 years ago

Try removing the ABC prefix. Typically the text preceding the stored procedure name with dot notation should be the database schema name. Instead you could grant execute permissions to the user in the Appian database configuration.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 surendrab over 9 years ago

Thank you both. I verified the name and store procedure. The name is correct. It also has the correction permissions. I already tried removing the ABC prefix. It does not work. The same process model is working in another environment. ABC is the schema name for this database.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel