My Oracle Support Banner

Error Deleting Projects: 'CASCADE_DELETE Failure -1 - ORA-06502: PL/SQL: Numeric or Value Error: Invalid LOB Locator Specified: ORA-22275.' (Doc ID 2407460.1)

Last updated on JUNE 29, 2018

Applies to:

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

Symptoms

Error trying to delete a Project in P6 Professional:

ERROR
-----------------------
*****************************************************
* EXCEPTION REPORT *
*****************************************************
Date: 24-Apr-18

Executable: PM.exe
Application: Primavera P6 Professional 17
Event Code: CASCA-1474-6
Message:
  CASCADE_DELETE failure -1 - ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275
ORA-06512: at "SYS.DBMS_LOB", line 1139
ORA-06512: at "ADMUSER.PRM_PAUDIT", line 250
ORA-06512: at "ADMUSER.PRMAUD_TASKRSRC", line 58
ORA-04088: error during execution of trigger 'ADMUSER.PRMAUD_TASKRSRC' occured on delete for table TASKRSRC

Context:
  1: TfrmTemplateCopy.FormCreate
  2: TfrmOptionDialog.DoOptionDialogForm
  3: TCArcturusAssignMgr.ConfirmDeleteWBS
  4: TDevxMainForm.BeforeFormShow
  5: TfrmEPS.mnuOpenProjectClick
  6: TDevxMainForm.BeforeFormShow
  7: TDevxMainForm.BeforeFormShow
  8:
  9:
  10:

Detail:
  Type: Exception
  Object Type: TCVirtualQueryGrid


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Log into P6 Professional.
  2. Try to delete a Project.
  3. Notice the error.

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!


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