Hi. We're still in the middle of the (long) process of moving from 2020.06 to 2023.03 LTS. We're updating our virtual servers (DEV, UAT and production) environments at the same time, to accommodate the requirements of this Servoy upgrade (Java 11 to Java 17) and to also move forward our operating systems, tomcat (8.5 to 9) and MySQL versions.
Our DEV environment move is complete and seems to be working well. Initially deployed a 2020.06 .war file for our application and that worked. Then, after some trouble exporting a .war file in 2023.03 LTS, we successfully exported and deployed it in DEV.
Next, on to our UAT environment. New virtual server built with all the software upgrades. Deployed the 2020.06 .war file and the application worked well. Now, the 2023.03 LTS .war file won't deploy.
I've checked out https://wiki.servoy.com/display/DOCS/Tr ... esn'tStart and the only cause that stands out might be:
Invalid configuration of the database server connection named 'repository_server' in Servoy
I say this, because we initially get this error:
2024-01-09 16:45:12,098 WARN [ServoyServerScheduler-1-thread-2] servoy.DBIProvider - server dbi file '/WEB-INF/db/repository_server.dbi' not found
However, after comparing the UAT problems to the DEV environment, I see that same warning message there, and the application works fine in DEV. Plus, the repository_server is configured like this:
server.1.URL=jdbc\:hsqldb\:mem\:repository_server
Maybe we don't need the repository_server.dbi file anyways?
So, on to the next log messages (trimmed here, but fully included in attached file):
2024-01-09 16:45:12,403 ERROR [ServoyServerScheduler-1-thread-2] persistence.Server - Final get connection failure for server qfi in 1 times [ ]
2024-01-09 16:45:13,189 ERROR [main] com.servoy.j2db.util.Debug - Server 'qfi' does not exist. Import failed. [ ]
2024-01-09 16:45:13,922 ERROR [main] com.servoy.j2db.util.Debug - Could not load solutions [ ]
com.servoy.j2db.persistence.RepositoryException: Cannot find database server "qfi", import failed.
2024-01-09 16:45:13,943 ERROR [main] com.servoy.j2db.util.Debug - Servoy Application server context /qfi didn't start up correctly, very likely because of an import problem [ ]
com.servoy.j2db.persistence.RepositoryException: Cannot find database server "qfi", import failed.
2024-01-09 16:45:13,944 ERROR [main] com.servoy.j2db.util.Debug - Can't start the application server [ ]
javax.servlet.ServletException: Can't start the application server
Going back to the possible causes in the troubleshooting page, the MySQL instance is running on the same virtual server and is confirmed to be running. The database 'qfi' is certainly available to be found. I don't see the JDBC connection being an issue, as it is unchanged from our 2020.06 version of the application (which worked in UAT), and it's working in DEV for the 2023.03 LTS version of the application.
I've attached relevant log file snippets from catalina.out, localhost.log and our application log (named servoy.log) in a single file.
Any help, as always, is much appreciated.