Clarity

 View Only
  • 1.  [New UX] Tasks tab not loading in New UX

    Posted May 16, 2022 03:17 PM
    Edited by Thiago Pimenta May 16, 2022 04:35 PM
    Hello everybody!

    Has anyone had this problem or know how to fix it?

    Version 16.0.0.890

    When accessing the Tasks tab of a Project instance, Clarity 80% of the time (or more) does not load the screen completely, the tasks do not appear, not even the custom views, it is a problem that often occurs with all users and to be able to load the screen, it is necessary to refresh the page several times or keep clicking on another tab and returning to the blueprint tasks tab. This happens in any Project blueprint.

    Nothing appears, no matter how long I waited.


    Console errors

    After clicking several times on another tab and returning to the tasks tab the custom views are loaded:

    The console returns Error 500 for the following request:

    https://<client url>/ppm/rest/v1/describeAttributes?_cb=1652729417277&filter=(resourceName+%3D+%27tasks%27)+and+(honorFieldLevelSecurity+%3D+true)+and+(dataType+notIn+(%27clob%27,%27tsv%27,%27attachment%27))+and+(includeObjFilters+%3D+true)+and+(actionType+!%3D+%27dataOnly%27)&limit=500&offset=0

    App-ca.log error

    ERROR 2022-05-16 16:26:53,180 [http-nio-8080-exec-3120] ppm.rest (clarity:thiago.pimenta@agila.com.br:5973042__9059718B-4F36-4C18-8C49-609895479469:PPM_REST_API) Error while getting the attribute's custom label.
    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 custom_label
            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 = ?


    Derived from statement:
    <?xml version="1.0" encoding="UTF-8"?>
    <statement sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="map" xmlns="http://schemas.niku.com/2002/pmd">
      <sql dbVendor="all" tsvTemplateAttrCode="">
        <text>
              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 custom_label
            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 = ?
            </text>
        <param replace="language" direction="IN" expressionListDelimiter=","/>
        <param replace="language" direction="IN" expressionListDelimiter=","/>
        <param name="object_code" type="string" direction="IN" expressionListDelimiter=","/>
      </sql>
    </statement>
    
    Referenced by:
    <?xml version="1.0" encoding="UTF-8"?>
    <statementRef id="odf.getAttributeCustomLabels_nested_0" inputSource="map" inputMapIndex="0" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" defaultSliceSize="20" ignoreIfError="false" hideResultSets="false" xmlns="http://schemas.niku.com/2002/pmd"/>
    
    Using input: 
    {object_code=project}


    All objects in this environment were migrated via xog, only the structure, without the views of the classic version, in order not to overload the new server with views that will no longer be used, due to the migration of users to the new ux.

    I believe that the problems must not be related (screenshot and logs), because apparently the new ux does not use the views created in the classic interface.

    Thanks!


  • 2.  RE: [New UX] Tasks tab not loading in New UX

    Broadcom Employee
    Posted May 17, 2022 06:18 AM
    The console error doesn't give much information but as you said it load at times it could be performance issue,  do you know when it loads how long it takes and it would be worth performing a trace and run the query directly at database if you are on premise customer

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------



  • 3.  RE: [New UX] Tasks tab not loading in New UX

    Posted May 17, 2022 08:34 AM
    I'll do it. thanks