ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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 (STR): 

1. Create Company.

2. Financially-enable the company.

3. Try modifying the company name.

Actual: Company Name does not change. Error appears: System error. Contact System administrator.
Expected: Company Name should change/update.

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


Release : 16.0.1



This is reported as DE64893 and is under Engineering review.

The attached functions is the proposed fix.