Maintenance Release Upgrade
Maintenance Release Upgrade Process
Upgrading to a maintenance release (for example, 9.0.0 to 9.0.1 or 9.5.1 to 9.5.2) follows the following simplified in-place upgrade path. Upgrade scripts are not required for these upgrades.
* 
This assumes you are upgrading to the same database.
* 
If you are using ThingWorx Apps in addition to ThingWorx platform, verify that the version of ThingWorx you are upgrading to is supported with the version of ThingWorx Apps. See ThingWorx Apps Upgrade Support Matrix.
1. Obtain the new Thingworx.war from PTC Software Downloads.
2. Verify that your platform-settings.json file includes the following ExtensionPackageImportPolicy parameters set to true to allow extensions to be imported. See this topic for best practices on configuration.
"ExtensionPackageImportPolicy": { "importEnabled": <true or false>, "allowJarResources": <true or false>, "allowJavascriptResources": <true or false>, "allowCSSResources": <true or false>, "allowJSONResources": <true or false>, "allowWebAppResources": <true or false>, "allowEntities": <true or false>, "allowExtensibleEntities": <true or false> },
3. Stop Tomcat.
4. Go to the Tomcat installation at \Apache Software Foundation\Tomcat x.x\webapps and delete the Thingworx.war file and the Thingworx folder.
5. Place the new Thingworx.war file in \Apache Software Foundation\Tomcat x.x\webapps.
6. Start Tomcat.
7. If the upgrade fails with the following error, go to the next step. This error will occur if any custom index value is greater than or equal to 64 characters.
Unable to Invoke Service Reindex on Data Table : com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated in table 'thingworx.thingworx.data_table_indexes', column 'mskey'. Truncated value: '<with_actual_field_Value_from_mskey_field>'.
8. Execute thingworxMssqlSchemaUpdate<priorVersion>-to-<currentVersion>.bat/.sh (for MSSQL) or thingworxAzureSchemaUpdate<priorVersion>-to-<currentVersion>.bat/.sh (for Azure).
sqlcmd -S server\\serverinstance,port -U db_user -P password -d databaseName -i <schemaUpdateFile.sql>
Running this script will increase the mskey column length and will update indexes.
9. Start Tomcat.
Was this helpful?