AzureSQL Thingworx Connectivity - CRITICAL ERROR ON STARTUP
Hi,
I am trying to connect an Azure SQL Managed Instance database to ThingWorx. I can connect the db using the creds from platform-settings.json in SQL Server Management Studio(SSMS)., but when I try to communicate through Thingworx, I get the following error:
2025-07-22 00:07:54.104-0700 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [P: ] [T: C3P0PooledConnectionPoolManager[identityToken->2x11jfbcdl16egl4oi68|5dde2be7]-HelperThread-#4] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@48f7f91b -- 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:
2025-07-22 00:07:54.104-0700 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [P: ] [T: C3P0PooledConnectionPoolManager[identityToken->2x11jfbcdl16egl4oi68|5dde2be7]-HelperThread-#7] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@3792a8c8 -- 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:
2025-07-22 00:07:54.104-0700 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [P: ] [T: C3P0PooledConnectionPoolManager[identityToken->2x11jfbcdl16egl4oi68|5dde2be7]-HelperThread-#3] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@49120f7d -- 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:
2025-07-22 00:07:54.104-0700 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [P: ] [T: C3P0PooledConnectionPoolManager[identityToken->2x11jfbcdl16egl4oi68|5dde2be7]-HelperThread-#1] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@75a08dcf -- 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:
2025-07-22 00:07:54.104-0700 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [P: ] [T: C3P0PooledConnectionPoolManager[identityToken->2x11jfbcdl16egl4oi68|5dde2be7]-HelperThread-#0] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@59579a88 -- 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:
2025-07-22 00:07:54.107-0700 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [P: ] [T: C3P0PooledConnectionPoolManager[identityToken->2x11jfbcdl16egl4oi68|5dde2be7]-HelperThread-#7] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@fe86afe is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2025-07-22 00:07:54.108-0700 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [P: ] [T: C3P0PooledConnectionPoolManager[identityToken->2x11jfbcdl16egl4oi68|5dde2be7]-HelperThread-#0] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@fe86afe is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2025-07-22 00:07:54.108-0700 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [P: ] [T: C3P0PooledConnectionPoolManager[identityToken->2x11jfbcdl16egl4oi68|5dde2be7]-HelperThread-#1] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@fe86afe is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2025-07-22 00:07:54.108-0700 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [P: ] [T: C3P0PooledConnectionPoolManager[identityToken->2x11jfbcdl16egl4oi68|5dde2be7]-HelperThread-#3] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@fe86afe is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2025-07-22 00:07:54.108-0700 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [P: ] [T: C3P0PooledConnectionPoolManager[identityToken->2x11jfbcdl16egl4oi68|5dde2be7]-HelperThread-#4] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@fe86afe is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
2025-07-22 00:07:54.110-0700 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] *** CRITICAL ERROR ON STARTUP: Connections could not be acquired from the underlying database!
This is how platform-settings.json looks:

The Thingworx Version of the Upgrade is 10.0
Thanks,

