Error: "API-1003 : Could not find resource OBS_BROWSE_FLT_IDEA" in New UX

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

While opening the OBS Department field from the New User Experience (UX) Idea Details page, the following error appears:

API-1003 : Could not find resource OBS_BROWSE_FLT_IDEA.

Application logs (app-ca.logs) indications:

App-ca.log:
---------------------
ERROR ... Could not retrieve lookup data for lookup type: 
http://ppm_url/ppm/rest/v1/lookups/OBS_BROWSE_FLT_IDEA/lookupValues?....

The OBS Department field is confirmed to be API enabled from studio configuration:

The same Department OBS attribute is looking good on the classic PPM Ideas detail page:

 

Environment

Release : 15.7.1 and 15.8

Cause

OBS_BROWSE_FLT_IDEA is a deprecated view and should have been ideally upgraded to OBS_BROWSE_FLT_ALL.  The upgrade path found for an affected Clarity SAAS environment was a direct upgrade from release 13.2.0.3 to 15.5.0.19.

Resolution

Run the following steps against the Clarity DB:

1. Take a backup of the Clarity table odf_custom_attributes
2. Run the below update query:
   
   UPDATE odf_custom_attributes SET LOOKUP_TYPE ='OBS_BROWSE_FLT_ALL' 
where LOOKUP_TYPE='OBS_BROWSE_FLT_IDEA';


3. Commit the changes after the update
   
   commit;
   
   
4. Restart Clarity services

Department OBS lookup should start to work in the new UX

Additional Information

See also: API errors - known causes for Clarity