Skip to main content
A
AT_1223370810-Marble
10-Marble
February 24, 2025
Solved

Intermediate upgrade to 10.2 slow

  • February 24, 2025
  • 2 replies
  • 818 views
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.
    Best answer by avillanueva

    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. 

    2 replies

    avillanueva
    23-Emerald I
    avillanueva23-Emerald IAnswer
    23-Emerald I
    February 24, 2025

    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. 

      A
      AT_1223370810-MarbleAuthor
      10-Marble
      February 24, 2025

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

       

      M
      mmeadows-316-Pearl
      16-Pearl
      February 24, 2025

      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?

       

        A
        AT_1223370810-MarbleAuthor
        10-Marble
        February 24, 2025

        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!

        Terms & ConditionsAccessibility statement