My Oracle Support Banner

Error: "ORA-02292: integrity constraint (ADMUSER.FK_PROJCOSTCBSSPREAD_CBS) violated - child record found" invoking CBS Services DeleteCBSs Operation using P6 Web Services (Doc ID 2507240.1)

Last updated on SEPTEMBER 09, 2019

Applies to:

Primavera Web Services - Version 17.12.4.0 and later
Information in this document applies to any platform.

Symptoms

On : 17.12.4.0 version, Business Objects

When attempting to invoke the CBS Services DeleteCBS Operation using P6 Web Services, the following errors are encountered, the following error occurs.

ERROR
-----------------------
Exception @ invokeDeleteService: com.primavera.ws.p6.cbs.IntegrationFault: Timeout error waiting for data. Please try again later. See server logs for more details

com.primavera.ws.jaxws.provider.ProviderBase invokeBase
       SEVERE: Exception caught in CRUD Provider:
       com.primavera.bo.common.QueryTimeoutException: executeUpdateBatch: error occurred during batching: ORA-02292: integrity constraint (ADMUSER.FK_PROJCOSTCBSSPREAD_CBS) violated - child record found

Caused By: java.sql.BatchUpdateException: error occurred during batching: ORA-02292: integrity constraint (ADMUSER.FK_PROJCOSTCBSSPREAD_CBS) violated - child record found

 

BUSINESS IMPACT
-----------------------
The issue has the following business impact: Due to this issue, users cannot delete CBS data using P6 Web Services



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.