Description:
This error may occur if duplicate rows exist in the 'rootcause' table and will cause the migration to fail.
The "SQLCheckr12UniqueIndexes.sql" and "OracleCheckr12UniqueIndexes.sql" scripts provided identify duplicate rows for some tables but not for the 'rootcause' table.
Solution:
To resolve the issue, manually run the following SQL statement to identify any duplicate rows:
SELECT sym, COUNT(*) AS 'NumberOfDups' FROM rootcause GROUP BY sym HAVING COUNT(*) > 1
If any duplicates are identified, take a backup of the 'rootcause' table, update the sym values and set the records to inactive via the Service Desk GUI.
Now re-run the migration and it should complete successfully.