Database Server Error: 'ORA-01422: Exact Fetch Returns More Than Requested Number Of Rows' When Upgrading Project Management

(Doc ID 908764.1)

Last updated on JULY 05, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version: 6.1
All Platforms

Symptoms

The following errors occur when upgrading to Project Management v6.2:

[ERROR] ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "ADMUSER.ADD_DATABASE_JOB", line 1 ORA-06512: at "ADMUSER.INITIALIZE_BACKGROUND_PROCS", line 1 ORA-06512: at line 1
[ERROR] Database Error: error number=1422
[ERROR] Error Message: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "ADMUSER.ADD_DATABASE_JOB", line 1 ORA-06512: at "ADMUSER.INITIALIZE_BACKGROUND_PROCS", line 1 ORA-06512: at line 1

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