Article - CS285545
ThingWorx Platform backed by Microsoft SQL Server fails to start
Modified: 30-Oct-2020
Applies To
- ThingWorx Platform 8.1 to 9.1
- Apache Tomcat
- Microsoft SQL Sever
- Microsoft Windows
Description
- ThingWorx Platform using database on Microsoft SQL Server fails to start
- Error message in <ThingworxStorage>\logs\ApplicationLog.log file:
- com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@<id> -- 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).
Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@<id> is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
[L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: ] [S: ] [T: localhost-startStop-1] [message: Connections could not be acquired from the underlying database!]
[L: INFO] [O: c.t.p.p.PersistenceProvider] [I: ] [U: ] [S: ] [T: localhost-startStop-1] Connection ThingworxPersistenceProvider, type MssqlPersistenceProviderPackage stopped
- com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@<id> -- 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).
- Using SQL Server Management Studio (SSMS) with Server Authentication, FQDN server, login name and password results in message:
- Login Failed for User (Microsoft SQL Server, Error: 18456)
,
This is a printer-friendly version of Article 285545 and may be out of date. For the latest version click CS285545