Skip to main content
Language Selector

  1. Other Languages

    (machine translation)

Planview Customer Success Center

The ValidateUDF job is failing with the following messages:

  1. Last updated
  2. Save as PDF

Symptoms

The ValidateUDF job is failing with the following messages:

Error/warning messages

Job ValidateUDF: EXEC CHECKFORMULA 'PROJECT', 'ProjectText483', '(EXEC CPCALC_ProjectCriticalPath @projectid, @PARA_VAR OUTPUT)', NULL
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.CPCALC_F_GetWorkingDays", or the name is
Log SQL Server (Current - 12/1/2016 6:13:00 AM)

Message
Job ValidateUDF: EXEC CHECKFORMULA 'RESOURCE', 'ResourceText1', 'SURVEY("Resource Satisfaction Survey")', NULL
'SURVEY' is not a recognized built-in function name

 

Reason

The job is failing because of ProjectText483 and ResourceText1.

Resolution

Marked the UDFs as 'Not used' in system manager.

Steps:

  1. Login to System Manager
  2. Go to User Interface - Configurable Field Settings
  3. Select entity (Project/Resource) category, and scroll to the ProjectText483/ ResourceText1 field.
  4. Under the Modify Configurable Field section, check the "Not Used" field, and save