Caused by CLRT-78675
In the 'Example Use Case', the associated Dynamic Query Lookup 'Project Stakeholder' (Lookup ID = OBJ_PROJECT_STAKEHOLDER) is missing a requirement for including the attribute in the Data Warehouse. The Dynamic Query Lookup definition must have a select column defined for 'LAST_UPDATED_DATE'.
In general, the root cause for any attribute exhibiting these symptoms are:
Release: ESPCLA99000-14.3-Clarity-Extended Support Plus
This issue CLRT-78675, related to stock Dynamic Query Lookups, is fixed in Clarity PPM 14.4 and higher
If this occurs for a user-defined Dynamic Query Lookup, edit your query definition so that you add a date column with the alias 'LAST_UPDATED_DATE'.
For an example of a query that has this extra column LAST_UPDATED_DATE, refer to one of the stock Dynamic Lookups such as the Currencies Lookup (ID = LOOKUP_CURRENCIES).
If you are still seeing this issue in Clarity PPM 14.4 or higher for an out of the box lookup, check to ensure the out of the box lookups have been upgraded using the following steps:
Once this is done, the related lookup's query should get updated to include the following line item: