Thingworx 8.3 PostgreSQL failing to start

[remixed123]

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.

[remixed123]

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. 

[zyuan1]

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.

[remixed123]

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 

[brpeters]

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.

[jdass · Accepted solution]

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.

[zyuan1]

I usually left the Basic Setting part blank and only keep the licensing, persistence provider and initial password part in the json file, since the Basic part are mostly by default, I didn't change anything inside, and also avoided typo errors.

[brpeters]

Hi 

now ist working with follow config:  : )   regards

{
"PlatformSettingsConfig" : {
"AdministratorUserSettings": {
"InitialPassword":"**********"
},

"BasicSettings": {
"Storage": "../ThingworxStorage",
"BackupStorage": "../ThingworxBackupStorage"
}
},


"LicensingConnectionSettings": {
"username":"brpeters",
"password":"**********",
"timeout":"60"
}
}

[zyuan1]

Hi, was your problem solved after re-configuring the json file like mentioned in the last comment?