P6 Integration API - ProjectIssue.delete() Fails With Integrity Constraint Error (Doc ID 2066340.1)

Last updated on OCTOBER 20, 2015

Applies to:

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

Symptoms

When attempting to delete an issue using the API, the API will throw an integrity constraint error if the issue has any issue histories assigned to it.

com.primavera.bo.common.QueryTimeoutException: executeUpdateBatch: error occurred during batching: ORA-02292: integrity constraint (ADMUSER.FK_ISSUHIST_PROJISSU) violated - child record found

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

  1. Create a Project (In P6 or with API)
  2. Create an Issue on the Project.
  3. Create a Discussion on the Issue.
  4. Attempt to Delete the Issue via the API.



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