Failed migration

[David_Tsatsi]

Hi Guys

 

Is there a way of restarting a failed migration which failed due to insufficient space on the index table or do i need to  pull data again and then migrate it.

 

Regards

David

[Anon Anon]

Hi David,

 

If the status for the transaction shows up as a failed migration, you should be able to go to the Migrate window in Data Manager, click on the checkbox for it and try to migrate again.

 

The failed migration should still be in the staging table ready to be migrated. Only after the migration is successful will the staged data get purged during the purging cycle.

 

Thanks,

Gream Park

Services Consultant

CA Technologies | 2002 Summit Blvd Suite 1500 | Atlanta, GA 30319

Office: [phone] | [e-mail]

 

<mailto:[e-mail]>[CA]

 

<http://www.ca.com/us/default.aspx>[Twitter]<http://twitter.com/CAInc>[LinkedIn]<http://www.linkedin.com/company/1372?goback=.cps_1244823420724_1>[Facebook]<https://www.facebook.com/CATechnologies>[YouTube]<http://www.youtube.com/user/catechnologies>[Google]<https://plus.google.com/CATechnologies>[Slideshare]<http://www.slideshare.net/cainc>

[Legacy User]

Yes.

   There is a SQL command you can run to change the status from Failed back to "Staging Complete".

Then you can select it to migrate again.

Search the Wiki for the SQL code.  If you can find it there then look in PDFs that shipped with older versions of the product.

The AdminGuide in PDF form used to have that in it.

 

David

[Mohindra.Singh]

Hi David,

I have included the below steps to find all migration jobs that failed and change them to staging completed:

 

1. Find all migration jobs with migration jobs ("Migration failed", "Migration in Progress", "Migration Scheduled")
   SELECT transaction_id
   FROM transactions_config
   WHERE migrate_status_id IN ( 113, 111, 110);
2. Update all above migration jobs to Staging completed.
   UPDATE transactions_config
   SET status = 102,
   load_status_id = 102,
   migrate_status_id = NULL
   WHERE transaction_id IN
   (SELECT transaction_id FROM transactions_config WHERE migrate_status_id IN ( 113, 111, 110));
   commit;
   
   
   

hth,

Mohindra Singh