Community Tip - Learn all about PTC Community Badges. Engage with PTC and see how many you can earn! X
Hi,
I'm trying to install Thingworx 8.1 for the first time on an azure virtual server. Installed programs:
jdk-8u152-windows-x64
apache-tomcat-8.5.23
postgresql-9.5.3-1-windows-x64
platform settings.json file:
{
"PersistenceProviderPackageConfigs": {
"PostgresPersistenceProviderPackage": {
"ConnectionInformation": {
"jdbcUrl": "jdbc:postgresql://localhost:5432/thingworx",
"password": "admin",
"username": "twadmin"
}
}
}
"PlatformSettingsConfig": {
"LicensingConnectionSettings": {
"username":"xxx",
"password":"xxx",
"activationIds":"xxx,xxx,xxx,xxx"
}
}
}
Thingworx.war is deployed on Tomcat but white start page shows up. Application log is below. Is it a license issue?
2017-11-17 14:02:56.636+0300 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] ========================================
2017-11-17 14:02:56.636+0300 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] ThingWorx Version Information
2017-11-17 14:02:56.636+0300 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] ========================================
2017-11-17 14:02:56.636+0300 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] majorVersion = 8
2017-11-17 14:02:56.636+0300 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] minorVersion = 1
2017-11-17 14:02:56.636+0300 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] revision = 1
2017-11-17 14:02:56.636+0300 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] build = b108
2017-11-17 14:02:56.637+0300 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] schemaVersion = 1010
2017-11-17 14:02:56.637+0300 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] ========================================
2017-11-17 14:02:56.637+0300 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] ========================================
2017-11-17 14:02:56.637+0300 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] ThingWorx System Environment Settings
2017-11-17 14:02:56.637+0300 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] ========================================
2017-11-17 14:02:56.637+0300 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] OS: Windows Server 2012 R2
2017-11-17 14:02:56.644+0300 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] OS arch: amd64
2017-11-17 14:02:56.644+0300 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] OS version: 6.3
2017-11-17 14:02:56.644+0300 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] Total Processors: 2
2017-11-17 14:02:56.644+0300 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] Default encoding: UTF-8
2017-11-17 14:02:56.644+0300 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] JAVA vendor: Oracle Corporation
2017-11-17 14:02:56.644+0300 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] JAVA version: 1.8.0_152
2017-11-17 14:02:56.644+0300 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] JAVA install location: C:\Program Files\Java\jre1.8.0_152
2017-11-17 14:02:56.644+0300 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] JVM Max Memory: 896 (MB)
2017-11-17 14:02:56.644+0300 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] ========================================
2017-11-17 14:02:56.644+0300 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] WebApp starting...
2017-11-17 14:02:57.340+0300 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] HA mode not enabled. Initializing and starting in standalone mode.
2017-11-17 14:02:57.341+0300 [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] Default Persistence Provider Name = ThingworxPersistenceProvider
2017-11-17 14:02:57.341+0300 [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] Default Persistence Provider Package Name = PostgresPersistenceProviderPackage
2017-11-17 14:02:57.360+0300 [L: INFO] [O: c.t.p.p.PostgresDatasource] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] Reading configuration from configTableCol
2017-11-17 14:02:57.845+0300 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] Managers...INITIALIZED
2017-11-17 14:02:57.854+0300 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] Database initialization started...
2017-11-17 14:03:28.194+0300 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->2rvxtw9r1jy6n7n14beyk7|352def2a]-HelperThread-#4] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@74f41c4c -- 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-11-17 14:03:28.194+0300 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->2rvxtw9r1jy6n7n14beyk7|352def2a]-HelperThread-#4] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@37c71f12 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2017-11-17 14:03:28.204+0300 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->2rvxtw9r1jy6n7n14beyk7|352def2a]-HelperThread-#2] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@11f7c528 -- 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-11-17 14:03:28.204+0300 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->2rvxtw9r1jy6n7n14beyk7|352def2a]-HelperThread-#2] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@37c71f12 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2017-11-17 14:03:28.204+0300 [L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] [message: Connections could not be acquired from the underlying database!]
2017-11-17 14:03:28.214+0300 [L: INFO] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] Connection ThingworxPersistenceProvider, type PostgresPersistenceProviderPackage stopped
2017-11-17 14:03:28.214+0300 [L: WARN] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] Could not find persistenceProviderPackage PostgresPersistenceProviderPackage and thus could not stop data processing
2017-11-17 14:03:28.214+0300 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] [message: Unable to initialize and start system: Connections could not be acquired from the underlying database!]
2017-11-17 14:03:28.214+0300 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-80-exec-28] *** Web Application STATE is being set to ERROR! ***
2017-11-17 14:03:28.244+0300 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->2rvxtw9r1jy6n7n14beyk7|352def2a]-HelperThread-#4] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@62144f2c -- 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-11-17 14:03:28.244+0300 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->2rvxtw9r1jy6n7n14beyk7|352def2a]-HelperThread-#4] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@37c71f12 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2017-11-17 14:04:51.628+0300 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-38] Could not handle request
Solved! Go to Solution.
Hi,
I ran your platform-settings.json in a JSON Validator and found a missing comma. You database will not be able to make a connection to the Thingworx Application if the platform-settings.json is invalid.
Use this format and let us know.
{
"PersistenceProviderPackageConfigs": {
"PostgresPersistenceProviderPackage": {
"ConnectionInformation": {
"jdbcUrl": "jdbc:postgresql://localhost:5432/thingworx",
"password": "admin",
"username": "twadmin"
}
}
},
"PlatformSettingsConfig": {
"LicensingConnectionSettings": {
"username": "xxx",
"password": "xxx",
"activationIds": "xxx,xxx,xxx,xxx"
}
}
}
Hi,
I ran your platform-settings.json in a JSON Validator and found a missing comma. You database will not be able to make a connection to the Thingworx Application if the platform-settings.json is invalid.
Use this format and let us know.
{
"PersistenceProviderPackageConfigs": {
"PostgresPersistenceProviderPackage": {
"ConnectionInformation": {
"jdbcUrl": "jdbc:postgresql://localhost:5432/thingworx",
"password": "admin",
"username": "twadmin"
}
}
},
"PlatformSettingsConfig": {
"LicensingConnectionSettings": {
"username": "xxx",
"password": "xxx",
"activationIds": "xxx,xxx,xxx,xxx"
}
}
}
Also , Postgres 9.5 is not supported at this time. Please downgrade to PostgreSQL 9.4
System Requirements Thingworx 8.1 - http://support.ptc.com/WCMS/files/173583/en/ThingWorx_Core_8.1_System_Requirements_1.0.pdf
Thanks Janet,
I've lost hours because of a missing comma!
By the way, I kept using Postgre 9.5 and there seems no problem yet.