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

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 (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(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

Environment

Release : 16.0.1

 

Resolution

This is reported as DE64893 and is under Engineering review.

The attached functions is the proposed fix.