We have been receiving at least 6 of these job messages since January 1st, 2023, and it looks like the scheduled jobs for "Job Datamart Rollup - Time Facts and Time Summary" have failed to run in production.
App logs:
ERROR 2023-01-23 00:10:00,937 [Dispatch Datamart Rollup - Time Facts and Time Summary : bg@cppm9012 (tenant=clarity)] niku.njs (clarity:clarity user:clarity session:Datamart Rollup - Time Facts and Time Summary) Error executing job: 5158044
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 - :Determine current fiscal period: query returned no rows
Where: PL/pgSQL function cmn_job_datamart_rollup_sp(bigint,bigint) line 72 at RAISE
Executed:
call CMN_JOB_DATAMART_ROLLUP_SP ( 18329186, 5076225)
Release : 15.9.x, 16.x
Component : CA PPM SAAS DATAMART
There are no active fiscal time periods for 2023.