Automic Automation Intelligence 6.4.2-2 introduced a new Database Inconsistency Remediation Script that can be run to remediate various database issues that can prevent AAI fully initializing.
These inconsistencies can occur if AAI is shutdown abruptly, or if the connection to the AAI database is interrupted while AAI is still processing updates.
This script will allow you to remediate the database issues without having to log in to your database or contact your DBA, you will just need access to the AAI Server.
If you are on an earlier release of of AAI we would advise upgrading to the latest version of AAI, 6.4.2-2 at the time of writing this article.
If you do run into this on versions earlier then 6.4.2-2, there are manual SQL scripts you can run in the article below: