Skip to main content
Language Selector

  1. Other Languages

    (machine translation)

Planview Customer Success Center

Error message when saving calculated custom field definition

  1. Last updated
  2. Save as PDF

Symptoms

When defining a custom number field with a calculation formula, an error message pops up when the field definition is saved. The syntax of the formula has been verified and it is correct.

Error/warning messages

The formula contained illegal characters or syntax is not correct

Resolution

  • The stored procedure must be already in the database. It’s not possible to prepare the field definition when the stored proc is not yet there.
  • The stored procedure must be accessible (grant to CPACCESS)
  • The stored procedure must be able to cope with '{00000000-0000-0000-0000-000000000000}' or NULL as @entityID parameter That is how it is called to check if it’s there an accessible and working.