Hello !
I have some troubles upgrading Thingworx 9.1 to 9.2.4 (both with an H2 db)
My Tomcat server works when Webapps is empty, but whenever I restart it with the Thingworx.war in Webapps, it crashes, returning me this log in ErrorLog.log :
2022-10-11 08:15:44.725+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Error in copying permissions: A problem occurred while trying to acquire a cached PreparedStatement in a background thread.
2022-10-11 08:15:44.727+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Error encountered while executing migrator
2022-10-11 08:15:44.727+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] java.sql.SQLException: A problem occurred while trying to acquire a cached PreparedStatement in a background thread.
2022-10-11 08:15:44.727+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] An error was encountered while executing task [Copy Permissions to new tables]. See logs for further details.
2022-10-11 08:15:44.727+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Task [Copy Permissions to new tables] failed on migrator [Permissions Migrator V9.2.0]. Error message is: Exception occurred on migrator execution
2022-10-11 08:15:44.727+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Exception occurred on migrator execution
2022-10-11 08:15:44.728+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Problems migrating database
2022-10-11 08:15:44.728+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Exception occurred on migrator execution
2022-10-11 08:15:44.738+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Could not create a transaction for ThingworxPersistenceProvider
2022-10-11 08:15:44.738+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Could not create a transaction for ThingworxPersistenceProvider
2022-10-11 08:15:44.747+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] *** CRITICAL ERROR ON STARTUP: Unable to initialize and start system: Could not create a transaction for ThingworxPersistenceProvider
2022-10-11 08:15:44.747+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] *** Web Application STATE is being set to ERROR! ***
I can't understand what's making it crash (Well, I know it's DB related but that's all)
I want to keep H2 as my DB
Thank You in advance
