Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X
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
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.
My thingworx worked well but suddenly went to wrong. So I don't think the problem is in platform-settings.json.
I have already known what the problem is, the postgresql database account was expired so I can't login actually.