Automation Analytics & Intelligence(AAI/JAWS) Upgrade Tips

Products

• Automation Analytics & Intelligence

Issue/Introduction

Automation Analytics & Intelligence(AAI/ formerly known JAWS) Upgrade Tips.

Please review this document before upgrading AAI. 

Environment

Release : 6.x

Resolution

Before upgrading, review the latest Release Notes for the version you will be upgrading to as well as any versions in between the version you are currently on and the version you are upgrading to, to be aware of any fixes, new features, and database changes that may be required after upgrading.

 

Please also review the AAI Upgrade Guide available here.

 

Upgrade workflow:

1. Back up Database

2. Back up AAI Installation Directory

3. Download upgrade file for Windows or Linux from https://support.broadcom.com/enterprise-software/download-center, copy to the AAI server. (If Linux change permissions on the file "chmod 755 upgrade.sh".

4. Stop AAI services.  "jaws.sh stopync" on Linux or shutdown the "Automation Analytics & Intelligence" service on Windows.

• • • On Linux verify jboss is  non longer running. 

ps -eaf | grep jboss

• • • Make sure any files within the AAI directory are not open when running the upgrade.

5. Run the upgrade script. ./upgrade.sh(Linux) or upgrade.bat(Windows).

6. A file name like upgradeJawsDbTo6.x.x.sql will be created in the /<Install Dir>/scripts directory.  Have your DBA run this script to update the database schema with the user that connects to AAI.

 

Upgrade Tips:

• On Linux you will need X11 forwarding in order to run the upgrade script.
  • We recommend using MobaXterm for easy X11 setup, or if you will be using Xming with Putty, you can follow the steps for configuring Xming with Putty.
• If you do not have access to setup X11, you can do a headless upgrade following the steps here. 
• Ensure the database scripts run after upgrade are run by the user that AAI uses to connect to the database and that user has permissions to those tables or you may see an error like below:

                  ORA-00942: table or view does not exist

 

• IWS Connector - Follow the steps here for upgrading the IWS connector.

 

• You should be able to upgrade to the latest version of AAI from most versions.  If you are on a version earlier then 5.8.6 please contact Broadcom Support before attempting any upgrade.

 

• Please ensure your database server has enough storage for expansion during upgrade.