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!
ACCEPTED SOLUTION
Accepted Solutions
Hey Janet,
Thanks for your response! I was able to uninstall Tomcat 9 and install Tomcat 8.5.23. Unfortunately, I still receive the same error message. Because it states it can't connect to the underlying db I still presume it's a db problem. Included below is my Java section of Tomcat Additionally, I did make sure to copy the jdbc driver into Tomcats lib folder
Because of the recent install of Tomcat, my best guess is that it's a authentication issue with my platform file...
{
"PersistenceProviderPackageConfigs": {
"MssqlPersistenceProviderPackage": {
"LicensingConnectionSettings":{
"username”: ”<my username here>",
"password”: ”<my password here>",
"activationIds":"<my id here>" } "ConnectionInformation":
{
"driverClass": "com.microsoft.sqlserver.jdbc.SQLServerDriver",
"jdbcUrl": "jdbc:sqlserver://localhost:1433;databaseName=thingworx;applicationName=Thingworx;",
"password": "<my password here>",
"username": "twadmin"
}
}
}
}
A note, I can login SQL Server with twadmin and my password.
A reason I think it could be a platform settings issue is because I ran the db scripts twice and can see what the scripts did. Another issue could be maybe db install settings maybe? I am remote connecting to this server and for tomcat installation I used port 8080 instead of 80.
Any help would be amazing as i'm very confused what the issue is.
Thanks again!
That is a common license error.. Almost there ! Did you add -Djava.library.path=<path to Tomcat>\webapps\Thingworx\WEB-INF\extensions to the Tomcat Configuration's Java Options ?
Hey Janet,
Attached is a picture of my path and to my knowledge it's correct.
I think the problem lies in the in FlexNet login/licensing.... If i try and login to my FlexNet Operations even after resetting my password I get hit with a Only users belonging to home organization can log in.
who would be the best to contact about this?
Thanks again
I still get the same error when I try to login to Flexnet.
Can you tell me what are the files present in your ThingworxPlatform folder?
Hey Janet,
I'll include a picture of my ThingworxPlatform folder. There should only be two items in it correct? The keystore-password and platform-settings. I recall in Thingworx 8.0 you need a license.bin file but with 8.1 that isn't necessary, validation occurs via the platform-settings file correct?
Thanks again for your help.
