My Oracle Support Banner

Error: "ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified" When Attempting to Upgrade a P6 Database (Doc ID 2543703.1)

Last updated on MARCH 22, 2022

Applies to:

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

Symptoms

When attempting to upgrade an EPPM database from 15.2.11 to 18.8.0 using dbsetup.bat the following error is noted:
<04.30.2019 16:23:38> [ERROR] [2019-04-30 16:23:38] Database Error: error
number=6502
<04.30.2019 16:23:38> [ERROR] [2019-04-30 16:23:38] Error Message: ORA-06502:
PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275
ORA-06512: at "SYS.DBMS_LOB", line 650
ORA-06512: at line 24

<04.30.2019 16:23:38> [WARN] [2019-04-30 16:23:38] [USER] Could not complete
because the job "Run SQL Script ORPM_P1525.sql" failed.
com.primavera.database.tools.DatabaseToolException: ORA-06502: PL/SQL:
numeric or value error: invalid LOB locator specified: ORA-22275
ORA-06512: at "SYS.DBMS_LOB", line 650
ORA-06512: at line 24

Steps to Duplicate:

  1. Launch dbsetup
  2. Enter in required fields
  3. Observe error

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.