Home › Forums › Users › General User's Discussion ›

Problem when upgrading from 2.1.2 to 2.3.0.11

Submitted by activet on Mon, 17/04/2023 - 18:49
in

Hi all,

Could anyone offer advice please as I encountered a problem when upgrading from 2.1.2 to 2.3.0.11?

I was able to get to the login screen but after entering login name and password, it displayed HTTP Status 500 - Filter execution threw an exception:

javax.servlet.ServletException: Filter execution threw an exception

 

Before this, I've followed the Upgrade An Existing System Guide.

I created the openvpms.properties config file by using the toolbox config command.

I downloaded a newer mysql connector file (mysql-connector-j-8.0.32.jar) and put it in both the lib folder of the new openvpms home and Tomcat directories before I could run the toolbox database --update command. Our previous connector file was mysql-connector-java-5.1.40-bin.jar

I had to upgrade Java 8 from update 121 to 202 in order to support strong password protection. I've updated the Tomcat Java Config to point to the new Java installation directory.

I've run the toolbox war command and removed the existing web application before installing the new version as usual.

We were running Tomcat 7.0.73 and MySQL 5.5.53 with OpenVPMS 2.1.2

Do I need to upgrade Tomcat to a newer version in order to run OpenVPMS 2.3.0.11?

 

P.S. I tried the upgrade on a backup system as a test run for practice before doing the live database, so our main server running 2.1.2 is still ok.

 

Regards,

Anthony

‹ Concept: Dynamic Report Buttons Problem when upgrading from 2.1.2 to 2.3.0.11 ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Problem when upgrading from 2.1.2 to 2.3.0.11

Submitted by tanderson on Mon, 17/04/2023 - 18:56.

You'll need to upgrade to Tomcat 8, as per https://www.openvpms.org/documentation/csh/2.3/topics/installing-openvpm...

MySQL 5.7 is preferred over MySQL 5.5, as MySQL 5.5 has reached end-of-life.

Other than that, its not possible to determine the cause of the error without seeing the logs. If you send them to me at tanderson at openvpms.org I can diagnose further.

Re: Problem when upgrading from 2.1.2 to 2.3.0.11

Submitted by activet on Tue, 18/04/2023 - 01:09.

Hi Tim,

Thank you for your reply and advice! It was my bad, I read the upgrade notes but not the 2.3 requirement page initially. I've uninstalled Tomcat 7 and installed Tomcat 8. OpenVPMS version 2.3.0.11 is now running as intended on my backup machine. I'll go ahead to upgrade our server machine this weekend :)

Thank you!

Kind regards,

Anthony (ActiVet)

Re: Problem when upgrading from 2.1.2 to 2.3.0.11

Submitted by tanderson on Tue, 18/04/2023 - 01:13.

Make sure you disable email, jobs and plugins when you run on a backup machine, to avoid impacting the production environment.

Re: Problem when upgrading from 2.1.2 to 2.3.0.11

Submitted by activet on Thu, 20/04/2023 - 18:03.

Yes, definitely Tim! Our backup machine is not currently connected onto our network.

Kind regards,

Anthony (ActiVet)

Syndicate content