ThingWorx 8.1 Installation
I'm currently attempting to install ThingWorx 8.1 on a remote server and have come across an issue. Typing in localhost:8080/Thingworx/Home throws a Status 401 Error. Consulting the ApplicationLog I get this:
2017-10-04 11:31:10.401-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: Thread-15] WebApp stopping:
2017-10-04 11:31:10.402-0400 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: Thread-15] ThingWorx Web Application STATE is in ERROR, so normal shutdown logic may fail!
2017-10-04 11:31:10.402-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: Thread-15] ========================================
2017-10-04 11:31:10.412-0400 [L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: Thread-15] Error Attempting To Stop Scheduler: null
2017-10-04 11:31:10.412-0400 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: Thread-15] ========================================
2017-10-04 11:31:10.414-0400 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: Thread-15] Stopping Platform Subsystems
2017-10-04 11:31:10.414-0400 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: Thread-15] ========================================
2017-10-04 11:31:10.465-0400 [L: WARN] [O: c.t.p.p.StreamEntryProcessor] [I: ] [U: SuperUser] [S: ] [T: Thread-15] Clearing Stream Queue - 0 Entries Will Be Discarded
2017-10-04 11:31:10.467-0400 [L: INFO] [O: c.t.p.p.StreamEntryProcessor] [I: ] [U: SuperUser] [S: ] [T: Thread-15] Shutting Down Stream Queue...
2017-10-04 11:31:10.468-0400 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: Thread-15] Error getting ApplicationContext: {}null
2017-10-04 11:31:42.301-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] ========================================
2017-10-04 11:31:42.302-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] ThingWorx Version Information
2017-10-04 11:31:42.303-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] ========================================
2017-10-04 11:31:42.303-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] majorVersion = 8
2017-10-04 11:31:42.303-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] minorVersion = 1
2017-10-04 11:31:42.304-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] revision = 0
2017-10-04 11:31:42.304-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] build = b52
2017-10-04 11:31:42.306-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] schemaVersion = 1010
2017-10-04 11:31:42.307-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] ========================================
2017-10-04 11:31:42.308-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] ========================================
2017-10-04 11:31:42.308-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] ThingWorx System Environment Settings
2017-10-04 11:31:42.309-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] ========================================
2017-10-04 11:31:42.311-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] OS: Windows Server 2012 R2
2017-10-04 11:31:42.311-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] OS arch: amd64
2017-10-04 11:31:42.311-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] OS version: 6.3
2017-10-04 11:31:42.319-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] Total Processors: 2
2017-10-04 11:31:42.324-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] Default encoding: UTF-8
2017-10-04 11:31:42.324-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] JAVA vendor: Oracle Corporation
2017-10-04 11:31:42.327-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] JAVA version: 1.8.0_144
2017-10-04 11:31:42.327-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] JAVA install location: C:\Program Files\Java\jre1.8.0_144
2017-10-04 11:31:42.327-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] JVM Max Memory: 2560 (MB)
2017-10-04 11:31:42.328-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] ========================================
2017-10-04 11:31:42.337-0400 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] WebApp starting...
2017-10-04 11:31:43.081-0400 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: main] HA mode not enabled. Initializing and starting in standalone mode.
2017-10-04 11:31:43.081-0400 [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [T: main] Default Persistence Provider Name = ThingworxPersistenceProvider
2017-10-04 11:31:43.083-0400 [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [T: main] Default Persistence Provider Package Name = MssqlPersistenceProviderPackage
2017-10-04 11:31:43.124-0400 [L: INFO] [O: c.t.p.m.MssqlDatasource] [I: ] [U: SuperUser] [S: ] [T: main] Reading configuration from configTableCol
2017-10-04 11:31:43.638-0400 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: main] Managers...INITIALIZED
2017-10-04 11:31:43.642-0400 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: main] Database initialization started...
2017-10-04 11:32:13.793-0400 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->p307ep9q1sdiuky13w9i6u|65e30b24]-HelperThread-#3] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@4abb0bf5 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (3). Last acquisition attempt exception:
2017-10-04 11:32:13.798-0400 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->p307ep9q1sdiuky13w9i6u|65e30b24]-HelperThread-#3] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@b2ef2f4 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2017-10-04 11:32:13.797-0400 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->p307ep9q1sdiuky13w9i6u|65e30b24]-HelperThread-#5] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@1faadec0 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (3). Last acquisition attempt exception:
2017-10-04 11:32:13.798-0400 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->p307ep9q1sdiuky13w9i6u|65e30b24]-HelperThread-#5] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@b2ef2f4 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2017-10-04 11:32:13.796-0400 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->p307ep9q1sdiuky13w9i6u|65e30b24]-HelperThread-#1] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@eac7c34 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (3). Last acquisition attempt exception:
2017-10-04 11:32:13.799-0400 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->p307ep9q1sdiuky13w9i6u|65e30b24]-HelperThread-#1] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@b2ef2f4 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2017-10-04 11:32:13.796-0400 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->p307ep9q1sdiuky13w9i6u|65e30b24]-HelperThread-#2] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@29f70c05 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (3). Last acquisition attempt exception:
2017-10-04 11:32:13.801-0400 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->p307ep9q1sdiuky13w9i6u|65e30b24]-HelperThread-#2] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@b2ef2f4 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2017-10-04 11:32:13.796-0400 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->p307ep9q1sdiuky13w9i6u|65e30b24]-HelperThread-#7] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@69012a70 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (3). Last acquisition attempt exception:
2017-10-04 11:32:13.805-0400 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->p307ep9q1sdiuky13w9i6u|65e30b24]-HelperThread-#7] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@b2ef2f4 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2017-10-04 11:32:13.812-0400 [L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: main] [message: Connections could not be acquired from the underlying database!]
2017-10-04 11:32:13.828-0400 [L: INFO] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [T: main] Connection ThingworxPersistenceProvider, type MssqlPersistenceProviderPackage stopped
2017-10-04 11:32:13.828-0400 [L: WARN] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [T: main] Could not find persistenceProviderPackage MssqlPersistenceProviderPackage and thus could not stop data processing
2017-10-04 11:32:13.843-0400 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] [message: Unable to initialize and start system: Connections could not be acquired from the underlying database!]
2017-10-04 11:32:13.844-0400 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] *** Web Application STATE is being set to ERROR! ***
To my knowledge this is a db connectivity issue. I followed the MS SQL installation guide and created an twadmin account and in the platform-settings.json file I have this:
{
"PersistenceProviderPackageConfigs": {
"MssqlPersistenceProviderPackage": {
"ConnectionInformation": {
"driverClass": "com.microsoft.sqlserver.jdbc.SQLServerDriver",
"jdbcUrl": "jdbc:sqlserver://localhost:1433;databaseName=thingworx;applicationName=Thingworx;",
"password": ".....",
"username": "twadmin"
}
}
}
I can successfully login as twadmin with my password in sql server. Also, I have run the 2 scripts in order to set up the db and can visually see they ran. Additionally, I've allowed access to the ThingworxPlatform, ThingworxStorage, and ThingworxBackupStorage folders by using the Everyone access control group.
My hunch is possibly because i'm using Tomcat 9? I have included my Tomcat properties.

Java 9 was originally installed on the server but realizing it's not compatible with Thingworx I had 1.8 installed. I made sure to path the JVM to the 1.8 installation as well. Could having 2 versions of java be affecting the db connection? Lastly, I made sure to download the jdbc driver for 1.8 and install it in the Tomcats lib folder.

Thanks for any help!

