Error while saving project
Symptoms
After creation of a new calculated custom field (via stored CPCALC stored procedure): When saving a project (or request, task, resource, ...) there is an error message.
Error/warning messages
Server Error in '/' Application.
This step completed with error(s), please check the eventlog for more details.
SqlException (0x80131904): Changepoint.CommonServices.DataAccess.ExecuteNonQuery (...)
Changepoint.BusinessServices.ConfigurableFields.DataController.UDFDataAccess.UpdateCalculatedUDF (...)
Reason
The new stored procedure was not accessible by CPACCESS or it did not exist (e.g. it was applied on Test, but not in Prod).
Resolution
After the code that creates the new CPCALC_ stored procedure, please add a command to grant access to CPACCESS
go
GRANT Execute On CPCALC_.... To CPACCESS
go
Also make sure that the stored procedure exists on the corresponding environment.