Solved: Re: Thingworx 8.1 Installation - white page issue

oaslan · ‎Nov 17, 2017

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] 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

jdass · ‎Nov 17, 2017

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"

}

View solution in original post

jdass · ‎Nov 17, 2017

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"

}

jdass · ‎Nov 17, 2017

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

oaslan · ‎Nov 17, 2017

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.