Clarity PPM: Datamart Rollup Job Fails after Slow Performance in PostgreSQL Environment

book

Article ID: 196619

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction


In the SaaS/GCP/PG environment, the Datamart Rolllup (DMR) runs for 300+ minutes then fails.

The error in the BG log:

ERROR 2020-08-04 10:59:43,529 [Dispatch bcDatamart Rollup - Time Facts and Time Summary : [email protected] (tenant=clarity)] persistence.PersistenceController (clarity:user:xxxxx__xxxxxxxxxxxxx:bcDatamart Rollup - Time Facts and Time Summary) Exception due to DB Connection failureERROR 2020-08-04 10:59:43,530 [Dispatch bcDatamart Rollup - Time Facts and Time Summary : [email protected] (tenant=clarity)] niku.security (clarity:user:xxxx0:bcDatamart Rollup - Time Facts and Time Summary) UserSessionCache.removeFromPersistence:PMD errorcom.niku.union.persistence.DBConnectionException: org.postgresql.util.PSQLException: This connection has been closed. at com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:2230) at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:3063) at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:888) at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:786) at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:588)

FATAL 2020-08-04 10:59:43,533 [Dispatch bcDatamart Rollup - Time Facts and Time Summary : [email protected] (tenant=clarity)] union.persistence (clarity:user:xxxxx__xxxxxxxxxxxxx:bcDatamart Rollup - Time Facts and Time Summary) java.sql.SQLClientInfoException: One or more ClientInfo failed. at org.postgresql.jdbc.PgConnection.setClientInfo(PgConnection.java:1455) at jdk.internal.reflect.GeneratedMethodAccessor39.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.ProxyConnection.invoke(ProxyConnection.java:126)

Resolution

Run the Datamart Extraction job to completion.
Run the Datamart Rolloup job to completion.

If it continues to error out, please open a case with Support.


Additional Information

Ahead of any service restart or maintenance/upgrade, pause all jobs that are in the 'Waiting' or 'Scheduled' state.
If a job is 'Processing', allow it to finish or cancel and delete it.