Datamart Rollup Error - upper bound of FOR loop cannot be null

Products

• Clarity PPM SaaS

Issue/Introduction

Datamart Rollup job is failing with the following error:

ERROR 2023-04-08 15:30:23,916 [Dispatch ABC- SEQ002-2 Datamart Rollup - Time Facts and Time Summary : bg@<host>(tenant=clarity)] niku.njs (clarity:42128:155125016__6A2B36A9-CC06-4393-9738-97BCBBE20AE4:HONDA - SEQ002-2 Datamart Rollup - Time Facts and Time Summary) Error executing job: 58875231com.niku.union.persistence.PersistenceException: SQL error code: 0Error message: ERROR: Error in CMN_JOB_DATAMART_ROLLUP_SP -  Error in NBI_EXTRACT_TF_TS_SP - :Rolling up NBI_RT_FACTS: upper bound of FOR loop cannot be null

Cause

The job is looking for the calendar weeks for at least 3 years out. 

 

Resolution

Run the following query:

  select max(time_key) from nbi_dim_calendar_time 

    -- the results should go out for 3 years 

If not, run the Datamart Extraction Job

Then run the Datamart Rollup Job

 

**Note that you may also see an error 

 NBI_PM_PROJECT_TIME_SUMMARY - Building string of weeks that need to be rolled up again:

 

Additional Information

The datamart extraction job should be scheduled to run nightly.

Additional Articles:

Datamart Extraction and Datamart Rollup jobs and when they need to run

What files does Datamart Extraction job use during execution?

Datamart Rollup job is fails with error - Building string of weeks that need to be rolled up again'