Clarity PPM: Datamart Rollup (DMR) Job Fails With Error in NBI_EXTRACT_TF_TS_SP PostgresSQL Environment

Products

• Clarity PPM SaaS

Issue/Introduction

The BG logs show error:

ERROR 2020-09-13 17:32:04,617 [Dispatch Datamart Rollup - Time Facts and Time Summary : bg@server (tenant=clarity)] niku.njs (clarity:user:session:Datamart Rollup - Time Facts and Time Summary) Error executing job: 5014886
com.niku.union.persistence.PersistenceException: 
SQL error code: 0
Error message: ERROR: Error in CMN_JOB_DATAMART_ROLLUP_SP -  Error in NBI_EXTRACT_TF_TS_SP - :Rolling up NBI_RT_FACTS: Error in NBI_RTF - Building actual rollup SQL for weeks and months: maximum number of committed subtransactions (268435455) exceeded
Where: PL/pgSQL function cmn_job_datamart_rollup_sp(bigint,bigint) line 71 at RAISE
Executed: call CMN_JOB_DATAMART_ROLLUP_SP ( 14647276, 5030172)

Environment

Release : 15.8

Component : CA PPM SAAS APPLICATION

Resolution

Ensure the Datamart Extraction job runs successfully.

Run the Datamart Rollup job afterwards