Skip to main content
R
remixed1231-Visitor
1-Visitor
June 24, 2018
Solved

Thingworx 8.3 PostgreSQL failing to start

  • June 24, 2018
  • 2 replies
  • 6960 views

Just spent 3 days trying to get Thingworx 8.3 PostgreSQL to start, gave up and went back to 8.2.5 which worked first go.

There seems to be some issue related to the platform-setting, possibly something to do with the initialPassword. My password was over 10 characters in length.

This information is for the product team so as to trouble shoot, or possibly an update to the documentations about new setting requirements. 

 

"PlatformSettingsConfig":{
"AdministratorUserPassword":{
"InitialPassword":"PasswordWas10inLength"

 

Here are some other outputs from logs I have seen. 

Application Log

2018-06-24 07:04:59.222+0800 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ========================================
2018-06-24 07:04:59.222+0800 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ThingWorx Version Information
2018-06-24 07:04:59.222+0800 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ========================================
2018-06-24 07:04:59.222+0800 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] majorVersion = 8
2018-06-24 07:04:59.222+0800 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] minorVersion = 3
2018-06-24 07:04:59.222+0800 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] revision = 0
2018-06-24 07:04:59.223+0800 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] build = b349
2018-06-24 07:04:59.223+0800 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] schemaVersion = 1030
2018-06-24 07:04:59.223+0800 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ========================================
2018-06-24 07:04:59.223+0800 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ========================================
2018-06-24 07:04:59.223+0800 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ThingWorx System Environment Settings
2018-06-24 07:04:59.223+0800 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ========================================
2018-06-24 07:04:59.223+0800 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] OS: Windows Server 2016
2018-06-24 07:04:59.223+0800 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] OS arch: amd64
2018-06-24 07:04:59.223+0800 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] OS version: 10.0
2018-06-24 07:04:59.223+0800 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Total Processors: 4
2018-06-24 07:04:59.229+0800 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Default encoding: UTF-8
2018-06-24 07:04:59.229+0800 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] JAVA vendor: Oracle Corporation
2018-06-24 07:04:59.229+0800 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] JAVA version: 1.8.0_161
2018-06-24 07:04:59.229+0800 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] JAVA install location: C:\Program Files\Java\jre1.8.0_161
2018-06-24 07:04:59.230+0800 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] JVM Max Memory: 12288 (MB)
2018-06-24 07:04:59.230+0800 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] ========================================
2018-06-24 07:04:59.230+0800 [L: INFO] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] WebApp starting...
2018-06-24 07:04:59.564+0800 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] HA mode not enabled. Initializing and starting in standalone mode.
2018-06-24 07:04:59.564+0800 [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Default Persistence Provider Name = ThingworxPersistenceProvider
2018-06-24 07:04:59.564+0800 [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Default Persistence Provider Package Name = PostgresPersistenceProviderPackage
2018-06-24 07:04:59.576+0800 [L: INFO] [O: c.t.p.p.PostgresDatasource] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Reading configuration from configTableCol
2018-06-24 07:04:59.901+0800 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Managers...INITIALIZED
2018-06-24 07:04:59.904+0800 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Database initialization started...
2018-06-24 07:05:00.168+0800 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] System ownership locking started...
2018-06-24 07:05:00.183+0800 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] System ownership locking complete
2018-06-24 07:05:00.450+0800 [L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] [message: Error creating Administrator user. See security log for details.]
2018-06-24 07:05:00.463+0800 [L: INFO] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Connection ThingworxPersistenceProvider, type PostgresPersistenceProviderPackage stopped
2018-06-24 07:05:00.463+0800 [L: WARN] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Could not find persistenceProviderPackage PostgresPersistenceProviderPackage and thus could not stop data processing
2018-06-24 07:05:00.465+0800 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] [message: Unable to initialize and start system: Error creating Administrator user. See security log for details.]
2018-06-24 07:05:00.465+0800 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] *** Web Application STATE is being set to ERROR! ***
2018-06-24 07:05:05.241+0800 [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-5] Could not handle request

Security Log

2018-06-24 07:00:22.409+0800 [L: ERROR] [O: S.c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Check the InitialPassword setting in the AdministratorUserPassword section in platform-settings.json. Password must be a minimum of 10 characters
2018-06-24 07:00:22.456+0800 [L: INFO] [O: S.c.t.s.a.s.SSOContext] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] SSOContext created...
2018-06-24 07:00:22.550+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
2018-06-24 07:00:22.565+0800 [L: INFO] [O: S.c.t.s.s.SCIMProvider] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Initializing SCIMProvider servlet...
2018-06-24 07:00:22.581+0800 [L: ERROR] [O: S.c.t.s.s.SCIMProvider] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] SCIMProvider initialization failure. Thingworx Server is not running
2018-06-24 07:00:32.444+0800 [L: ERROR] [O: S.c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [T: http-nio-80-exec-1] Could not handle request

 

The good news is that I learnt a lot about how Thingworx functions under the hood in trying to trouble shoot this issue.

Best answer by jdass

Hi @brpeters,

 

The platform-settings.json had a missing comma and brackets. Try with this -

 

{
    "PlatformSettingsConfig": {
        "BasicSettings": {
            "BackupStorage": "/ThingworxBackupStorage",
            "DatabaseLogRetentionPolicy": 7,
            "EnableBackup": true,
            "EnableHA": false,
            "EnableSystemLogging": false,
            "EnableSSO": false,
            "FileRepositoryRoot": "/ThingworxStorage",
            "HTTPRequestHeaderMaxLength": 2000,
            "HTTPRequestParameterMaxLength": 2000,
            "InternalAesCryptographicKeyLength": 128,
            "Storage": "/ThingworxStorage"
        },
        "AdministratorUserSettings": {
            "InitialPassword": "Administrator123"
        },
        "LicensingConnectionSettings": {
            "username": "*******",
            "password": "*********************",
            "timeout": "60"
        }
    }
}

 

The best way to check the syntax of the platform-settings.json is by using a JSON Validator to validate the file.

2 replies

R
remixed1231-VisitorAuthor
1-Visitor
June 24, 2018

I should add, that Thingworx is actually starting in Tomcat. But when attempting to access either composure or a mashup, the browser returns a 401 error. 

Z
zyuan15-Regular Member
5-Regular Member
June 25, 2018

Hi, this problem happened to me too, and then I found out the problem is with my platform_setting.json file.

 

I also changed a lot of passwords in AdministratorUserPassword, but the final problem shows that I missed a " : " between and a comma after the "AdministratorUserPassword":{ }  , you should double check the json file, and compare it with the sample json file in the end of the installation guide.

R
remixed1231-VisitorAuthor
1-Visitor
June 25, 2018

I ran the JSON in a online JSON validator, which did not pick up such an issue. It did however find that  the following was an issue, because I didn't use an escape character (another \).However when I used the escape character Thingworx app would not start in Tomcat at all. 

 

 "Storage":"C:\ThingworxStorage"

Also, if I used the standard option as below. Thingworx app would not start in Tomcat. 

   "Storage":"/ThingworxStorage"

I agree, it is likely something wrong with my platform-settings, but I could not find it after trying many things 

 

     

B
brpeters5-Regular Member
5-Regular Member
June 26, 2018

Hi ,

 

I have exactly the same issue. I am upgrading TWX 8.0 to TWX 8.3.   Do I missed something? 

 

Here you can see my platform-settings.json: 

 
"PlatformSettingsConfig": {
"BasicSettings": {
"BackupStorage": "/ThingworxBackupStorage",
"DatabaseLogRetentionPolicy": 7,
"EnableBackup": true,
"EnableHA": false,
"EnableSystemLogging": false,
"EnableSSO": false,
"FileRepositoryRoot": "/ThingworxStorage",
"HTTPRequestHeaderMaxLength": 2000,
"HTTPRequestParameterMaxLength": 2000,
"InternalAesCryptographicKeyLength": 128,
"Storage": "/ThingworxStorage"
},
"AdministratorUserSettings": {
"InitialPassword":"Administrator123"
},
"LicensingConnectionSettings": {
"username":"*******",
"password":"*********************"
"timeout":"60"
}
}

regards 

 

Thank you.

Terms & ConditionsAccessibility statement