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:
- Configure portlet(TImesheet Overview) on the Classic General Overview tab
- Click lookup icon on Resource field or attempt to search
- OR go to Administration > Lookups
- Search for lookup id=LOOKUP_RES_AND_TEAMS (Resources and Teams Browse)
- 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