Skip to main content
Planview Customer Success Center

Error when saving an entity that contains calculated configurable fields v2017

Symptoms

When saving an entity, an error about configurable field calculation appears. 

In the Event viewer of the SQL server, an error while running ValidateUDF stored procedure occurs:

ValidateUDF: EXEC CHECKFORMULA 'ENGAGEMENT', 'EngagementText50', 'ENGAGEMENTCODES.ENGTEXT46-ENGAGEMENTCODES.ENGTEXT49-ENGAGEMENTCODES.ENGTEXT160
  ', '20729E38-42ED-47B5-B848-4B3B56FADD70'
The multi-part identifier "ENGAGEMENTCODES.ENGTEXT46" could not be bound.

However the formula seems valid and other billing offices with same formula return no error.

Reason

A carriage return in the formula of the calculated configurable field makes the ValidateUDF job fail.

This has been logged as a defect in version Changepoint 2017 and is planned to be fixed in a future release. 

Workaround

Edit the configurable field, remove the carriage return in the formula and then save.