Date of Release: August 25, 2022
JIRA ID | Issue | Severity |
---|---|---|
IPD-18777 | Direct incremental ingestion to existing table on snowflake without any audit column is not allowed. | Highest |
IPD-18835 | The user managed table configuration could not enabled due to "is_table_user_managed" not being present. | Highest |
IPD-18911 | The REST API doesn’t support “HIVE_UDF” source extensions for columns. | Highest |
IPD-18921 | The "in_notin" node under pipelines does not support multiple columns. | Highest |
IPD-18931 | Infoworks metacrawl job for CSV source fetches incorrect number of columns. | Highest |
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
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}