Alert:"The value entered for Project must be Unique". Is there any method through which we can provi

Problem:-

When changing the Project ID of a Project, the following error occurs:

ERROR

---------------------

"The value entered for Project ID must be unique."

Reason:-

There are two possible causes to this issue:

• CAUSE #1:  The Project ID which was entered is being used for a Baseline.  Baselines are entire projects and have Project IDs.  Each Project ID must be unique in the database, among both Projects and Baselines.
• CAUSE #2:  There are orphaned records in the database which contain the same PROJECT.proj_short_name as the name attempting to be updated.

Solution:-

First Part:-

The following SQL query can be used to find the conflicting project reference: