Installing Thingworx 7.3, windows7 - problem

[wlihua]

when I am trying to install TWX 7.3 with postgreSQL9.4 DB on separate server. Currently I am not able to start Thingworx from totally unknown problem.

Any ideas what can be wrong?

ApplicationLog.log:

00 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-8080-exec-3] WebApp starting...

2017-01-19 11:08:40.479+0900 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: http-nio-8080-exec-3] HA mode not enabled. Initializing and starting in standalone mode.

2017-01-19 11:08:40.479+0900 [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [T: http-nio-8080-exec-3] Default Persistence Provider Name = ThingworxPersistenceProvider

2017-01-19 11:08:40.479+0900 [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [T: http-nio-8080-exec-3] Default Persistence Provider Package Name = PostgresPersistenceProviderPackage

2017-01-19 11:08:40.496+0900 [L: INFO] [O: c.t.p.p.PostgresDatasource] [I: ] [U: SuperUser] [S: ] [T: http-nio-8080-exec-3] Reading configuration from configTableCol

2017-01-19 11:08:40.845+0900 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: http-nio-8080-exec-3] Managers...INITIALIZED

2017-01-19 11:08:40.857+0900 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: http-nio-8080-exec-3] Database initialization started...

2017-01-19 11:09:11.804+0900 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->1hgeby99l1e2smgd83b6qj|7f47014d]-HelperThread-#7] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@3d638e4c -- 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-01-19 11:09:11.805+0900 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->1hgeby99l1e2smgd83b6qj|7f47014d]-HelperThread-#7] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@269b1c86 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.

2017-01-19 11:09:11.812+0900 [L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: http-nio-8080-exec-3] [message: Connections could not be acquired from the underlying database!]

2017-01-19 11:09:11.819+0900 [L: INFO] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [T: http-nio-8080-exec-3] Connection ThingworxPersistenceProvider, type PostgresPersistenceProviderPackage stopped

2017-01-19 11:09:11.819+0900 [L: WARN] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [T: http-nio-8080-exec-3] Could not find persistenceProviderPackage PostgresPersistenceProviderPackage and thus could not stop data processing

2017-01-19 11:09:11.824+0900 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-8080-exec-3] [message: Unable to initialize and start system: Connections could not be acquired from the underlying database!]

2017-01-19 11:09:11.824+0900 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: http-nio-8080-exec-3] *** Web Application STATE is being set to ERROR! ***

2017-01-19 11:09:12.162+0900 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->1hgeby99l1e2smgd83b6qj|7f47014d]-HelperThread-#6] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@622c1314 -- 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-01-19 11:09:12.163+0900 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: SuperUser] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->1hgeby99l1e2smgd83b6qj|7f47014d]-HelperThread-#6] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@269b1c86 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.

2017-01-19 11:09:15.616+0900 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-8080-exec-5] Could not handle request

[ttielebein]

Have you verified that your permissions on the ThingworxPostgresqlStorage folder are sufficient?

[posipova · Accepted solution]

Have you taken a look at this document?

https://community.thingworx.com/docs/DOC-3335

1. Are you able to ping the postgresql server from your THingworx server?

2. When you go to pg admin, is the database connected? If it's a windows server, in pg admin right click on your db to see whether it's connected.

3. When you expand the database, can you see how many tables are in the space? Should be around 48-53.

[wlihua]

Hi Polina

Thank you for your comment.

I found that the password(setting.josn) was wrong.

[posipova]

Glad it was resolved. Let us know if you need any further assistance.