Error ODF-0921 - attribute lookup query does not have LAST_UPDATED_DATE. So corresponding records will not be updated as expected in DWH.

Products

• Clarity PPM SaaS

Issue/Introduction

In Studio, the PMO dynamic query lookup called 'Rally Investment Categories' (Lookup ID = RALLY_INVESTMENT_CATEGORIES) is missing select column defined for 'LAST_UPDATED_DATE' for including in the attribute in the Data Warehouse. As a result, on the Custom Investment Object when trying to update and save the associated attribute called Rally Investment Categories, a yellow Alert message will display: ODF-0921: For 'rally_inv_category' attribute lookup query does not have LAST_UPDATED_DATE. So corresponding records will not be updated as expected in DWH.

Steps to Reproduce:
1. Login as an administrator
2. Navigate to Administration, Studio: Objects, CIO
3. Go to Attributes page, create new attribute and associated with the OOB dynamic lookup called 'Rally Investment Categories' (Lookup ID = RALLY_INVESTMENT_CATEGORIES)
4. Check 'Include in the Data Warehouse' option
5. Click 'Save' or 'Save and Return' button (no changes needed to generate message)

Expected Result: Save is successful
Actual Result: ODF-0921 error message appears
Workaround: Developer needs to identity in the table which last_updated_date column you'll need to add to prevent the warning, and then once you have this info you can clone the Rally Investment Categories lookup and add the necessary columns in the cloned dynamic query if you want to use them with custom attributes in the DWH.

Resolution

Regarding DE155665 - Error ODF-0921 - z_xyz attribute lookup query does not have LAST_UPDATED_DATE, Engineering is not planning to do any action to the Rally Investment Categories lookup since the warning is by design to alert for dynamic lookups do not include the last_updated_date. Clarity has many lookups like this - all of the Rally* dynamic lookups we ship don't include the last_updated_date. Since the out of box lookups are system restricted customers can't change them.

Potential workaround requires some development work, developer needs to identity in the table which last_updated_date column you'll need to add to prevent the warning, and then once you have this info you can clone the Rally Investment Categories lookup and add the necessary columns in the cloned dynamic query if you want to use them with custom attributes in the DWH.