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 JANUARY 31, 2024
Applies to:
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 17.12.4.0 and laterPrimavera 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:
- Log into P6 Professional.
- Try to delete a Project.
- 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! |
In this Document
Symptoms |
Cause |
Solution |
References |