Skip to main content
Planview Customer Success Center

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.