search cancel

System Error: Unable to Rename Companies

book

Article ID: 239018

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

For Clarity on PostgreSQL, when attempting to update the Company Name field on the Home > Financial Management > Companies page, the following error appears:

Steps to Reproduce:  

  1. Create a Company 
  2. Financially-enable the Company 
  3. Try modifying the company name 

Expected Results: To be able to rename a Company without any errors. 

Actual Results: Error appears: System error. Contact System administrator. The Company name is not updated. 

The APP logs show:

Caused by: org.postgresql.util.PSQLException: ERROR: column "armaster" of relation "armaster" does not exist Where: PL/pgSQL function trigger_fct_srm_companies_t1() line 20 at SQL statement at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2674) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2364) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:354) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:484) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:404) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:162) at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:151) at jdk.internal.reflect.GeneratedMethodAccessor84.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:118) at com.sun.proxy.$Proxy37.execute(Unknown Source) at com.niku.union.persistence.jdbc.SQLTracePreparedStatement.execute(SQLTracePreparedStatement.java:112) at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:3227) ... 90 more 

Cause

DE64893 - This database function was not properly converted for the Postgres Database. 

Environment

Release : 15.8.x, 15.9.x, 16.0.0, 16.0.1, 16.0.2 

On-Premise to SaaS Postgres Database Migration 

Resolution

Targeted Fix in Release 16.0.3