Error "ORA-00001: unique constraint (ADMUSER.PK_TASKPRED) violated" When Using P6 Web Services to Create New Relationships (Doc ID 2995379.1)

Last updated on DECEMBER 29, 2023

Applies to:

Symptoms

When attempting to create relationships using P6 Web Services, the following error occurs.

ERROR
-----------------------
com.primavera.ws.p6.relationship.IntegrationFault: Error in DBEngine.executeUpdate.

Failed updating values with query: insert into taskpred ( taskpred.task_id, taskpred.pred_task_id, taskpred.lag_hr_cnt, taskpred.pred_type, taskpred.task_pred_id, taskpred.proj_id, taskpred.pred_proj_id ) values ( ?, ?, ?, ?, ?, ?, ? ) parms: 116244357, 116246041, 0.0, PR_FS, 236086643, 539744, 539744
Caused by: Error : 1, Position : 0, Sql = insert into taskpred ( taskpred.task_id, taskpred.pred_task_id, taskpred.lag_hr_cnt, taskpred.pred_type, taskpred.task_pred_id, taskpred.proj_id, taskpred.pred_proj_id ) values ( :1 , :2 , :3 , :4 , :5 , :6 , :7 ), OriginalSql = insert into taskpred ( taskpred.task_id, taskpred.pred_task_id, taskpred.lag_hr_cnt, taskpred.pred_type, taskpred.task_pred_id, taskpred.proj_id, taskpred.pred_proj_id ) values ( ?, ?, ?, ?, ?, ?, ? ), Error Msg = ORA-00001: unique constraint (ADMUSER5.PK_TASKPRED) violated

Changes

Cause

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