Not able to start Thingworx8.4.1 with H2persistence provider

Forum|Forum|7 years ago
March 11, 2019
2 replies
4880 views

Hi Team,

I have installed TWRX 8.4.1 with H2 persistence provider, but is not able to start the WebApp on tomcat.The following error is displayed:

Not able to get connection from the underlying database.

I suppose starting from Thingworx 8.4+, a username & password is required in the platform-settings.json file for H2 persistence provider also.Below is the related content of my platform-settings.json file:

"PersistenceProviderPackageConfigs":{ 
"H2PersistenceProviderPackage":{ 
"ConnectionInformation":{ 
"password":"twadmin",
"username":"twadmin"
}
}
}

Please help regarding what is the default username & password for H2 provider.

Install-Upgrade

M

mnarang

5-Regular Member

If possible can you attach complete application log and platform-settings.json ?

I believe you have downloaded and placed the H2 specific war in webapps .

Thanks ,

Mukul Narang

T

tsharma

Author

1-Visitor

Mukul,

Thanks for the prompt reply, the application log & settings file is attached for your reference. Also, as informed earlier i think the issue is with the new setting of username & password required for H2 provider for TWRX 8.4+ versions as i am able to run TWRX Postgres 8.4.1 without any issues on the same machine.

Below is the platfomr-settings.json file:

{ 
 "PlatformSettingsConfig":{ 
 "AdministratorUserSettings":{ 
 "InitialPassword":"<initial-password>"
 },
	 "ContentTypeSettings": {
"supportedMediaEntityContentTypes" : ["image/svg+xml","image/png","image/gif","image/bmp","image/jpeg","application/pdf","image/vnd.microsoft.icon"]
}
 },
 "ExtensionPackageImportPolicy":{ 
 "importEnabled":"true",
 "allowJarResources":"true",
 "allowJavascriptResources":"true",
 "allowCSSResources":"true",
 "allowJSONResources":"true",
 "allowWebAppResources":"true",
 "allowEntities":"true",
 "allowExtensibleEntities":"true"
 },
 "PersistenceProviderPackageConfigs":{ 
 "H2PersistenceProviderPackage":{ 
 "ConnectionInformation":{ 
 "password":"twadmin",
 "username":"twadmin"
 }
 }
 },
 "LicensingConnectionSettings":{ 
 "username":"<ptc-username>",
 "password":"<ptc-password>"
 }
}

1_ApplicationLog.log

M

mnarang

5-Regular Member

I don't think there is actually a problem with H2 DB username/pass .One thing i noticed is the structure of your json file ,Extension package import policy comes under platform settings config only ,but you have put it outside config block .I am attaching my working json for 8.4 H2 only ,kindly see this for reference and make changes in your json .

The attached file is in .txt as it does not allow to attach json .

Thanks ,

Mukul Narang

1_platform-settings.txt