Skip to main content
Planview Customer Success Center

Error message when filling in a configurable code field

Symptoms:


Not able to fill in a configurable code field. Error occurs when trying to filter the drop down list.

Error in UI:
An exception has occurred trying to perform your search...

Error in Changepoint event log:
Ambiguous column name 'ResourceId'...


Reason


The error is caused by not having the table name (i.e. Resources) in the filter formula of the configurable field at billing office level.

As of v2012 it is required to fully qualify all column name references by pre-pending the appropriate table name or alias (even if the column name reference is not ambiguous).



Resolution:


Modify the filter statement of this configurable field from:

WHERE ResourceId IN ...

to:

WHERE Resources.ResourceId IN ...

, by adding the table name (i.e. "Resources.") before the field name.