Infoworks Release Notes
Release Notes

v5.2.0.6

Date of Release: August 25, 2022

Resolved Issues

JIRA IDIssueSeverity
IPD-18777Direct incremental ingestion to existing table on snowflake without any audit column is not allowed.Highest
IPD-18835The user managed table configuration could not enabled due to "is_table_user_managed" not being present.Highest
IPD-18911The REST API doesn’t support “HIVE_UDF” source extensions for columns.Highest
IPD-18921The "in_notin" node under pipelines does not support multiple columns.Highest
IPD-18931Infoworks metacrawl job for CSV source fetches incorrect number of columns.Highest

Upgrade

For upgrading from 5.2.0 to 5.2.0.6, execute the following commands:

Step 1: Use the deployer to upgrade from 5.2.0 to 5.2.0.6.

Step 2: Go to iw_home/scripts folder of the test machine.

Step 3: Execute the following command:

rm update.sh

Step 4: Download the update.sh.

wget https://iw-saas-setup.s3.us-west-2.amazonaws.com/5.2/update.sh

Step 5: Give update.sh executable permission.

chmod +x update.sh

Step 6: Update the package to the hotfix source iw_home/bin/env.sh

./update.sh -v 5.2.0.6-ubuntu2004

Rollback

To go back to previous checkpoint version:

Step 1: In a web browser, go to your Infoworks system, scroll-down to the bottom, and click the Infoworks icon.

Step 2: The Infoworks Manifest Information page opens in a new tab. Scroll down and check the Last Checkpoint Version.

Step 3: ssh to Infoworks VM and switch to {{IW_USER}}.

Step 4: Initialize the variables in the bash shell.

full_version= 5.2.0.6

unpatched_version=$(echo $full_version | cut -d "." -f 1-3)

major_version=$(echo $full_version | cut -d "." -f 1-2)

previous_version=<Previous Version> # Last Checkpoint Version from step 1

os_suffix=<OS Suffix> # One of [ ubuntu2004 amazonlinux2 rhel8 ]

Step 5: Download the required deployer for the current applied patch.

https://iw-saas-setup.s3-us-west-2.amazonaws.com/${major_version}/deploy_${unpatched_version}.tar.gz

Step 6: Execute the SCP command for the above mentioned files to the following path.

${IW_HOME}/scripts/.

Step 7: Extract the deployed tar file in case it does not exist.

cd ${IW_HOME}/scripts

[[ -d iw-installer ]] && rm -rf iw-installer

tar xzf deploy_${unpatched_version}.tar.gz

cd iw-installer

Step 8: Initialize the environment variables.

source ${IW_HOME}/bin/env.sh

export IW_PLATFORM=saas

Step 9: Run the Rollback command.

./rollback.sh -v ${previous_version}-${os_suffix}