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.

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


Article ID: 196619


Updated On:


Clarity PPM SaaS


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)] (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( at com.niku.union.persistence.PersistenceController.processSql( at com.niku.union.persistence.PersistenceController.processStatement( at com.niku.union.persistence.PersistenceController.processStatements( at com.niku.union.persistence.PersistenceController.doProcessRequest(

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( at jdk.internal.reflect.GeneratedMethodAccessor39.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.ProxyConnection.invoke(


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.