Why does the AAI DB Schema version not match my version of AAI?
search cancel

Why does the AAI DB Schema version not match my version of AAI?

book

Article ID: 215527

calendar_today

Updated On:

Products

Automic Automation Intelligence

Issue/Introduction

Why does the AAI DB Schema version in the configuration tool not match my version of AAI?

Environment

Release : 6.2.0

Component : AUTOMIC AUTOMATION INTELLIGENCE INTEGRATION

Resolution

On the database tab of the configuration tool, you will see a DB Schema version that may be earlier then your version of AAI.

Not every release of AAI will have database schema updates, so if you upgrade to a version that has no updates to the schema, the schema version will remain the same.

 

For example with 6.2.0-2 the DB Schema version is 6.1.0 as version 6.1.0 was the last release to have any schema updates.

 

Upon upgrading there will be an upgrade .sql version in the /<Install Dir>/scripts folder like upgradeJawsDbTo6.1.0.sql which will have the latest sql changes that should be run after each upgrade if there are any changes.

 

The schema version can be seen within that file.

Additional Information

In order to determine the AAI version, there are a few ways to do that described here.

https://knowledge.broadcom.com/external/article?articleId=199841