Update the Duplicate Project Names

Follow this procedure to update the duplicate project names.

To update the duplicate project names.

1. Locate the rows with a NULL value for the Project ID column from the returned results after identifying the duplicate project names. These rows are duplicate records that differ in case from the Project ID.
2. Rename or delete each of the duplicate records.
   • To rename the duplicate Dir ID, run the following query:

     
     UPDATE WST_DIR SET DIR_ID = ‘<Updated Dir ID>’ WHERE TABLE_TYPE = 
     ‘PROGRAM’ AND DIR_UID=’<Dir Uid on the duplicate record>’

     Example

     
     UPDATE WST_DIR SET DIR_ID =’Demo_Renamed’ WHERE 
     TABLE_TYPE=’PROGRAM’ AND DIR_UID = ‘DUPUID_03’

   • To delete the duplicate DIR ID, run the following query:

     
     DELETE FROM WST_DIR WHERE DIR_UID=’<Dir Uid on the duplicate record>’

     Example

     DELETE FROM WST_DIR WHERE DIR_UID= ‘DUPUID_03’

   Important: If you are using Oracle, do not forget to commit after running the UPDATE or DELETE statements to ensure that they are reflected on your database.
3. Identify if there are multiple rows with the same case and value in both the Project ID and Dir ID columns from the returned results after identifying the duplicate project names.
   

   Having multiple rows with the same case and value in the Project ID and Dir ID columns indicates duplicate records. You need to address these duplicates so that only one row remains with the same case and value in both the Dir ID and Project ID columns. In the example above, one of the Demo projects highlighted in red must be updated, as it is marked as a duplicate of the other.

   To help you determine which record is a duplicate, you can check for existing access rights related to the project record. If a record has access rights defined and the others do not, the record with access rights is the one to keep.

   To check for access rights records related to a project record:

   • Run the following query for each record that has the same name and value in the Project ID and Dir ID columns.

     SELECT COUNT(1) FROM WST_ACL WHERE DIR_UID = ‘<Dir Uid>’

     Note: Replace <Dir Uid> with the Dir Uid value for the row you are checking.
   • If the query returns a value greater than 0, the project record has access rights defined.
   • Perform Step 2 for each duplicate record.
4. Rerun the query from Step 2 to verify that there are no longer any duplicate records. If you have successfully renamed or deleted the duplicate records, the query will return no results.
5. Relaunch Cobra to verify that the error no longer occurs.