Intermediate upgrade to 10.2 slow

[AT_12233708]

I am upgrading a 9.1 version to 12.1.x
I am going trough intermediate upgrades.
First step is from 9.1 to 10.2
II am using Windchill PDMLink Release 10.2 and Datecode with latest datecode.

Upgrade Manager is very slow during the execute standalone migrator phase.

Here are the errors that I faced
No specific errors in the UpgradeManager logs. Operations take hours and if connection drops I have to restart from zero.
Las observation took more than 4,30 hours.

[avillanueva · Accepted solution]

I've done a fair amount of upgrades over the years and they have gotten faster. I would remember certain points taking much longer in the past than recent upgrades. I did find this article that speaks to your issue:

https://www.ptc.com/en/support/article/CS243308?source=search

A lot depends upon the size of your installation and amount of data you have. I would make sure that you can ensure that things are tuned properly, you have sufficient memory for the process to run and you address your connectivity issues such that you do not have an issue with things dropping. I might recommend a stable host where you can remote into and have the upgrade process running. This way if you lose connection, process still runs regardless. Monitor the log files, CPU activity on both the target server and database to make sure gears are still turning. I would be concerned if both ends went idle. 

[AT_12233708]

Thank You for the suggestions, I'll adopt and let you know!

[AT_12233708]

A complete retuning fixed the issue, Thank you!

[mmeadows-3]

Depending on the size of the database and the largest tables in the database, 4.5 hours is not too long.

How large is the database dump file?

What is the database software and version?

Which migrator is taking the most time?

Did you performance tune the database and the Windchill DB connection properties?

https://www.ptc.com/en/support/article/CS51908

What connection is dropping, the connection between the application and DB?

[AT_12233708]

Database is oracle 11g, and i made the initial tunings.
the operation taking so long is DerviedFrom Column Migrator in the Execute Standalone Migrators group.
Thank You!

[AT_12233708]

the connection dropping is the remote xterminal connection that undergoes the UpgradeManager Java UI.