Migrating Matillion ETL 1.59.8 to 1.73.0, but migrate utility gets stuck HELP

Matillion ETL
1

I have a Matillion ETL/Snowflake instance version 1.59.8 that I wish to update to the latest (stable) version. In-place updates are not possible with the newest versions and I do not want to use that method anyway. I registered a new instance from Matillion Hub and installed from the published AMI. After starting the instance, I confirmed I have a functioning (but empty) Matillion ETL version 1.73.0.

 

My task now is to migrate (copy) all Matillion configurations and jobs to the new instance. I followed the migration steps from this Matillion doc https://docs.matillion.com/metl/docs/updating-and-migrating/#migration.

 

I used the ec2-user as the server admin to perform the migration, and both the source and target instances have the same login credentials as required. I opened and the migrate utility on the source (old) instance requested it to copy all projects/users/everything. Once I clicked the "Migrate" button to start, it quickly processed a few steps but after a few seconds the status message read "Migrating OAuths" and just hung (see screenshot below). I let it sit for hours before closing the window and seeing that the old and new instances remain unchanged. Are there any additional steps I can take to prevent or troubleshoot the issue?

069Tm000000yzwgIAA_0D5Tm000002hj2CKAQ
069Tm000000yzwgIAA_0D5Tm000002hj2CKAQ837×695 9.54 KB

Other details: The AWS instance type I am using on the old instance is t2.medium while the new instance is using m5.large. Both instances are in the same region but different availability zones. I don't know if any of these details would cause the migration to get stuck.

Thanks in advance for any help you can give.

2

UPDATE: I tried running the migration again with the OAuth unchecked. The migration utility was able to move slightly further but now gets hung up on "Migrating Extract Profiles...". I tried again with only few items checked, and it always gets hung up on something (e.g. "Migrating Credentials"). Although the dialog still says not to refresh or close the browser, I always have to close it after an hour or so passes. Any experience using this utility would be appreciated.

3

Hi,

Can I suggest you open a support case at https://support.matillion.com/ (You might need to scroll down a bit until you see the Submit Case button.) I'm not sure what the issue is there. In general we suggest you try and have as few "versions" in your projects as practical before the migration. Lot's of versions can cause long running migrations. But I'm not convinced that's your issue. Support should be best placed to help.

4

Thank you Phil! This solved the hang-up issue. We had about 20 versions of a project in our instance. I removed all but 4, and when the migrate ran it paused on the "Migrating OAuths" for about 15 seconds before continuing to completion. I confirmed the migration completed. Onto validation testing (Google Analytics primarily).