My Oracle Support Banner

When Adding a Baseline Project, the Following Message is Shown: Job status XXXX The Job Request You Submitted Did Not Complete Successfully (Doc ID 2117634.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 15.2.0.0 and later
Information in this document applies to any platform.

Symptoms


When trying to add a baseline in P6 Professional, the following message is returned:

Job status XXXX The job request you submitted did not complete successfully

The following is visible in the p6webaccess.html log:

Feb-01-2016 08:28:51 685 PrmThread-39 ERROR DB Id: 13 com.primavera.dbcrudutil.CopyProjectJobService ?:? Error while running Copy Project Service:PreparedStatementCallback; bad SQL grammar [insert into PC_PROCESS_STAT (PC_PROCESS_STAT_ID,EXECUTION_ID,PROCESS_NAME,STEP_NAME,STATUS,ESTIMATED_TIME) values(PC_PROCESS_STAT_SEQ.nextval,?,?,?,?,?)]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist Feb-01-2016 08:28:51 685 PrmThread-39 ERROR DB Id: 13 com.primavera.jobsvc.common.JobServiceExecutable ?:? Job error running job of type JT_CopyService on database13 com.primavera.PhoenixException: PreparedStatementCallback; bad SQL grammar [insert into PC_PROCESS_STAT (PC_PROCESS_STAT_ID,EXECUTION_ID,PROCESS_NAME,STEP_NAME,STATUS,ESTIMATED_TIME) values(PC_PROCESS_STAT_SEQ.nextval,?,?,?,?,?)]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  
  at com.primavera.dbcrudutil.CopyProjectJobService.runJob(Unknown Source)
  at com.primavera.jobsvc.common.JobServiceExecutable.c(Unknown Source)
  at com.primavera.jobsvc.common.JobServiceExecutable.a(Unknown Source)
  at com.primavera.jobsvc.common.JobServiceExecutable.execute(Unknown Source)
  at com.primavera.infr.threadpool.ThreadPoolImpl.run(Unknown Source)
  at java.lang.Thread.run(Thread.java:745) Feb-01-2016 08:28:51 685 PrmThread-39 ERROR DB Id: 13 com.primavera.jobsvc.common.JobServiceExecutable ?:? Marking job id 5019 as failure



The issue can be reproduced at will with the following steps:
1. Log into P6 Professional.
2. Open a project.
3. Select Project > Maintain Baselines > Add from the menu.
4. View the log file by selecting Tools > Job Status in P6 Professional, or Projects > EPS > Actions > View Service Status in P6 Web.


Due to this issue, users cannot copy projects or create baselines.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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