Copy Project Fails When Project ID Has a Dash and Ends with a Period (Doc ID 2978736.1)

Last updated on NOVEMBER 29, 2023

Applies to:

Symptoms

When copying a Project whose Project ID contains a dash and ends with a period, the Job Status shows as failed.
 
Example:
Project ID = Test-2.

When removing either the dash or the period at the end, the copy project action is successful.

ERROR

Copy project has failed.

From WebAccess logs:

Procedure EXEC_DBCRUD_STMT_WITH_RETRY Couldn't execute the query, Reason: Cannot insert the value NULL into column 'proj_short_name', table 'PMDB.dbo.PROJECT'; column does not allow nulls. INSERT fails.
Procedure EXEC_DBCRUD_STMT_WITH_RETRY Couldn't execute the query, Reason: Cannot insert the value NULL into column 'wbs_short_name', table 'PMDB.dbo.PROJWBS'; column does not allow nulls. INSERT fails.
Procedure EXEC_DBCRUD_STMT_WITH_RETRY Couldn't execute the query, Reason: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_task_project". The conflict occurred in database "PMDB", table "dbo.PROJECT", column 'proj_id'.
Error while running Copy Project Service
java.lang.NullPointerException

STEPS TO REPRODUCE

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

1. Login to P6 Pro.
2. Go to Enterprise > Projects.
3. Attempt to copy/paste a project containing a "-" and ending with a ".", like "Test-2.".
4. Receive error.

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.