I am trying to upgrade from version 5 to 7. The upgrade works fine till 7. But when upgrading to 7.0.1, the upgrade is stuck with UUID update.how to fix this?
Without more details of your particular system, I’m just speculating here, but there are a few things you might want to check.
First of all, confirm that it’s really “stuck” , on databases with large volumes of patient data, the UUID process can take an extraordinarily long time to finish, as in 48+ hours. (The last V5->V7 I did involved over 100K patients and the UUID population phase alone ran for over 41 hours) It might be wise to either disable the wait timeouts on your database back end, or set them to the maximum available value, at least during the version upgrade process.
If the UUID population phase is actually stopping, sometimes it just needs to be restarted a few times for it to finish all the tables it has to work through.
If restarting it doesn’t bring any additional progress, then you need to find out which table(s) it’s getting hung up in. Check the health of the table(s), look for any anomalies, duplicate or bad data rows, etc.
Examine your SQL error logs, if error logging isn’t enabled, then do so, and check the output during the version upgrade.
You didn’t state how large the database was, but if you’re dealing with a significant number of patients/visits, then make sure that your database back end is configured to utilize as much physical resources as possible (RAM, CPU cores/cycles, InnoDB performance settings, etc). Many systems are artificially throttled either by virtualization performance caps, or because they’re using a default set of SQL server variables that limit their ability to do serious work.