Projects Do Not Load After Lookup Attribute Deleted

Products

• Clarity PPM On Premise

Issue/Introduction

A lookup was created and then deleted.

The project attribute was tied to the lookup.

Afterwards, we cannot load the project page

APP log shows:

ERROR 2026-06-01 10:47:35,857 [http-nio-80-exec-638] ppm.rest (clarity:user:session:PPM_REST_API) (21613fcf-42c6-418e-bf52-9552195c6a54) RestAPILookupServiceImpl :: Problem occurred while reading lookup filter attributes for lookupType: IC_TEST_LOOKUP

com.niku.union.persistence.nsql.NSQLSyntaxException: NSQL Syntax exception: NSQL_SYNTAX_ERROR_DB_ERROR, Info: ORA-00904: "P"."A_CUSTOMIDENTIFIER": invalid identifier

 

SQL Text:

 SELECT

    inv.id AS id,

    inv.code AS code,

 

    CASE

        WHEN (

            NVL(p.A_CUSTOMIDENTIFIER,0) +

            NVL(p.ic_investmentmemocab,0) +

            NVL(p.ic_investmentconcept,0) +

            NVL(p.ic_investmentai,0)

        ) > 1

        THEN 'true'

        ELSE 'false'

    END AS name

 

FROM odf_ca_project p

INNER JOIN inv_investments inv

    ON p.id = inv.id 

at com.niku.union.persistence.nsql.NSQLQuery.retrieveMetaData(NSQLQuery.java:1020)

at com.niku.union.persistence.nsql.NSQLQuery.initialize(NSQLQuery.java:288)

at com.niku.union.persistence.nsql.NSQLQuery.setNSQL(NSQLQuery.java:804)

at com.niku.union.persistence.nsql.NSQLQuery.<init>(NSQLQuery.java:328)

at com.niku.union.persistence.nsql.NSQLQuery.<init>(NSQLQuery.java:348)

at com.niku.union.persistence.nsql.NSQLController.getQuery(NSQLController.java:105)

at com.niku.union.persistence.nsql.NSQLController.getQuery(NSQLController.java:85)

at com.ca.platform.osf.object.rest.lookup.RestAPILookupServiceImpl.getFilterAttributes(RestAPILookupServiceImpl.java:214)

at com.ca.ppm.rest.resource.ResourceMetaDataAggregator.getResourceAttributes(ResourceMetaDataAggregator.java:1017)

at com.ca.ppm.rest.resource.DescribeAttributeResource.getResources(DescribeAttributeResource.java:276)

at com.ca.ppm.rest.provider.FunctionResourceProvider.getResources(FunctionResourceProvider.java:126)

at com.ca.ppm.rest.provider.FunctionResourceProvider.getEntities(FunctionResourceProvider.java:98)

at com.ca.ppm.rest.resource.BaseResourceHandler.retrieveResources(BaseResourceHandler.java:278)

at com.ca.ppm.rest.resource.BaseResourceHandler.retrieveResources(BaseResourceHandler.java:238)

at com.ca.ppm.rest.resource.ResourceHandler.getResources(ResourceHandler.java:120)

... [truncated application framework tracing] ...

at java.base/java.lang.Thread.run(Thread.java:840)

Caused by: com.niku.union.persistence.PersistenceException: 

SQL error code: 904

Error message: ORA-00904: "P"."A_CUSTOMIDENTIFIER": invalid identifier

...

Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "P"."A_CUSTOMIDENTIFIER": invalid identifier

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)

... 111 more

Caused by: Error : 904, Position : 94, Sql = SELECT ... Error Msg = ORA-00904: "P"."A_CUSTOMIDENTIFIER": invalid identifier

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)

... 132 more

Resolution

Delete the object attribute tied to the attribute.