Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
I am not able to connect to thingworx server. And i seen these errors in application log of TWX and tomcat logs as well.
2021-08-24 15:40:30.229+0530 [L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: main] [message: Connections could not be acquired from the underlying database!]
2021-08-24 15:40:30.255+0530 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] [message: Unable to initialize and start system: Connections could not be acquired from the underlying database!]
2021-08-24 15:40:30.255+0530 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] *** CRITICAL ERROR ON STARTUP: Unable to initialize and start system: Connections could not be acquired from the underlying database!
2021-08-24 15:40:30.255+0530 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: main] *** Web Application STATE is being set to ERROR! ***
2021-08-24 15:40:30.195+0530 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->1hge10wajx70yzk1uf99cz|1086e2f7]-HelperThread-#5] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@79980f7c -- 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:
2021-08-24 15:40:30.207+0530 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->1hge10wajx70yzk1uf99cz|1086e2f7]-HelperThread-#6] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@1c850bdd is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
Solved! Go to Solution.
Hi @AP_9587236
This article https://www.ptc.com/en/support/article/CS235937 has steps to check the relevant settigns.
Hope this helps
Christophe