Task Updates and Deletes Do Not Work on GCP Environment

Products

• Clarity PPM SaaS

Issue/Introduction

Even as an admin, when trying to update any field on a task in the Modern UX or Classic UI, the following error is received:

One or more of the following errors appear in the APP logs, depending on the function/action:

Where: PL/pgSQL function schema.prj_effort_fct(numeric,text,text) line 36 at EXECUTE

ERROR 2021-07-26 05:33:31,327 [http-nio-8080-exec-7] rest.validation (clarity:admin:xxxx:PPM_REST_API) ExceptionInfo ::  Could not update resource. Resource name: tasks. Error code: null Error message: An exception occurred while trying to update an object instance task

ERROR 2021-07-27 11:51:35,926 [http-nio-8080-exec-51] rest.validation (clarity:admin:xxxx:PPM_REST_API) ExceptionInfo ::  Could not update resource. Resource name: tasks. Error code: null Error message: An exception occurred while trying to update an object instance task
ERROR 2021-07-27 11:51:57,258 [http-nio-8080-exec-47] niku.xql2 (clarity:admin:xxxx:PPM_REST_API) Internal Processing exception
java.lang.Exception: Invalid expression qobj: com.niku.union.persistence.PersistenceException: 
SQL error code: 0
Error message: ERROR: relation "prtask" does not exist
  Where: PL/pgSQL function schema.prj_effort_fct(numeric,text,text) line 36 at EXECUTE

Cause

This is due to a database configuration issue.

Resolution

Please open a case to have the DBA team perform and check if the schema qualification is configured correctly.

Additional Information

The following error occurs when attempting to adding team staff member:

ERROR: Sorting by the column specified is not allowed.

In the APP log:

ERROR 2021-07-27 12:11:19,575 [http-nio-8080-exec-51] union.persistence (clarity:admin:xxxx::projmgr.teamList) Exception on odf-pmd.team.select-no-security-list-conditional.map statement null
org.postgresql.util.PSQLException: ERROR: relation "prassignment" does not exist
  Where: PL/pgSQL function schema.prj_sum_assignment_fct(bigint,numeric) line 13 at EXECUTE