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:

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

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