Not able to Load Thingworx Composer 8.3

TanmeyTWX · ‎May 14, 2019

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!

mnarang · ‎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

TanmeyTWX · ‎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.

mnarang · ‎May 15, 2019

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

TanmeyTWX · ‎May 15, 2019

Screenshot of tables attached

mnarang · ‎May 15, 2019

Thanks fro the screenshot .I actually wanted to see the DB and schema .I am assuming that the tables are under public schema only under thingworx DB. Sometimes while running the DB scripts people give a schema name for DB as well .

Also where is your postgresql installed? The platform and DB both are on localhost only ?

Thanks ,

Mukul Narang

TanmeyTWX · ‎May 15, 2019

Yes both Postgres and TWx are on localhost.

platform-settings.json:

{
"PlatformSettingsConfig": {
"AdministratorUserSettings": {
"InitialPassword": "password"
}
},
"PersistenceProviderPackageConfigs": {
"PostgresPersistenceProviderPackage": {
"ConnectionInformation": {
"jdbcUrl": "jdbc:postgresql://localhost:5432/thingworx",
"password": "password",
"username": "twadmin",
"maxPoolSize": 1000
}
}
}
}

PostgresSQL logs:

Connection matched pg_hba.conf line 80: "host all all 127.0.0.1/32 md5"
2019-05-15 16:10:15.652 IST [4240] FATAL: password authentication failed for user "twadmin"
2019-05-15 16:10:15.652 IST [4240] DETAIL: Password does not match for user "twadmin".
Connection matched pg_hba.conf line 80: "host all all 127.0.0.1/32 md5"
2019-05-15 16:10:15.664 IST [8776] FATAL: password authentication failed for user "twadmin"
2019-05-15 16:10:15.664 IST [8776] DETAIL: Password does not match for user "twadmin".
Connection matched pg_hba.conf line 80: "host all all 127.0.0.1/32 md5"

TanmeyTWX · ‎May 20, 2019

Any sync-up on it?

slangley · ‎May 20, 2019

Hi @TanmeyTWX.

Was this java library path statement added to the Java options for Tomcat? It would be a path similar to this:

-Djava.library.path=C:\Program Files\Tomcat 8.5\webapps\Thingworx\WEB-INF\extensions

Here's a screenshot:

Regards.

--Sharon

TanmeyTWX · ‎May 21, 2019

Yes. Added this path.

slangley · ‎May 21, 2019

Hi @TNTWX.

It would probably work best for us to open a case for this issue. We could then schedule a WebEx for reviewing your configuration.

If you are in agreement with this suggestion, please drop me a private email with the name of your corporate account, SCN, and your corporate email address and I will open one on your behalf.

If opening a case does not work for you, we would need to review a new set of ThingWorx and Tomcat logs, as well as the platform-settings.json file located in \ThingworxPlatform. What version of Tomcat are you running?

Regards.

--Sharon