Datamart Rollup Job Failed - Cannot insert the value NULL into column 'FISCAL_TIME_KEY' table

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

We received the following error:

This scheduled job failed. Datamart Rollup - Time Facts and Time Summary

Job: Datamart Rollup - Time Facts and Time Summary
Failed - Message:
com.niku.union.persistence.PersistenceException:
SQL error code: 515
Error message: [CA PPM][SQLServer JDBC Driver][SQLServer]Cannot insert the value NULL into column 'FISCAL_TIME_KEY', table 'NBI_FM_PT_FACTS'; column does not allow nulls. INSERT fails.
SQL error code: 3621
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]The statement has been terminated.
SQL error code: 50000
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]-20000_Error in NBI_FM_PT

Cause

This error message indicates that there is no active, monthly fiscal time period defined for the current month.

Resolution

The Datamart jobs require active, monthly Fiscal Time Periods defined for the Entity that is configured on the Datamart Settings page. The configuration of Fiscal Time Periods must include the current month. It is a 'best practices' recommendation to define active, monthly periods up to 6 months into the future so that the Clarity Administrator does not have to remember to create these periods each month.