Home Forums Discussions Problems Upgrade problem, stuck

I crept in early Saturday to upgrade us from 6.0.10 to 6.1.2.

I ran the 6.1.2 installer on the main machine. Starting AC on the main machine says I need to run the database tuner. Running the database tuner says "Your medications database is out of date. Please run the latest AmazingChartsInstaller on your main computer."

So I rebooted. Same thing: medications database is out of date, please run installer.

So I ran the installer again: given the choice between "repair" and "remove" I chose repair.

This time run AC does not ask to run the tuner, gives errors about missing codes.mdf and has does not start.

So I figure tuner still must be run. Eventually find the web page (since it's no longer opening automatically for me) and run. The Tuner says "Cannot open database "AmazingCharts" requested by the login. The login failed. Login failed for user 'sa'.

So I reboot again.

Run the tuner: new error "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or is not accessible..."

I called AC support and left a message but thought I would post here as well in case someone has run into a similar problem. Thanks.

I ran the installer a 3rd time and am back to it just saying "your medication database is out of date". That is the Tuner won't run for me. So I'm still stuck but no SQL Server errors at the moment.

Then I did a complete uninstall of 6.1.2, reboot, then reinstall of 6.1.2. Same error when running the tuner: medication database is out of date.

AC Support (Johnny) fixed this for us. There is a special DatabaseTunerV612.exe you need to run. The installation dumps you onto the website to download and run the tuner, and it is not clear to me that the V612 tuner is there, certainly I didn't find it and so I was running the wrong tuner. Johnny transfererred it directly to our main machine. So this seems like a pretty big installation flaw with V6.1.2 self-install, but I am happy we are up and running.

This has always been a flaw in any BETA UPDATE as it takes you to the main AC page and does not always take you to the correct database tuner. It is important when you download an update you need to download the tuner at the same time and do not use the one on AC page ..... I know this is dumb and hopefully that will be fixed sometime.

This is why, even though users had good reasons not to put the database installer in the install package, that is where it needs to be. Their reasoning was you only need it on the main computer. Well, the installer is smart enough to know if there is a database on a client computer. When you click the button stating this is NOT your computer with the database, the tuner doesn't run, etc.

The separate database tuner is a major flaw to the deployment of the AC installation. It's been this way ever since they moved from MSAccess to MS SQL. It was a good move to SQL, however this methodology of install is (as you learned) NOT intuitive at all. And all upgrades must use their own version of database tuner. Sounds like your lesson was learned the hard way. Keep this in mind w/ future upgrades.

Hopefully in the future, AC developers make this upgrade and installation process like most other programs (without separately self-tuning the database).

Sometimes companies teeter on the brink between self-installs and just requiring remote-hands support people to do all installations. This is too bad becuase surely it's expensive to have support people do all that work for every customer. But it's sort of a feedback thing -- the install process gets complex so support more often takes over -- which means the install proces can get more complex because support is doing it anyway.