Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! X
After upgrading from 8.2 to 8.4 i am not able to launch the Thingworx Composer.
Solved! Go to 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
@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
{
"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"
}
}
}
}
@rosharma I am attaching the application log file. I have updated the platform-settings.json file for the database PostGreSQL.
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
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