upgrade to thingworx 8.4 error

[SonaliPatro]

After upgrading from 8.2 to 8.4 i am not able to launch the Thingworx Composer.

[SonaliPatro]

Please find the attached screenshot

[rosharma]

@SonaliPatro : probably issue with incorrect platform-settings.json file( with respect to database you are using)

and secondly check with password length.it should be >14 chars

like for ex if going with H2 database your json file should actually look like as below -similarly it would change as per your database.( database type should come in this PersistenceProviderPackageConfigs & other details for username shall fall in PlatformSettingsConfig)

for other details follow help centre link as well

http://support.ptc.com/help/thingworx_hc/thingworx_8_hc/en/#page/ThingWorx%2FHelp%2FGetting_Started%2FInstallingandUpgrading%2FInstallation%2Fplatform_settings_json_configuration_details.html

{
"PlatformSettingsConfig": {
"AdministratorUserSettings": {
"InitialPassword": "xxxxxxxxxxxxxx"
},
"ExtensionPackageImportPolicy": {
"importEnabled": true,
"allowJarResources": true,
"allowJavascriptResources": true,
"allowCSSResources": true,
"allowJSONResources": true,
"allowWebAppResources": true,
"allowEntities": true,
"allowExtensibleEntities": true
}
},
"PersistenceProviderPackageConfigs":{
"H2PersistenceProviderPackage":{
"ConnectionInformation":{
"password": "twadmin",
"username": "twadmin"
}
}
}
}

[SonaliPatro]

@rosharma I am attaching the application log file. I have updated the platform-settings.json file for the database PostGreSQL.

[rosharma · Accepted solution]

this is the error observed in logs:

[message: Connections could not be acquired from the underlying database!]

now this seems to be issue related to database and could be due to many reasons.

1. Database postgresql is not properly setup. number of tables should be 58

2. incorrect credentials for database in platform json file

3. incorrect format for platform settings file

4. incorrect postgresql database versions

there are multitude of assistance available on this error issue on our KCS portal

few articles you can search and verify the things accordingly- one of the article link is below

https://www.ptc.com/en/support/article?n=CS235937

[slangley]

Hi @SonaliPatro.

If one of the previous responses provided by @rosharma answered your question, please mark the appropriate one as the Accepted Solution for the benefit of others with the same question.

Regards.

--Sharon