How can I update the Oracle or SQL Server database connections in AAI after a database migration?

Products

• Automation Analytics & Intelligence

Issue/Introduction

How can I update the Oracle or SQL Server database connections in AAI after a database migration?

Environment

Release : 6.4.1-2

Component : AUTOMIC AUTOMATION INTELLIGENCE ENGINE

Resolution

Make backup copy of the /<Install Dir>/jboss/standalone/configuration/.jawskey file. This will be needed if you are also migrating AAI to a new server.

 

Before the database upgrade and hostname change takes place, shutdown the AAI service.

 

After the upgrade is complete, open the configurationi tool, and go to the Database Tab, end edit the database connection settings and update the new hostname, and any other connection changes, and test the connection.

 

If the test succeeds, you should be good and can start the AAI service again.

 

If it fails look at the /<install dir>/config/log/configtool.log file for any errors and share them with support.

 

If the configuration tool displays a warning about an Unexpected schema version, please check the jaws-database.xml file in the /<Install Dir>/jboss/standalone/configuration directory and verify whether or not the updated connection details were saved.

 

If you still see the old connection details, you can make a backup copy of the jaws-database.xml, then edit the existing file and update your connection details.

 

If there is a new password, update the line below from true to false:

 <encrypted>true</encrypted>

 

Then you can enter the clear text password on the the password line like:

 <password>DBPassword==</password>

 

Save the file, and launch the configuration tool again to verify there are no other errors.

 

If there are no errors you can start the AAI service.