Timesheet Review Portlet Not Filtering on Resources / Error 500

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Classic UX. When attempting to filter on the resource field, the following error appears.  This happens on Oracle, SQL Server, and PostgreSQL.

Error 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator. 

 

Steps to Reproduce:  

1. Configure portlet(TImesheet Overview) on the Classic General Overview tab 
2. Click lookup icon on Resource field or attempt to search 
3. OR go to Administration > Lookups
4. Search for lookup id=LOOKUP_RES_AND_TEAMS (Resources and Teams Browse)
5. Click Browse Window > Preview

Expected Results: Filtering should work. 

Actual Results: Pop Error appears: Error 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator.

APP log errors:

Oracle Environments

ERROR 2022-06-28 20:59:57,879 [http-nio-80-exec-573] lookup.BaseLookupService (clarity:user:session:odf.browsePage)

Unable to get lookup values for lookup LOOKUP_RES_AND_TEAMS for browse page support com.niku.union.odf.lookup.LookupException:

Could not fetch values for the NSQL
.....
ERROR 2022-06-28 20:59:57,893 [http-nio-80-exec-573] union.persistence (clarity:user:session:odf.browsePage) Exception on nsql_internal statement null:5057001
java.sql.SQLSyntaxErrorException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "RESOURCES"."IS_HIDDEN": invalid identifier

PostgreSQL Environments 

ERROR 2022-06-27 15:21:20,300 [http-nio-8080-exec-11] lookup.BaseLookupService (clarity:user:session:odf.browsePage)

Unable to get lookup values for lookup LOOKUP_RES_AND_TEAMS for browse page support com.niku.union.odf.lookup.LookupException:

Could not fetch values for the NSQL  at com.niku.odf.service.lookup.DynamicBrowseLookupService.getLookupValues(DynamicBrowseLookupService.java:577)

Error message: ERROR: column resources.is_hidden does not exist Position: 1379   

SQL Server Environments 

 

ERROR 2022-06-29 15:35:41,679 [http-nio-80-exec-4] union.persistence (clarity:user:session:odf.browsePage) Exception on nsql_internal statement null:5056002
java.sql.SQLSyntaxErrorException: [CA Clarity][SQLServer JDBC Driver][SQLServer]Invalid column name 'IS_HIDDEN'.

Environment

Release 16.0.2 

Cause

DE65645 - This is caused by a change in Resource-related lookups in 16.0.2.  This specific lookup was coded incorrectly. 

Workaround: Contact Support for information on how to fix the lookup. 

Resolution

DE65645 in Engineering review.