Error: "java.sql.SQLIntegrityConstraintViolationException: ORA-01400: Cannot Insert NULL Into ("ADMUSER"."TASKRSRC"."TASK_ID")" or "("ADMUSER."TASKACTV"."TASK_ID")" or "("ADMUSER"."TASKMEMO"."TASK_ID")" Copy/Pasting Projects (Doc ID 2190755.1)

Last updated on OCTOBER 25, 2016

Applies to:

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


When attempting to copy/paste a project in P6 Professional or P6 Web, the copy/paste job fails and one of the following errors are logged to the P6WebAccess.html Log file:


The issue can be reproduced at will with the following steps:
1. Login to P6 Professional or P6 Web
2. Copy and Paste a project
3. View the job status and note the failure
4. Note the associated job failure message in P6WebAccess.html

Using 15.2.9 p6services, the copy/paste operation completes "with a successful status", however, the errors still occur in the P6WebAccess.html log file and result in missing rows from the newly created project in the associated table above.


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