Migration process to new ConnectALL Rally adapter fails
Article ID: 369673
Updated On:
Products
Issue/Introduction
When running the migration process from the legacy Rally adapter to the new Rally adapter, the request fails and shows the following error:
{"errorCode":400,"errorMessage":"Unexpected error during migration, migration rolled back and aborted."}
ConnectALL.log shows the following error:
ERROR yyyy-MM-DD HH:mm:ss,SSS http-nio-8080-exec-1 com.g2g.dao.ConnectAllDAO - Error during executing migration: java.sql.BatchUpdateException: Violation of UNIQUE KEY constraint 'record_map_unique_index'. Cannot insert duplicate key in object 'dbo.record_map'. The duplicate key value is (<source_app_id>, <dest_app_id>, <source_record_id>, <source_project>).
Environment
3.4 and higher
Cause
This can be caused if records already exist in the database due to the automation being allowed to synchronize.
Resolution
Prequisites:
You will need access to the ConnectALL database in order to resolve this
Open the ConnectALL.log and find the line that shows the migration failure that appears as follows:
ERROR yyyy-MM-DD HH:mm:ss,SSS http-nio-8080-exec-1 com.g2g.dao.ConnectAllDAO - Error during executing migration: java.sql.BatchUpdateException: Violation of UNIQUE KEY constraint 'record_map_unique_index'. Cannot insert duplicate key in object 'dbo.record_map'. The duplicate key value is (<source_app_id>, <dest_app_id>, <source_record_id>, <source_project>).
Take the source_app_id and use it to construct the following query:
DELETE FROM record_map WHERE source_app_id='<source_app_id>';
Log into your SQL server and open a SQL query window
Run the query you crafted above
Rerun the migration for the automation
Feedback
