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!

