Error 'Failed saving baseline data' When Attempting to Save a Baseline in P6 Web, OR 'The job request you submitted did not complete successfully' When Attempting to Add a Baseline in P6 Professional (Doc ID 2038391.1)

Last updated on AUGUST 21, 2023

Applies to:

Symptoms

SYMPTOM #1

When attempting to save baseline for a project from P6 (web) whether attempting to create a new baseline or make a change to an existing baseline, the following error occurs:

ERROR IN P6 WEB:

Failed saving baseline data

ERROR IN P6WEBACCESS.HTML:

TIMESTAMP [ACTIVE] ExecuteThread: '5' for queue:
'weblogic.kernel.Default (self-tuning)' ERROR /BO (User Id: ### DB Id: #)
com.primavera.bo.remotable.RemoteRequest ?:? Failed updating data for web pm
com.primavera.guisupport.activities.baseline.ProjectBaselineDataSaver
com.primavera.bo.remoting.RemoteDataException: Failed saving baseline data
    at com.primavera.guisupport.activities.baseline.ProjectBaselineDataSaver.saveStore(Unknown Source)
    ...
Caused by: java.lang.NullPointerException
    at com.oracle.pgbu.core.CrudStatus.getRootStepId(CrudStatus.java:30)
    at com.primavera.bo.base.LDBEngineImpl.copyProject(Unknown Source)
    at com.primavera.bo.remotable.BOJobs.copyProject(Unknown Source)
    at com.primavera.bo.remotable.qproxy.BOJobs.copyProject(Unknown Source)
    at com.primavera.bo.DBBOJobs.copyProject(Unknown Source)

The issue can be reproduced at will using the following steps:

1. Log into P6 Web.
2. Select the Project tab and open a project.
3. Select Activities > Actions > Define Baselines.
4. Click the + icon to add a baseline.
5. Click Save.
6. Note the reported error.
   
   

SYMPTOM #2

When attempting to create a new baseline the job fails with the following error:

ERROR IN P6 PROFESSIONAL:

The job request you submitted did not complete successfully.

ERROR IN P6WEBACCESS.HTML:

<TIMESTAMP> PrmThread-11 ERROR com.primavera.infr.dbcrud.core.JdbcTemplateDAO ?:? PreparedStatementCallback; SQL [insert into SUMTASK(PROJ_ID,WBS_ID,BCWP,BCWS,EAC,EAC_WORK_QTY,ETC,ETC_WORK_QTY,PERFM_WORK_QTY,SCHED_WORK_QTY,COMPLETE_CNT,ACTIVE_CNT,NOTSTARTED_CNT,BASE_COMPLETE_CNT,BASE_ACTIVE_CNT,BASE_NOTSTARTED_CNT,ACT_DRTN_HR_CNT,TOTAL_DRTN_HR_CNT,BASE_DRTN_HR_CNT,REMAIN_DRTN_HR_CNT,TOTAL_FLOAT_HR_CNT,ACT_END_DATE,ACT_START_DATE,BASE_END_DATE,BASE_START_DATE,REEND_DATE,RESTART_DATE,ACT_THIS_PER_WORK_COST,ACT_THIS_PER_WORK_QTY,ACT_THIS_PER_EQUIP_COST,ACT_THIS_PER_EQUIP_QTY,ACT_THIS_PER_MAT_COST,ACT_COST,ACT_EQUIP_COST,ACT_EXPENSE_COST,ACT_MAT_COST,ACT_WORK_COST,ACT_EQUIP_QTY,ACT_WORK_QTY,BASE_COST,BASE_EQUIP_COST,BASE_EXPENSE_COST,BASE_MAT_COST,BASE_WORK_COST,BASE_EQUIP_QTY,BASE_WORK_QTY,REMAIN_COST,REMAIN_EQUIP_COST,REMAIN_EXPENSE_COST,REMAIN_MAT_COST,REMAIN_WORK_COST,REMAIN_EQUIP_QTY,REMAIN_WORK_QTY,TARGET_COST,TARGET_EQUIP_COST,TARGET_EXPENSE_COST,TARGET_MAT_COST,TARGET_WORK_COST,TARGET_EQUIP_QTY,TARGET_WORK_QTY,TOTAL_COST,TOTAL_EQUIP_COST,TOTAL_EXPENSE_COST,TOTAL_MAT_COST,TOTAL_WORK_COST,TOTAL_EQUIP_QTY,TOTAL_WORK_QTY,TARGET_START_DATE,TARGET_END_DATE,TARGET_DRTN_HR_CNT) select xref1.new_id,xref2.new_id,BCWP,BCWS,EAC,EAC_WORK_QTY,ETC,ETC_WORK_QTY,PERFM_WORK_QTY,SCHED_WORK_QTY,COMPLETE_CNT,ACTIVE_CNT,NOTSTARTED_CNT,BASE_COMPLETE_CNT,BASE_ACTIVE_CNT,BASE_NOTSTARTED_CNT,ACT_DRTN_HR_CNT,TOTAL_DRTN_HR_CNT,BASE_DRTN_HR_CNT,REMAIN_DRTN_HR_CNT,TOTAL_FLOAT_HR_CNT,ACT_END_DATE,ACT_START_DATE,BASE_END_DATE,BASE_START_DATE,REEND_DATE,RESTART_DATE,ACT_THIS_PER_WORK_COST,ACT_THIS_PER_WORK_QTY,ACT_THIS_PER_EQUIP_COST,ACT_THIS_PER_EQUIP_QTY,ACT_THIS_PER_MAT_COST,ACT_COST,ACT_EQUIP_COST,ACT_EXPENSE_COST,ACT_MAT_COST,ACT_WORK_COST,ACT_EQUIP_QTY,ACT_WORK_QTY,BASE_COST,BASE_EQUIP_COST,BASE_EXPENSE_COST,BASE_MAT_COST,BASE_WORK_COST,BASE_EQUIP_QTY,BASE_WORK_QTY,REMAIN_COST,REMAIN_EQUIP_COST,REMAIN_EXPENSE_COST,REMAIN_MAT_COST,REMAIN_WORK_COST,REMAIN_EQUIP_QTY,REMAIN_WORK_QTY,TARGET_COST,TARGET_EQUIP_COST,TARGET_EXPENSE_COST,TARGET_MAT_COST,TARGET_WORK_COST,TARGET_EQUIP_QTY,TARGET_WORK_QTY,TOTAL_COST,TOTAL_EQUIP_COST,TOTAL_EXPENSE_COST,TOTAL_MAT_COST,TOTAL_WORK_COST,TOTAL_EQUIP_QTY,TOTAL_WORK_QTY,TARGET_START_DATE,TARGET_END_DATE,TARGET_DRTN_HR_CNT from SUMTASK JOIN PC_KEY_XREF xref1 ON PROJ_ID=xref1.source_id and xref1.ref_table='PROJECT' and xref1.execution_id=? LEFT OUTER JOIN PC_KEY_XREF xref2 ON WBS_ID=xref2.source_id and xref2.ref_table='PROJWBS' and xref2.execution_id=? where PROJ_ID in (select source_id from PC_KEY_XREF where REF_TABLE ='PROJECT' and execution_id=?)]; ORA-02291: integrity constraint (ADMUSER1.FK_SUMTASK_PROJWBS) violated - parent key not found ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (ADMUSER1.FK_SUMTASK_PROJWBS) violated - parent key not found

<TIMESTAMP> PrmThread-18 ERROR com.primavera.infr.dbcrud.core.JdbcTemplateDAO ?:? PreparedStatementCallback; SQL [insert into SUMTASKSPREAD(PROJ_ID,WBS_ID,START_DATE,END_DATE,SPREAD_TYPE,ACT_COST,ACT_EQUIP_COST,ACT_EXPENSE_COST,ACT_MAT_COST,ACT_WORK_COST,ACT_EQUIP_QTY,ACT_WORK_QTY,BASE_COST,BASE_EQUIP_COST,BASE_EXPENSE_COST,BASE_MAT_COST,BASE_WORK_COST,BASE_EQUIP_QTY,BASE_WORK_QTY,LATE_REMAIN_COST,LATE_REMAIN_EQUIP_COST,LATE_REMAIN_EXPENSE_COST,LATE_REMAIN_MAT_COST,LATE_REMAIN_WORK_COST,LATE_REMAIN_EQUIP_QTY,LATE_REMAIN_WORK_QTY,REMAIN_COST,REMAIN_EQUIP_COST,REMAIN_EXPENSE_COST,REMAIN_MAT_COST,REMAIN_WORK_COST,REMAIN_EQUIP_QTY,REMAIN_WORK_QTY,TARGET_COST,TARGET_EQUIP_COST,TARGET_EXPENSE_COST,TARGET_MAT_COST,TARGET_WORK_COST,TARGET_EQUIP_QTY,TARGET_WORK_QTY,TOTAL_COST,TOTAL_EQUIP_COST,TOTAL_EXPENSE_COST,TOTAL_MAT_COST,TOTAL_WORK_COST,TOTAL_EQUIP_QTY,TOTAL_WORK_QTY,BCWP,BCWS,EAC,EAC_WORK_QTY,ETC,ETC_WORK_QTY,PERFM_WORK_QTY,SCHED_WORK_QTY,FIN_PERIOD_ACT_WORK_QTY,FIN_PERIOD_ACT_WORK_COST,FIN_PERIOD_ACT_EQUIP_QTY,FIN_PERIOD_ACT_EQUIP_COST,FIN_PERIOD_ACT_MAT_COST,FIN_PERIOD_ACT_EXPENSE_COST,FIN_PERIOD_TOTAL_WORK_QTY,FIN_PERIOD_TOTAL_WORK_COST,FIN_PERIOD_TOTAL_EQUIP_QTY,FIN_PERIOD_TOTAL_EQUIP_COST,FIN_PERIOD_TOTAL_MAT_COST,FIN_PERIOD_TOTAL_EXPENSE_COST,FIN_PERIOD_TOTAL_COST,FIN_PERIOD_ACT_COST,FIN_PERIOD_BCWP,FIN_PERIOD_PERFM_WORK_QTY,FIN_PERIOD_EAC,FIN_PERIOD_EAC_WORK_QTY,FIN_PERIOD_BCWS,FIN_PERIOD_SCHED_WORK_QTY) select xref1.new_id,xref2.new_id,START_DATE,END_DATE,SPREAD_TYPE,ACT_COST,ACT_EQUIP_COST,ACT_EXPENSE_COST,ACT_MAT_COST,ACT_WORK_COST,ACT_EQUIP_QTY,ACT_WORK_QTY,BASE_COST,BASE_EQUIP_COST,BASE_EXPENSE_COST,BASE_MAT_COST,BASE_WORK_COST,BASE_EQUIP_QTY,BASE_WORK_QTY,LATE_REMAIN_COST,LATE_REMAIN_EQUIP_COST,LATE_REMAIN_EXPENSE_COST,LATE_REMAIN_MAT_COST,LATE_REMAIN_WORK_COST,LATE_REMAIN_EQUIP_QTY,LATE_REMAIN_WORK_QTY,REMAIN_COST,REMAIN_EQUIP_COST,REMAIN_EXPENSE_COST,REMAIN_MAT_COST,REMAIN_WORK_COST,REMAIN_EQUIP_QTY,REMAIN_WORK_QTY,TARGET_COST,TARGET_EQUIP_COST,TARGET_EXPENSE_COST,TARGET_MAT_COST,TARGET_WORK_COST,TARGET_EQUIP_QTY,TARGET_WORK_QTY,TOTAL_COST,TOTAL_EQUIP_COST,TOTAL_EXPENSE_COST,TOTAL_MAT_COST,TOTAL_WORK_COST,TOTAL_EQUIP_QTY,TOTAL_WORK_QTY,BCWP,BCWS,EAC,EAC_WORK_QTY,ETC,ETC_WORK_QTY,PERFM_WORK_QTY,SCHED_WORK_QTY,FIN_PERIOD_ACT_WORK_QTY,FIN_PERIOD_ACT_WORK_COST,FIN_PERIOD_ACT_EQUIP_QTY,FIN_PERIOD_ACT_EQUIP_COST,FIN_PERIOD_ACT_MAT_COST,FIN_PERIOD_ACT_EXPENSE_COST,FIN_PERIOD_TOTAL_WORK_QTY,FIN_PERIOD_TOTAL_WORK_COST,FIN_PERIOD_TOTAL_EQUIP_QTY,FIN_PERIOD_TOTAL_EQUIP_COST,FIN_PERIOD_TOTAL_MAT_COST,FIN_PERIOD_TOTAL_EXPENSE_COST,FIN_PERIOD_TOTAL_COST,FIN_PERIOD_ACT_COST,FIN_PERIOD_BCWP,FIN_PERIOD_PERFM_WORK_QTY,FIN_PERIOD_EAC,FIN_PERIOD_EAC_WORK_QTY,FIN_PERIOD_BCWS,FIN_PERIOD_SCHED_WORK_QTY from SUMTASKSPREAD JOIN PC_KEY_XREF xref1 ON PROJ_ID=xref1.source_id and xref1.ref_table='PROJECT' and xref1.execution_id=? LEFT OUTER JOIN PC_KEY_XREF xref2 ON WBS_ID=xref2.source_id and xref2.ref_table='PROJWBS' and xref2.execution_id=? where PROJ_ID in (select source_id from PC_KEY_XREF where REF_TABLE ='PROJECT' and execution_id=?)]; ORA-02291: integrity constraint (ADMUSER1.FK_SUMTASKSPREAD_PROJWBS) violated - parent key not found ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (ADMUSER1.FK_SUMTASKSPREAD_PROJWBS) violated - parent key not found
Aug-01-2018 16:16:05 851, EDT PrmThread-24 ERROR com.primavera.infr.dbcrud.core.JdbcTemplateDAO ?:? PreparedStatementCallback; SQL [insert /*+ index(TASKACTV,NDX_TASKACTV_PROJ_TASK_ACTV) */ into TASKACTV(TASK_ID,ACTV_CODE_TYPE_ID,ACTV_CODE_ID,PROJ_ID,UPDATE_DATE,UPDATE_USER,CREATE_DATE,CREATE_USER,DELETE_SESSION_ID,DELETE_DATE) select /*+ index(TASKACTV,NDX_TASKACTV_PROJ_TASK_ACTV) */ xref1.new_id,NVL(xref2.new_id,ACTV_CODE_TYPE_ID),NVL(xref3.new_id,ACTV_CODE_ID),xref4.new_id,null,UPDATE_USER,null,CREATE_USER,DELETE_SESSION_ID,null from TASKACTV LEFT OUTER JOIN PC_KEY_XREF xref1 ON TASK_ID=xref1.source_id and xref1.ref_table='TASK' and xref1.execution_id=? LEFT OUTER JOIN PC_KEY_XREF xref2 ON ACTV_CODE_TYPE_ID=xref2.source_id and xref2.ref_table='ACTVTYPE' and xref2.execution_id=? LEFT OUTER JOIN PC_KEY_XREF xref3 ON ACTV_CODE_ID=xref3.source_id and xref3.ref_table='ACTVCODE' and xref3.execution_id=? JOIN PC_KEY_XREF xref4 ON PROJ_ID=xref4.source_id and xref4.ref_table='PROJECT' and xref4.execution_id=? where PROJ_ID in (select source_id from PC_KEY_XREF where REF_TABLE ='PROJECT' and execution_id=?)]; ORA-02291: integrity constraint (ADMUSER1.FK_TASKACTV_ACTVCODE) violated - parent key not found ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (ADMUSER1.FK_TASKACTV_ACTVCODE) violated - parent key not found

<TIMESTAMP> PrmThread-47 ERROR DB Id: 1 com.primavera.dbcrudutil.CreateBaselineJobService ?:? Error while running Create Baseline Service:null

<TIMESTAMP> PrmThread-47 ERROR DB Id: 1 com.primavera.jobsvc.common.JobServiceExecutable ?:? Job error running job of type JT_CreateBaseline on database1
com.primavera.PhoenixException
at com.primavera.dbcrudutil.CreateBaselineJobService.runJob(CreateBaselineJobService.java:180)
at com.primavera.jobsvc.common.JobServiceExecutable.c(JobServiceExecutable.java:254)
at com.primavera.jobsvc.common.JobServiceExecutable.a(JobServiceExecutable.java:197)
at com.primavera.jobsvc.common.JobServiceExecutable.execute(JobServiceExecutable.java:137)
at com.primavera.infr.threadpool.ThreadPoolImpl.run(ThreadPoolImpl.java:343)
at java.lang.Thread.run(Thread.java:748)

<TIMESTAMP> PrmThread-47 ERROR DB Id: # com.primavera.jobsvc.common.JobServiceExecutable ?:? Marking job id 2153 as failure

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.