Scheduled job failed. Job Datamart Rollup - Time Facts and Time Summary

Products

• Clarity PPM SaaS

Issue/Introduction

We have been receiving at least 6 of these messages since January 1st, 2021, and it looks like the scheduled jobs for "Job Datamart Roll - Time Facts and Time Summary" have failed to run in production. Please help us to fix the issue.

Cause

Error message: ERROR: Error in CMN_JOB_DATAMART_ROLLUP_SP -  Error in NBI_EXTRACT_TF_TS_SP - :Determine current fiscal period: query returned no rows

Environment

Release : 15.9

Component : CA PPM SAAS DATAMART

Resolution

1. Navigate to Administration -> Finance -> Setup -> entities -> Your Entity -> Fiscal Time Periods and set-up the time periods for 2021 and Active.

2. Run Datamart Extraction with no parameters checked.

3. Run Datamart Rollup - Time Facts and Time Summary