Modern UX Attributes Page is not displaying any attribute records/data and errors seen in logs

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

New UX attributes Page is not displaying any Attribute Records and post upgrade to 16.0.2 below errors are see in app ca logs 

ERROR 2022-09-19 17:13:15,926 [http-nio-8080-exec-14] ppm.rest (none:none:none:none) Error while getting the attribute's caption
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

Executed:
 SELECT
          odf_attr_metadata.id AS odf_pk,
          odf_attr_metadata.attribute_code AS attribute_code,
          (CASE
          WHEN ODF_ATTR_METADATA.IS_CUSTOM = 1 THEN (
          SELECT
          caName.custom_label
          FROM
          CMN_CAPTIONS_NLS caName,
          ODF_CUSTOM_ATTRIBUTES oca
          WHERE
          caName.pk_id = oca.id
          AND caName.language_code = ?
          AND caName.table_name = 'ODF_CUSTOM_ATTRIBUTES'
          AND (oca.OBJECT_NAME = ODF_ATTR_METADATA.OBJECT_CODE
          OR oca.OBJECT_NAME = ODF_ATTR_METADATA.INHERITED_FROM)
          AND oca.INTERNAL_NAME = ODF_ATTR_METADATA.ATTRIBUTE_CODE)
          ELSE (
          SELECT
          caName.custom_label
          FROM
          CMN_CAPTIONS_NLS caName
          WHERE
          caName.pk_id = ODF_ATTR_METADATA.id
          AND caName.language_code = ?
          AND caName.table_name = 'ODF_ATTR_METADATA')
          END) AS caption
          FROM
          odf_attr_metadata odf_attr_metadata,
          odf_objects odf_objects,
          odf_ca_odf_attr_metadata odf_ca_odf_attr_metadata
          WHERE
          odf_attr_metadata.object_id = odf_objects.id
          AND odf_attr_metadata.id = odf_ca_odf_attr_metadata.id
          AND odf_attr_metadata.OBJECT_CODE = ? 

 

Environment

Release : 16.0.2

Component : Clarity MUX Blueprints and Administration

Cause

Steps to Reproduce :-

1. Take a Clarity System with 16.0.1 version.
2. Login in to clarity.
3. Navigate to Objects. Create a Sub Object of Investment Object and API Enable it.
4. On attributes tab. Click on "New Virtual".
5. Click on the Attribute named "Methodology" and click on Add.
6. In the Attribute Label Mention "Methodology test", and Mention Attribute ID as "methodology" which is same as the original Attribute.
7. edit the newly created attribute and add an API Alias.
8. navigate to New UX -> attributes. Search for the newly added attribute, it's not displayed since it's a virutal attribute.
9. Upgrade the environment to 16.0.2.
10. After upgrade Navigate to New UX -> Administration -> attributes.

Expected Results :- Attributes List is shown.
Actual Results :- Attributes list is empty.

Resolution

The DE65337 is fixed in 16.0.3 

Additional Information

Workaround :-

1. Use the Filter options to filter for the specific object to view the attributes list. However, the custom object which was created in the STR will still return blank data.
2. In order to overcome the error in app ca log, reach out to Broadcom Support for a fix