1-Visitor

Solved

Thingworx 6.6 PostgreSQL connection error

Forum|Forum|10 years ago
December 29, 2015
1 reply
4838 views

Anyone struggled with "Connections could not be acquired from the underlying database!" error after installing postgreSQL and trying to access Thingworx?

Install-Upgrade

Best answer by avladescu

Removed "defaultValue": "twadmin" for the password element of the modelproviderconfig.json file which seems to have caused the error above and the access to Thingworx Composer was possible.

Full json file attached to the case http://internal.ptc.com/salesforce/attachments/cases/12/87/18/89/modelproviderconfig.json

A

avladescu

Author

1-Visitor

Changed a bit modelproviderconfig.json and now the error is "Improper value found for model provider configuration password, system cannot start without valid password"

A

avladescu

AuthorAnswer

1-Visitor

Removed "defaultValue": "twadmin" for the password element of the modelproviderconfig.json file which seems to have caused the error above and the access to Thingworx Composer was possible.

Full json file attached to the case http://internal.ptc.com/salesforce/attachments/cases/12/87/18/89/modelproviderconfig.json

J

jkrumm

1-Visitor

Can you give me the right modelproviderconfig.json version?

i can not use thingworx backend with postgres at the moment....

2016-01-22 17:57:35.072+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ========================================

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ThingWorx Version Information

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ========================================

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] majorVersion = 6

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] minorVersion = 6

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] revision = 2

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] build = b148

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] schemaVersion = 809

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ========================================

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ThingWorx System Environment Settings

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ========================================

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] OS: Linux

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] OS arch: amd64

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] OS version: 3.10.0-327.4.4.el7.x86_64

2016-01-22 17:57:35.073+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Total Processors: 2

2016-01-22 17:57:35.074+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Default encoding: UTF-8

2016-01-22 17:57:35.074+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] JAVA vendor: Oracle Corporation

2016-01-22 17:57:35.074+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] JAVA version: 1.8.0_60

2016-01-22 17:57:35.074+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] JAVA install location: /usr/java/jdk1.8.0_60/jre

2016-01-22 17:57:35.074+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] JVM Max Memory: 411 (MB)

2016-01-22 17:57:35.074+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ========================================

2016-01-22 17:57:35.074+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] WebApp starting...

2016-01-22 17:57:40.661+0100 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] HA not configured. Initializing in standalone mode.

2016-01-22 17:57:40.661+0100 [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Default Persistence Provider Name = ThingworxPersistenceProvider

2016-01-22 17:57:40.661+0100 [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Default Persistence Provider Package Name = PostgresPersistenceProviderPackage

2016-01-22 17:57:40.682+0100 [L: INFO] [O: c.t.p.p.PostgresDatasource] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Reading configuration from configTableCol

2016-01-22 17:57:40.782+0100 [L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] [message: Improper value found for model provider configuration password, system cannot start without valid password]

2016-01-22 17:57:40.782+0100 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Datastore database...INITIALIZED

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.