Skip to main content
1-Visitor
August 5, 2019
Question

Not able to start Thingworx8.4.1 with H2persistence provider

  • August 5, 2019
  • 1 reply
  • 3409 views

Hi Sharon,

 

I'm having the same problem trying to get TW 8.4 running.

 

I copy/pasted a platform-settings.json I found from here and I have validated it as well. (see attached)

 

From Application.log:

2019-08-05 16:26:30.670-0400 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] [message: Connections could not be acquired from the underlying database!]
2019-08-05 16:26:30.671-0400 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] *** Web Application STATE is being set to ERROR! ***

 

From catalina.out

Caused by: org.h2.jdbc.JdbcSQLException: Wrong user name or password [28000-195]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.engine.Engine.validateUserAndPassword(Engine.java:336)

...

 

 

Also, I am getting a 503 Error when I try to load https://localhost:443/Thingworx

 

Not really sure what is going on, any help would be appreciated!

 

 

edit: using java 1.8.0_131 on Ubuntu 18.04.2

 

1 reply

16-Pearl
August 6, 2019

Assuming you have not removed password in order to post the config file here, could you please set a valid password against the key password under H2PersistenceProviderPackage and test? If this is not a fresh installation, please back up your data before making this change. 

clansdale1-VisitorAuthor
1-Visitor
August 6, 2019

Thank you for the reply, I have a real password in the H2PersistenceProviderPackage but I am still getting a 503 error. I have attached the updated platform-settings.json

 

Edit:

These are the two errors I can't seem to shake, unsure if it is a java problem or a H2 problem.

 

 

Caused by: org.h2.jdbc.JdbcSQLException: Wrong user name or password [28000-192]

 

java.sql.SQLException: Connections could not be acquired from the underlying database!

 

 

16-Pearl
August 6, 2019

How about file permissions?  Is tomcat user the owner of /ThingworxStorage /ThingworxBackupStorage and /ThingworxPlatform. Also, do the folders have 775 permission setting?