Skip to main content
17-Peridot
August 24, 2021
Solved

not able to connect to thingworx server

  • August 24, 2021
  • 1 reply
  • 1806 views

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.

Best answer by AP_9587236
I cleared this error "12:13:21.173 [main] ERROR com.thingworx.system.configuration.PlatformSettings - Configuration setting ContentTypeSettings.supportedMediaEntityContentTypes cannot be null" in logs. Its working now. 
 
So i added this code in platform-settings.json.
"ContentTypeSettings": {
"supportedMediaEntityContentTypes":["image/svg+xml","image/png","image/gif","image/bmp","image/jpeg","application/pdf", "application/json", "image/vnd.microsoft.icon"]
}

1 reply

19-Tanzanite
August 24, 2021

Hi @AP_9587236 

 

This article https://www.ptc.com/en/support/article/CS235937 has steps to check the relevant settigns.

 

Hope this helps

Christophe

 

AP_958723617-PeridotAuthorAnswer
17-Peridot
August 25, 2021
I cleared this error "12:13:21.173 [main] ERROR com.thingworx.system.configuration.PlatformSettings - Configuration setting ContentTypeSettings.supportedMediaEntityContentTypes cannot be null" in logs. Its working now. 
 
So i added this code in platform-settings.json.
"ContentTypeSettings": {
"supportedMediaEntityContentTypes":["image/svg+xml","image/png","image/gif","image/bmp","image/jpeg","application/pdf", "application/json", "image/vnd.microsoft.icon"]
}