Skip to main content
Planview Customer Success Center

CPCALC stored procedure fails when called within Changepoint but not when called from the command line

Check the name of the CPCALC stored procedure. It cannot exceed 50 characters. Otherwise the CPCALC stored procedure will run fine when called from SQL Management Studio but fails when called from Changepoint to calculate the value of a configurable field.

Also check the body of the stored procedure and make sure the GRANT to CPACCESS is not part of the code.