cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X

Thingworx database connection trouble

nxiao
5-Regular Member

Thingworx database connection trouble

I can't start thingworx which return 503 error. But the tomcat works.

 

thingworx application log:

2019-09-03 10:07:28.968+0800 [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Default Persistence Provider Package Name = PostgresPersistenceProviderPackage
2019-09-03 10:07:28.982+0800 [L: INFO] [O: c.t.p.p.PostgresDatasource] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Reading configuration from configTableCol
2019-09-03 10:07:29.311+0800 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Managers...INITIALIZED
2019-09-03 10:07:29.315+0800 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Database initialization started...
2019-09-03 10:07:59.782+0800 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->2rwcn5a41vy09sjfb4gy5|5e7a8bf1]-HelperThread-#0] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@39d3415d -- 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:
2019-09-03 10:07:59.782+0800 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->2rwcn5a41vy09sjfb4gy5|5e7a8bf1]-HelperThread-#1] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@fc6f968 -- 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:

 

thingworx security log:

2019-09-03 10:07:59.815+0800 [L: INFO] [O: S.c.t.s.a.s.SSOContext] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] SSOContext created...
2019-09-03 10:07:59.891+0800 [L: ERROR] [O: S.c.t.s.a.AuthenticationFilter] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Could not load session timeout from database, using default: null

 

3 REPLIES 3

The most common cause for such an error is a typo or syntax error in platform-settings.json. Also, ensure that the Postgres credentials stored in platform-settings.json are correct. Other causes and their resolutions can be found in this article

nxiao
5-Regular Member
(To:rjanardan)

My thingworx worked well but suddenly went to wrong. So I don't think the problem is in platform-settings.json.

nxiao
5-Regular Member
(To:rjanardan)

I have already known what the problem is, the postgresql database account was expired so I can't login actually.

Top Tags