ThingWorx Installation
 |
ThingWorx Applications can be installed on an existing ThingWorx installation, as long as it is a version and system that is compatible with ThingWorx Applications. For more information, see ThingWorx Applications System Requirements.
|
|
|
Ensure the JDBC driver for Microsoft SQL is installed before attempting to connect the database thing to the database
|
1. Download the ThingWorx installation package for the appropriate ThingWorx version from the PTC Software Downloads page. Unzip the downloaded installation package.
|
|
Use the ThingWorx-Platform-MSSQL-X-X-X package to install ThingWorx.
|
2. Follow the installation instructions for the appropriate ThingWorx version by clicking on links below:ThingWorx 9.3 and ThingWorx 8.5.7
3. Modify the platform-setting.json file as needed for configuration, and as shown in the following example. Replace the content in bold text with values appropriate for the configuration. Ensure that the ScriptTimeout setting is set to 500.
For more information, see platform-settings.json Configuration Details in the ThingWorx 9 Help Center or platform-settings.json Configuration Details in the ThingWorx 8 Help Center.
{
"PlatformSettingsConfig": {
"ExtensionPackageImportPolicy": {
"importEnabled": true,
"allowJarResources": true,
"allowJavascriptResources": true,
"allowCSSResources": true,
"allowJSONResources": true,
"allowWebAppResources": true,
"allowEntities": true,
"allowExtensibleEntities": true
},
"AdministratorUserSettings": {
"InitialPassword": "<password>"
},
"BasicSettings": {
"BackupStorage": "/<Backupstoragename>",
"DatabaseLogRetentionPolicy": 7,
"EnableBackup": false,
"EnableHA": false,
"EnableSystemLogging": false,
"EnableSSO": false,
"FileRepositoryRoot": "/<FileReposioryRootname>",
"HTTPRequestHeaderMaxLength": 2000,
"HTTPRequestParameterMaxLength": 2000,
"InternalAesCryptographicKeyLength": 128,
"Storage": "/<Storagename>",
"ScriptTimeout": 500
}
},
"ContentTypeSettings": {
"supportedMediaEntityContentTypes": [
"video/3gpp2",
"x-unknown/x-unknown",
"audio/x-aac",
"audio/x-aiff",
"video/x-ms-asf",
"audio/basic",
"video/x-msvideo",
"image/cgm",
"text/css",
"application/vnd.ms-excel",
"application/msword",
"application/vnd.ms-word.document.macroenabled.12",
"application/vnd.openxmlformats-officedocument.wordprocessingml.document",
"application/vnd.ms-word.template.macroenabled.12",
"application/vnd.openxmlformats-officedocument.wordprocessingml.template",
"image/vnd.dwg",
"image/vnd.dxf",
"application/x-msmetafile",
"audio/flac",
"application/x-gtar",
"application/x-gzip",
"text/html",
"image/x-icon",
"model/iges",
"application/x-iso9660-image",
"application/json",
"video/mpeg",
"audio/x-mpegurl",
"audio/mp4",
"video/mp4",
"audio/midi",
"video/quicktime",
"audio/mpeg",
"application/msproject",
"application/msoutlook",
"application/octet-stream",
"application/msonenote",
"application/vnd.ms-powerpoint",
"application/vnd.ms-powerpoint.template.macroenabled.12",
"application/vnd.openxmlformats-officedocument.presentationml.template",
"application/vnd.ms-powerpoint.addin.macroenabled.12",
"application/vnd.ms-powerpoint.slideshow.macroenabled.12",
"application/vnd.openxmlformats-officedocument.presentationml.slideshow",
"application/vnd.ms-powerpoint.presentation.macroenabled.12",
"application/vnd.openxmlformats-officedocument.presentationml.presentation",
"x-ptc/x-part",
"application/vnd.ms-publisher",
"application/x-rar-compressed",
"application/rsd+xml",
"application/rtf",
"text/richtext",
"application/vnd.stardivision.draw",
"application/vnd.stardivision.calc",
"application/sdp",
"application/vnd.stardivision.writer",
"application/vnd.ms-powerpoint.slide.macroenabled.12",
"application/vnd.openxmlformats-officedocument.presentationml.slide",
"application/x-tar",
"image/tiff",
"text/plain",
"application/visio",
"audio/wav",
"audio/x-ms-wax",
"video/x-ms-wm",
"audio/x-ms-wma",
"application/x-ms-wmd",
"video/x-ms-wmv",
"video/x-ms-wmx",
"application/vnd.ms-wpl",
"video/x-ms-wvx",
"application/vnd.ms-excel.addin.macroenabled.12",
"application/vnd.ms-excel.sheet.binary.macroenabled.12",
"application/vnd.ms-excel.sheet.macroenabled.12",
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"application/vnd.ms-excel.template.macroenabled.12",
"application/vnd.openxmlformats-officedocument.spreadsheetml.template",
"text/xml",
"application/vnd.ms-xpsdocument",
"application/xml",
"application/zip",
"application/ed",
"application/octet-stream",
"image/svg+xml"
]
},
"PersistenceProviderPackageConfigs": {
"MssqlPersistenceProviderPackage": {
"ConnectionInformation": {
"driverClass": "com.microsoft.sqlserver.jdbc.SQLServerDriver",
"jdbcUrl": "jdbc:sqlserver://SQLSERVER:<port>;databaseName=<databasename>;applicationName=<application name>;",
"password": "<password>",
"username": "<username>"
}
}
}
}
"PlatformSettingsConfig": {
"ExtensionPackageImportPolicy": {
"importEnabled": true,
"allowJarResources": true,
"allowJavascriptResources": true,
"allowCSSResources": true,
"allowJSONResources": true,
"allowWebAppResources": true,
"allowEntities": true,
"allowExtensibleEntities": true
},
"AdministratorUserSettings": {
"InitialPassword": "<password>"
},
"BasicSettings": {
"BackupStorage": "/<Backupstoragename>",
"DatabaseLogRetentionPolicy": 7,
"EnableBackup": false,
"EnableHA": false,
"EnableSystemLogging": false,
"EnableSSO": false,
"FileRepositoryRoot": "/<FileReposioryRootname>",
"HTTPRequestHeaderMaxLength": 2000,
"HTTPRequestParameterMaxLength": 2000,
"InternalAesCryptographicKeyLength": 128,
"Storage": "/<Storagename>",
"ScriptTimeout": 500
}
},
"ContentTypeSettings": {
"supportedMediaEntityContentTypes": [
"video/3gpp2",
"x-unknown/x-unknown",
"audio/x-aac",
"audio/x-aiff",
"video/x-ms-asf",
"audio/basic",
"video/x-msvideo",
"image/cgm",
"text/css",
"application/vnd.ms-excel",
"application/msword",
"application/vnd.ms-word.document.macroenabled.12",
"application/vnd.openxmlformats-officedocument.wordprocessingml.document",
"application/vnd.ms-word.template.macroenabled.12",
"application/vnd.openxmlformats-officedocument.wordprocessingml.template",
"image/vnd.dwg",
"image/vnd.dxf",
"application/x-msmetafile",
"audio/flac",
"application/x-gtar",
"application/x-gzip",
"text/html",
"image/x-icon",
"model/iges",
"application/x-iso9660-image",
"application/json",
"video/mpeg",
"audio/x-mpegurl",
"audio/mp4",
"video/mp4",
"audio/midi",
"video/quicktime",
"audio/mpeg",
"application/msproject",
"application/msoutlook",
"application/octet-stream",
"application/msonenote",
"application/vnd.ms-powerpoint",
"application/vnd.ms-powerpoint.template.macroenabled.12",
"application/vnd.openxmlformats-officedocument.presentationml.template",
"application/vnd.ms-powerpoint.addin.macroenabled.12",
"application/vnd.ms-powerpoint.slideshow.macroenabled.12",
"application/vnd.openxmlformats-officedocument.presentationml.slideshow",
"application/vnd.ms-powerpoint.presentation.macroenabled.12",
"application/vnd.openxmlformats-officedocument.presentationml.presentation",
"x-ptc/x-part",
"application/vnd.ms-publisher",
"application/x-rar-compressed",
"application/rsd+xml",
"application/rtf",
"text/richtext",
"application/vnd.stardivision.draw",
"application/vnd.stardivision.calc",
"application/sdp",
"application/vnd.stardivision.writer",
"application/vnd.ms-powerpoint.slide.macroenabled.12",
"application/vnd.openxmlformats-officedocument.presentationml.slide",
"application/x-tar",
"image/tiff",
"text/plain",
"application/visio",
"audio/wav",
"audio/x-ms-wax",
"video/x-ms-wm",
"audio/x-ms-wma",
"application/x-ms-wmd",
"video/x-ms-wmv",
"video/x-ms-wmx",
"application/vnd.ms-wpl",
"video/x-ms-wvx",
"application/vnd.ms-excel.addin.macroenabled.12",
"application/vnd.ms-excel.sheet.binary.macroenabled.12",
"application/vnd.ms-excel.sheet.macroenabled.12",
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"application/vnd.ms-excel.template.macroenabled.12",
"application/vnd.openxmlformats-officedocument.spreadsheetml.template",
"text/xml",
"application/vnd.ms-xpsdocument",
"application/xml",
"application/zip",
"application/ed",
"application/octet-stream",
"image/svg+xml"
]
},
"PersistenceProviderPackageConfigs": {
"MssqlPersistenceProviderPackage": {
"ConnectionInformation": {
"driverClass": "com.microsoft.sqlserver.jdbc.SQLServerDriver",
"jdbcUrl": "jdbc:sqlserver://SQLSERVER:<port>;databaseName=<databasename>;applicationName=<application name>;",
"password": "<password>",
"username": "<username>"
}
}
}
}
4. In addition to the standard Java Options to be configured for ThingWorx, ensure the following options are configured:
◦ Java 9 options:
▪ -add-opens=java.base/java.lang-ALL-UNNAMED
▪ -add-opens=java.base/java.lang-ALL-UNNAMED
▪ -add-opens=java.rmi/sun.mi.transport=ALL-UNNAMED
◦ Initial Memory Pool:
▪ At least 4196
◦ Maximum Memory Pool:
▪ 85% of total memory available
◦ Java Options:
▪ -Duser.timezone — UTC (In addition to existing settings, not replacing)
For ThingWorx Foundation, open a command prompt and type the following command to access Tomcat Properties:
tomcat9w //ES//<SERVICE-NAME>
By default, the service name is 'ThingWorx-Foundation'. Verify the name before running the command above by locating the Services Manager and checking the properties for the service "Apache Tomcat…".