Overview

Recommendations and Best Practices for VM

Infoworks recommends you to complete the following steps prior to upgrading:

• Ensure to take a backup of the previous version of Infoworks in a tar.
• Ensure to take a MongoDB backup if the Infoworks tar is large.
• Ensure to take a snapshot of the Edge node disk.
• Ensure that a valid interactive_cluster exists before the upgrade takes place.
• Crontab is not enabled for Infoworks during upgrade. To avoid this issue, ensure that crontab executable has 4755 permissions:

root@iw-446:~# ls -la /usr/bin/crontab

-rwsr-xr-x 1 root crontab 43720 Feb 13 2020 /usr/bin/crontab

Important Note for Teradata Users

You must perform the following steps after upgrading:

1. Ensure that you download the Teradata JDBC driver from the Teradata portal.
2. Extract the compressed file (.zip or .tar), and copy the drivers namely, tdgssconfig.jar, terajdbc4.jar from the extracted file.
3. Create lib/dist-jobs directory under the $IW_HOME/lib/ingestion/connectors/teradata folder, so that the directory structure becomes $IW_HOME/lib/ingestion/connectors/teradata/lib/dist-jobs, and place the downloaded drivers inside it.

Recommendations and Best Practices for AKS

Infoworks recommends you to complete the following steps prior to upgrading:

• Ensure to take a MongoDB backup.
• Ensure that a valid interactive_cluster exists before the upgrade takes place.

Important Note for Teradata Users

You must perform the following steps after upgrading:

Step 1: Ensure that you download the Teradata JDBC driver from the Teradata portal.

Step 2: Extract the compressed file (.zip or .tar), and copy the drivers namely, tdgssconfig.jar, terajdbc4.jar from the extracted file.

Step 3: Create following directories if it does not already exist.

$IW_HOME/uploads/lib/external-dependencies/common/spark_2x_211/teradata

$IW_HOME/uploads/lib/external-dependencies/common/spark_2x_212/teradata

$IW_HOME/uploads/lib/external-dependencies/common/spark_3x_212/teradata

Step 4: Paste the extracted drivers inside it.

Important Note for Cosmos DB as Target Users

You must perform the following steps after upgrading:

Step 1: Ensure that you download the Azure CosmosDB Spark 2.x jars from https://repo1.maven.org/maven2/com/microsoft/azure/azure-cosmosdb-spark_2.4.0_2.11/3.6.8/azure-cosmosdb-spark_2.4.0_2.11-3.6.8.jar

Step 2: Create the following directory if it does not exist already

$IW_HOME/uploads/lib/external-dependencies/common/spark_2x_211/cosmos_db

Step 3: Copy and place the downloaded jar file inside the directory.

Step 4: Ensure that you download the Azure CosmosDB Spark 3.x jars from https://search.maven.org/remotecontent?filepath=com/azure/cosmos/spark/azure-cosmos-spark_3-1_2-12/4.1.0/azure-cosmos-spark_3-1_2-12-4.1.0.jar.

Step 5: Create following directories if it not does not exist already

$IW_HOME/uploads/lib/external-dependencies/common/spark_3x_212/cosmos_db

Step 6: Copy and place the downloaded drivers inside it.