search cancel

Unable To Access Custom Object API-1019 Error

book

Article ID: 254745

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

When accessing a Custom Object, the following generic error is given:
API-1019: Could not process the request due to internal error.

ERROR 2022-11-21 08:37:54,380 [http-nio-8080-exec-712] ppm.rest (clarity:user:session:PPM_REST_API) RestAPILookupServiceImpl :: Problem occurred while reading lookup filter attributes for lookupType: Z_example

When trying to access the custom object attribute, the attribute was missing and corresponding error came:

ERROR 2022-11-21 13:40:31,108 [http-nio-8080-exec-758] ppm.rest (clarity:user:session:PPM_REST_API) Error while getting the attribute's caption
com.niku.union.persistence.PersistenceException: 
SQL error code: 0
Error message: ERROR: more than one row returned by a subquery used as an expression
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.attribute5
          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.attribute5
          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.3

Resolution

Proceed to delete the object attribute causing the problem.
Recreate the attribute. 

 

Attachments