Hello everybody!
Has anyone had this problem or know how to fix it?
Version
16.0.0.890When 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!