Create Baseline Fails for a Particular Project with Error "ORA-01427: Single-row Subquery Returns More than One Row"

(Doc ID 2207462.1)

Last updated on FEBRUARY 06, 2017

Applies to:

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

Symptoms

User is unable to create baseline for a particular project. The following error is seen from WebAccessLog.

ERROR
-----------------------
Nov-22-2016 14:13:23 725 PrmThread-11 ERROR DB Id: 1 com.primavera.dbcrudutil.CreateBaselineJobService ?:? Error while running Create Baseline Service:StatementCallback; bad SQL grammar [select count(*) from PROJECT,PROJWBS where PROJECT.PROJ_ID=PROJWBS.PROJ_ID and proj_node_flag='Y' and orig_proj_id is null start with WBS_ID=(select WBS_ID from PROJWBS where PROJ_ID=4625 and proj_node_flag='Y' and orig_proj_id is null) connect by prior WBS_ID=PARENT_WBS_ID]; nested exception is java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
Nov-22-2016 14:13:23 740 PrmThread-11 ERROR DB Id: 1 com.primavera.jobsvc.common.JobServiceExecutable ?:? Job error running job of type JT_CreateBaseline on database1
com.primavera.PhoenixException: StatementCallback; bad SQL grammar [select count(*) from PROJECT,PROJWBS where PROJECT.PROJ_ID=PROJWBS.PROJ_ID and proj_node_flag='Y' and orig_proj_id is null start with WBS_ID=(select WBS_ID from PROJWBS where PROJ_ID=4625 and proj_node_flag='Y' and orig_proj_id is null) connect by prior WBS_ID=PARENT_WBS_ID]; nested exception is java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
  
  at com.primavera.dbcrudutil.CreateBaselineJobService.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)
Nov-22-2016 14:13:23 740 PrmThread-11 ERROR DB Id: 1 com.primavera.jobsvc.common.JobServiceExecutable ?:? Marking job id 4483 as failure



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create baseline for a specific project.

ADDITIONAL INFO
-----------------------

Issue can be reproduced when importing the same project to lab.

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms