Skip to main content
S
SonaliPatro1-Visitor
1-Visitor
March 5, 2019
Solved

upgrade to thingworx 8.4 error

  • March 5, 2019
  • 1 reply
  • 2243 views

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

 

    Best answer by rosharma

    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

     

    1 reply

    S
    SonaliPatro1-VisitorAuthor
    1-Visitor
    March 5, 2019

    Please find the attached screenshot

    R
    rosharma16-Pearl
    16-Pearl
    March 5, 2019

    @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"
    }
    }
    }
    }

    S
    SonaliPatro1-VisitorAuthor
    1-Visitor
    March 5, 2019

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

    Terms & ConditionsAccessibility statement