6 Replies Latest reply on Aug 3, 2016 10:33 AM by Siddharth Patel RSS
    avladescu Explorer

    Thingworx 6.6 PostgreSQL connection error

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

      • Re: Thingworx 6.6 PostgreSQL connection error
        avladescu Explorer

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

          • Re: Thingworx 6.6 PostgreSQL connection error
            avladescu Explorer

            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



              • Re: Thingworx 6.6 PostgreSQL connection error
                jkrumm Newbie

                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] ========================================

                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

                • Re: Thingworx 6.6 PostgreSQL connection error
                  Siddharth Patel Apprentice

                  hi,

                   

                  I'm unable to view your link. It seems to be blocked in my network.

                  Can you please post the details over here?

                   

                  - Siddharth