Skip to main content
17-Peridot
May 14, 2019
Question

Not able to Load Thingworx Composer 8.3

  • May 14, 2019
  • 10 replies
  • 4824 views

Hi Folks,

 

I have installed TWX 8.3 as per the Guide but not able to Load Composer page and getting 401 error as shown below in the attached snapshot.

I have gone through all the similar posts on the community but no luck in my case. I am guessing its related to DB but not sure and thus need your help to fix this.

 

 

Steps done:

1. Apache 8.5 installed

2. JVM checked: C:\Program Files\Java\jre1.8.0_102\bin\server\jvm.dll

3. Java options added: 

-Dserver -Dd64
-XX:+UseG1GC
-Dfile.encoding=UTF-8

 

4. PostgressSQL 9.4 installed

5. Added new login Role "twadmin" with required privileges and put same password as in "platform-settings.json" file.

6. DB setup and Schema scripts executed successfully but got 57 tables shown in the schema.

7. Following folders added.

-ThingworxPlatform (platform-settings.json)

-ThingworxPostgresqlStorage (PG_9.4_201409291)

8. Provided required access to above folders.

9. Updated Enviroment System variables with required paths of above files.

 

-->Tomcat is working perfectly fine.But whenever I try to load thingworx get error. I suspect point number 6 above, with 57 tables and against 58 tables. but I didn't get any error after scripts execution.

 

Below is the application logs from Thingworx Storage folder.

 

2019-05-14 17:39:26.298+0530 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] WebApp starting...
2019-05-14 17:39:27.073+0530 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] HA mode not enabled. Initializing and starting in standalone mode.
2019-05-14 17:39:27.074+0530 [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Default Persistence Provider Name = ThingworxPersistenceProvider
2019-05-14 17:39:27.074+0530 [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Default Persistence Provider Package Name = PostgresPersistenceProviderPackage
2019-05-14 17:39:27.087+0530 [L: INFO] [O: c.t.p.p.PostgresDatasource] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Reading configuration from configTableCol
2019-05-14 17:39:27.392+0530 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Managers...INITIALIZED
2019-05-14 17:39:27.395+0530 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Database initialization started...
2019-05-14 17:39:57.680+0530 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->2sa9mpa21ekf3xraf5ff7|369c4e72]-HelperThread-#1] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@fc19eb3 -- 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:
2019-05-14 17:39:57.681+0530 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->2sa9mpa21ekf3xraf5ff7|369c4e72]-HelperThread-#1] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@443e5bdf is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2019-05-14 17:39:57.685+0530 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->2sa9mpa21ekf3xraf5ff7|369c4e72]-HelperThread-#3] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@558532e3 -- 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:
2019-05-14 17:39:57.685+0530 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->2sa9mpa21ekf3xraf5ff7|369c4e72]-HelperThread-#3] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@443e5bdf is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2019-05-14 17:39:57.686+0530 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->2sa9mpa21ekf3xraf5ff7|369c4e72]-HelperThread-#7] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@7523c42 -- 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:
2019-05-14 17:39:57.686+0530 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->2sa9mpa21ekf3xraf5ff7|369c4e72]-HelperThread-#7] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@443e5bdf is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2019-05-14 17:39:57.686+0530 [L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] [message: Connections could not be acquired from the underlying database!]
2019-05-14 17:39:57.696+0530 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->2sa9mpa21ekf3xraf5ff7|369c4e72]-HelperThread-#2] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@1ea24711 -- 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:
2019-05-14 17:39:57.696+0530 [L: INFO] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Connection ThingworxPersistenceProvider, type PostgresPersistenceProviderPackage stopped
2019-05-14 17:39:57.696+0530 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->2sa9mpa21ekf3xraf5ff7|369c4e72]-HelperThread-#2] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@443e5bdf is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2019-05-14 17:39:57.696+0530 [L: WARN] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Could not find persistenceProviderPackage PostgresPersistenceProviderPackage and thus could not stop data processing
2019-05-14 17:39:57.698+0530 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] [message: Unable to initialize and start system: Connections could not be acquired from the underlying database!]
2019-05-14 17:39:57.698+0530 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] *** Web Application STATE is being set to ERROR! ***
2019-05-14 17:39:57.706+0530 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->2sa9mpa21ekf3xraf5ff7|369c4e72]-HelperThread-#6] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@1d156670 -- 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:
2019-05-14 17:39:57.706+0530 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->2sa9mpa21ekf3xraf5ff7|369c4e72]-HelperThread-#6] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@443e5bdf is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2019-05-14 17:39:58.043+0530 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-8080-exec-1] Could not handle request
2019-05-14 17:40:17.103+0530 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-8080-exec-5] Could not handle request

 

 

Kindly help!

 

Thanks!

10 replies

5-Regular Member
May 14, 2019

Your suspect is correct ,there are 58 tables in 8.3 .Can you also share the screenshot of pgadmin showing the DB/Schema and number of tables ? As it seems the root cause is the connection between DB and application.

 

 

Thanks ,

Mukul Narang

TanmeyTWX17-PeridotAuthor
17-Peridot
May 15, 2019

Hi,

I reinstalled PostgreSQL and now able to see required 58 tables in the schema but Thingworx still not loading  with same error .

Log files attached.

 

 

5-Regular Member
May 15, 2019

Can you please attach screenshot from pgadmin showing no of tables under the DB ?