v6.0.0.2

Date of Release: September 2024

Resolved Issues

NOTE The "*" symbol next to ID refers to the issues that have been resolved in the current release.

JIRA ID	Issue
IPD-26870*	Ingestion to target table is failing with permission issues in Unity catalog
IPD-26667	helm upgrade failed with issue in running airflowdb-upgrade pod
IPD-26669	Issue while saving Data env Mapping for Domains when access is managed through IDP
IPD-26673	Remove read only root file system for bash node pods
IPD-26690	Post 6.0 upgrade, unable to add non .sh files in the jobhook NOTE After upgrading to 6.0.0.1, add this configuration in infoworks configuration section "disable_file_extension_validation" with value "true" to disable file extension validation check.
IPD-26692	Unable to migrate workflow from DEV to PROD from UI on 6.0
IPD-26702	The status of the Streaming job is still running Under Job Status even the job was stopped/cancelled

Prerequisites

NOTE Before going through the below mentioned prerequisites for this section, ensure that all the Prerequisites for Installing Infoworks on AKS are validated.

Ensure the current deployment’s chart is present in /opt/infoworks.
Python 3.8 or later version with the pip module is installed in the Bastion VM.
Stable internet connectivity on the Bastion VM to download the required python packages from the python repository during installation/upgrades.
Validate that the version of the old chart is 6.0.0.1.

 Bash 
    
xxxxxxxxxx
 
cat /opt/infoworks/iw-k8s-installer/infoworks/Chart.yaml | grep appVersion
Copy

 Output 
    
xxxxxxxxxx
 
appVersion: 6.0.0.1
Copy


	Ensure to take backup of MongoDB Atlas and PostgresDB PaaS. In case you don't take the backup, jobs will fail after the rollback operation. For more information, refer to the MongoDB Backup and PostgresDB PaaS Backup

Upgrade Instructions

NOTE Due to limitations in DataBricks interactive cluster session management, to ensure successful upgrade and usage of upgraded Infoworks libraries:

Jobs using old versions of libraries must be completed/stopped.
Old versions of libraries must be uninstalled and databricks cluster should be restarted to clear the cache.

For the procedure of libraries uninstalling, refer Step 4 below.

To upgrade Infoworks on Kubernetes:


	It is assumed that the existing chart is placed in the /opt/infoworks directory and the user has the access permission.

 Bash 
    
xxxxxxxxxx
 
export IW_HOME="/opt/infoworks"
Copy

Before selecting the type of upgrade execute the following commands.

Step 1: Create the required directories and change the path to that directory.

 Bash 
    
xxxxxxxxxx
 
mkdir -p $IW_HOME/downloadscd $IW_HOME/downloads
Copy

NOTE If your Infoworks installation is configured not to use the Infoworks hosted registry (IW_HOSTED_REGISTRY=false), you should download the Docker image ‘infoworks-mongo-utils_v6.0.0.1.tar.gz’ following the instructions that have been shared with you. After downloading, push this image to your configured registry, ensuring that you do not change the image tags.

Internet-free Upgrade

NOTE If you are upgrading via Internet-based procedure, skip to the next section.

Step 1: Download the upgrade tar files shared by the Infoworks team to the Bastion (Jump host) VM and place it under $IW_HOME/downloads.

Step 2: To configure Internet-free upgrade, execute the following command:

 Bash 
    
xxxxxxxxxx
 
export INTERNET_FREE=true
Copy

Internet-based Upgrade

Step 1: Download the Update script tar file.

 Bash 
    
xxxxxxxxxx
 
wget https://iw-saas-setup.s3-us-west-2.amazonaws.com/6.0/iwx_updater_k8s_6.0.0.2.tar.gz
Copy

Common Steps for Both Internet-free and Internet-based

NOTE Once you have selected the type of upgrade, the below mentioned steps are common for both Internet-free and Internet-based.

Step 1: Extract the iwx_updater_k8s_6.0.0.2.tar.gz under $IW_HOME/downloads.


	Do not extract the tar file to /opt/infoworks/iw-k8s-installer as it would result in loss of data.

 Bash 
    
xxxxxxxxxx
 
tar xzvf iwx_updater_k8s_6.0.0.2.tar.gz
Copy

This should create two new files as follows - update-k8s.sh and configure.sh.

Step 2: Run the script.

 Bash 
    
xxxxxxxxxx
 
./update-k8s.sh -v 6.0.0.2
Copy

NOTE At the end of the above command's execution, if you want to run helm upgrade manually, then type N and press Enter. There is a 30-second timeout set to abandon the deployment of the upgraded version. If no input is received within the timeout duration, the deployment is triggered.

 Output 
    
​x
 
helm upgrade 600 /opt/infoworks/iw-k8s-installer/infoworks -n aks-upgrade-551 -f /opt/infoworks/iw-k8s-installer/infoworks/values.yaml ​Enter N to skip running the above command to upgrade the helm deployment. (timeout: 30 seconds): NUpgrade success
Copy

Step 3: To modify any of the configurations listed below, follow the steps:

Email configurations: smtpHost, smtpPort, smtpUsername, smtpPassword, sslEnabled
Timeout for DT
Timeout for ingestion
nginx.ingress.kubernetes.io/proxy-body-size

Step 3A: Navigate to the directory IW_HOME/iw-k8s-installer. And Edit the values.yaml file

	Name	Description	Default Values
Email configuration	smtpHost	The SMTP host URL to connect to	smtp.gmail.com
	smtpPort	SMTP port	587
	smtpUsername	The SMTP User to authenticate as	email address
	smtpPassword	The Password for the SMTP user	Encrypted password
	sslEnabled	The SSL flag	true
DT	timeoutSeconds	Timeout for DT	7200
Ingestion	timeoutSeconds	Timeout for Ingestion	7200
nginx.ingress	kubernetes.io/proxy-body-size	Nginx proxy body size	10m

NOTE

Email configurations can be found under customiwConfigs section in values.yaml
Timeouts for DT and ingestion can be found under databricks section in values.yaml
kubernetes.io/proxy-body-size can be found in nginx.ingress section in values.yaml

Step 3B: After editing the annotations, the values.yaml file should look as shown below:

Update the values and save the file.

Step 3C: Navigate to the directory IW_HOME/iw-k8s-installer. And Run the iw_deploy script

 Bash 
    
xxxxxxxxxx
 
./iw_deploy.sh
Copy

NOTE During the above command's execution, when it prompts if we need to override, type y and press Enter.

Step 3D: Restart all the deployments

 Bash 
    
xxxxxxxxxx
 
kubectl rollout restart deployment -n <namespace>
Copy

Step 4: (Applicable only for Databricks Persistent Clusters): A change in the Infoworks jar requires libraries being uninstalled and cluster restart. Without this step, there will be stale jars. Perform the following steps:

(i) Go to the Databricks workspace, navigate to the Compute page, and select the cluster that has stale jars.

(ii) In the Libraries tab, select all the Infoworks jars and click Uninstall.

(iii) From Infoworks UI or Databricks dashboard, select Restart Cluster.

Rollback

Prerequisites

Before executing the rollback script, ensure that IW_HOME variable is set.
Assuming Infoworks home directory is /opt/infoworks, run the below command to set the IW_HOME variable.
Validate that the version of the old chart is 6.0.0.1.

 Bash 
    
xxxxxxxxxx
 
export IW_HOME=/opt/infoworks
Copy

Ensure the current deployment’s chart is present in /opt/infoworks.
Execute the below command to check the appVersion.

 Bash 
    
xxxxxxxxxx
 
cat $IW_HOME/iw-k8s-installer/infoworks/Chart.yaml | grep appVersion
Copy

 Output 
    
xxxxxxxxxx
 
appVersion: 6.0.0.2
Copy


	Ensure to restore MongoDB Atlas and PostgresDB PaaS. In case you don't take the backup, jobs will fail after the restore operation. For more information, refer to the MongoDB Restore and PostgresDB Restore.

Rollback Instructions

NOTE Since IW_HOME has been exported in the Prerequisites section mentioned above, the following steps can be executed from any location for users with read/write access to the aforementioned IW_HOME.

Step 1: Download the rollback script.

 Bash 
    
xxxxxxxxxx
 
wget https://iw-saas-setup.s3.us-west-2.amazonaws.com/6.0.0.1/rollback-k8s.sh
Copy

Step 2: Place the Update script in the same directory as that of the existing iw-k8s-installer.

Step 3: Ensure you have permission to the $IW_HOME directory.

Step 4: Give executable permission to the rollback script using the below command.

 Bash 
    
xxxxxxxxxx
 
chmod +x rollback-k8s.sh
Copy

Step 5: Run the script.

 Bash 
    
xxxxxxxxxx
 
./rollback-k8s.sh -v 6.0.0.1
Copy

Step 6: You will receive the following prompt, "Enter N to skip running the above command to upgrade the helm deployment. (timeout: 30 seconds): ", type Y and press Enter.

NOTE If you want to run helm upgrade manually, then type N and press Enter.

 Prompt 
    
xxxxxxxxxx
 
Enter N to skip running the above command to upgrade the helm deployment. (timeout: 30 seconds): Y
Copy

NOTE There is a 30-second timeout set to abandon the deployment of the downgraded version. If no input is received within the timeout duration, the deployment is triggered.

Last updated on

Was this page helpful?