search cancel

System Error: Unable to Rename Companies


Article ID: 239018


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


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( at org.postgresql.core.v3.QueryExecutorImpl.processResults( at org.postgresql.core.v3.QueryExecutorImpl.execute( at org.postgresql.jdbc.PgStatement.executeInternal( at org.postgresql.jdbc.PgStatement.execute( at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags( at org.postgresql.jdbc.PgPreparedStatement.execute( at jdk.internal.reflect.GeneratedMethodAccessor84.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke( at java.base/java.lang.reflect.Method.invoke( at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke( at com.sun.proxy.$Proxy37.execute(Unknown Source) at com.niku.union.persistence.jdbc.SQLTracePreparedStatement.execute( at com.niku.union.persistence.PersistenceController.processSql( ... 90 more 


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


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

On-Premise to SaaS Postgres Database Migration 


Targeted Fix in Release 16.0.3