Article - CS312127
Unable to connect Azure SQL Database with ThingWorx platfrom
Modified: 21-Aug-2019
Applies To
- ThingWorx Platform 8.4 F000 to 8.5
- JRE
Description
- Unable to start ThingWorx with Azure SQL as persistence provider
- ThingWorx and Azure SQL are installed on different boxes
- Error thrown in Application logs:
C3P0PooledConnectionPoolManager[identityToken->2x11j8a4h31dvqcfo9nu|18759ed]-HelperThread-#6] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@71721588 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2019-07-29 11:52:34.567+0000 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->2x11j8a4h31dvqcfo9nu|18759ed]-HelperThread-#1] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@71721588 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2019-07-29 11:52:34.570+0000 [L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: main] [message: Connections could not be acquired from the underlying database!]
2019-07-29 11:52:34.567+0000 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->2x11j8a4h31dvqcfo9nu|18759ed]-HelperThread-#1] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@71721588 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2019-07-29 11:52:34.570+0000 [L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: main] [message: Connections could not be acquired from the underlying database!]
This is a printer-friendly version of Article 312127 and may be out of date. For the latest version click CS312127