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 (DMR) Job Fails With Error in NBI_EXTRACT_TF_TS_SP PostgresSQL Environment

book

Article ID: 199483

calendar_today

Updated On:

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 : [email protected] (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