Modern UX Administration Module Attributes Not Showing

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

When viewing the Adminstration > Attributes in the Modern UX, the only object able to be shown is the Idea object.

When using the filter for anything else or clearing the filter, no other object attributes such as projects appear.

 

Environment

Release : 15.9

Component : CA PPM SAAS USERS, GROUPS, OBS ADMINISTRATION

Cause

Review the APP logs:

ERROR 2021-06-16 17:40:29,257 [http-nio-8082-exec-833] odata.EntitiesResponseImpl (clarity:[email protected]:12345__xxxxxx:PPM_REST_API) Exception reading objects: odf_attr_metadata
com.niku.union.persistence.PersistenceException: 
SQL error code: 1427
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01427: single-row subquery returns more than one row

Resolution

1. Request results of:

select *  from ODF_ATTR_METADATA
where object_code in ('project','inv')
--and attribute_code in ('obj_align_factor4')
and database_table = 'odf_ca_inv'
order by object_code, attribute_code

2. Review results.

Review the results against a working system, which should have the following example results:


In a reported case, there was an issue with same attribute IDs but all are on the 'project' object only, which indicates a duplication.