My Oracle Support Banner

Error: "ORA-02292: INTEGRITY CONSTRAINT (ADMUSER.FK_TASKACTV_TASK) VIOLATED," When Deleting a Project Through Professional Cloud Connect. (Doc ID 2550283.1)

Last updated on DECEMBER 04, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 18.8 to 18.8.4.0 [Release 18.8]
Primavera P6 Enterprise Project Portfolio Management - Version 18.8 to 18.8.4.0 [Release 18.8]
Information in this document applies to any platform.

Symptoms

When attempting to delete a Project from P6 Professional Client through ProCloudConnect, the Project cannot be deleted and no error is raised at the front end. The Professional Cloud Connect server log prints out below error:

ERROR:

<Error> <com.primavera.cloud.services.BaseServices> <BEA-000000> <
-- privuser::MACF484 (Primavera.CacheService) -- UTF-8 --
5474-2368-fe80::3104:4474:6fbd:90d1%21-131cfb77-cf2a-47ce-8fcb-58ec7a26d684
DB Connection oracle.jdbc.driver.T4CConnection@55d95703
Request type: EXECUTE_SQL
Command text: Generic_Delete
Parameter count: 3
0 -- INPUT -- String = ADMUSER.TASK
1 -- INPUT -- Integer = 39322
2 -- INPUT -- String = headerParam=pt|name,pw|proj_id
Block count: 53
Avg data block size: 12 bytes (before compression)
Total data size: 636 bytes (before compression)
Cumulative job[54] time spent to push in the queue: 1 ms
Cumulative job[54] time: 130678 ms (not including compression)

java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity
constraint (ADMUSER.FK_TASKACTV_TASK) violated - child record found
......

STEPS:

1. Log on Professional via ProCloudConnect with Client-side cache disabled.
2. Delete a Project, then it disappears from the Projects View.
3. Log out Professional and log back in. The "deleted" Project appears again.
4. The weblogic log for the ProCloudConnect server prints out above 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


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