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

book

Article ID: 193484

calendar_today

Updated On:

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:
 

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.

Environment

Release : 15.8.0 and 15.7.1

Component : CLARITY SAAS APPLICATION

Resolution

Run the following steps against the Clarity DB:

  1. Take backup for PPM table odf_custom_attributes
  2. Run 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 update

commit;

   4. Restart Clarity services

Department OBS lookup should start to work on the new UX:

Additional Information

See also: API errors - known causes for Clarity

Attachments