System Error generated when users create or modify a Project Baseline

book

Article ID: 140239

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM On Premise

Issue/Introduction

When a user tries to create a Baseline on a project, the Baseline gets created but a 'System Error'gets displayed across the page
Also when any modifications made to the Baseline results in a 'System Error'.
The 'Revision ID' attribute which is auto numbered also gets incremented by a value of 2 instead of 1.
 
Error from app-ca.log:
ERROR 2019-11-14 15:17:52,720 [http-nio-80-exec-330] niku.njs (clarity:f043867:6732064__48019920-4617-4824-A32C-B418116C4F33:projmgr.baselineRevisionPropertiesCreate) Error getting job 5007002
com.niku.union.exceptions.SchedulerException: No such job with id 5007002

Error from bg-ca.log:

ERROR 2019-11-14 15:17:52,078 [Action Execution Pipeline 0 (tenant=clarity)] niku.njs (clarity:process_admin:6738041__6C57A46D-8CE0-4D29-8E67-312041FCA7BC:none) Error getting job 5007002
com.niku.union.exceptions.SchedulerException: No such job with id 5007002

ERROR 2019-11-14 15:17:52,094 [Action Execution Pipeline 0 (tenant=clarity)] bpm.engine (clarity:process_admin:6738041__6C57A46D-8CE0-4D29-8E67-312041FCA7BC:none) Error (will retry) caused by Step Instance: [email protected] [Id: 5053002 Process Instance Id: 5043007 Step Id: 5005002 State: BPM_SIS_READY_TO_EXEC_ACTION Step Name: null Start Date: 2019-07-17 13:08:28.0 Expected End Date: null Percent Complete: 0.0 Warned: false Retry Count: 558 No of Pre Conditions: -1 No of Post Conditions: -1 Last Condition Eval Time: 0 Pre Condition Wait Events: null Post Condition Wait Events: null Pass Conditions: [] Error Id: -1

Caused by: java.sql.SQLIntegrityConstraintViolationException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into ("NIKU"."CMN_SCH_JOBS"."NAME")

Environment

Release : 15.3, 15.4, 15.5, 15.6.1, 15.7

Component : CA PPM PROJECT MANAGEMENT

Resolution

When a Project Baseline is created or updated, the 'Update Earned Value Totals' job gets executed in the background.

In this scenario, the job had been made inactive and therefore resulted in the above error messages in the log file.

To resolved the issue, activate the 'Update Earned Value Totals' job again.