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

Parents

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

Reply

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

Children

No Data