PPM NEW UX API-1003 : Could not find resource OBS_BROWSE_FLT_IDEA

Article Id: 193484
Status: Published
Updated On: 25-06-2020 14:03
Products:
Issue/Introduction:

While opening the OBS Department field from the New 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 PPM 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 PPM SAAS APPLICATION

Resolution:

Run the following steps against the PPM 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 PPM services

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