Global Publication Services Failing With Error: "ORA-01427: single-row subquery returns more than one row" and Project Arbiter Not Running
(Doc ID 2772460.1)
Last updated on MAY 12, 2021
Applies to:
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 19.12.12.0 and laterInformation in this document applies to any platform.
Symptoms
ACTUAL BEHAVIOR
---------------
When attempting to run Global Publication services (Publish Enterprise Summaries, Publish Resource Management, Publish Security, Publish Enterprise Data, and Publish Audit Data) the following error occurs in the log:
ORA-01427: single-row subquery returns more than one row
Example:
[6] POST(BRE): DBEngine.executeSelect() error while executing: {SELECT rsrcrole.rsrc_id ResourceId,rsrcrole.role_id RoleId FROM rsrcrole WHERE (rsrcrole.update_date >= ( Select to_date(Setting_Value,'yyyy-mm-dd hh24:mi:ss') from Settings where namespace = 'PxService.ResourceRole.PxResourceRole.Task' AND Setting_name = 'LastSafetyDate')) ORDER BY rsrcrole.rsrc_id,rsrcrole.role_id} --ORA-01427: single-row subquery returns more than one row
Also, the Project Arbiter job is stuck and does not run, but there is no additional logging for the failures. As a result of the arbiter not running, no projects are published.
EXPECTED BEHAVIOR
-----------------------
Global Publication services and the Project Arbiter service for Project Publication should be running on the scheduled intervals.
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 |