AAI Login GUI: JAWS Domain missing after fresh installation

Products

• Automation Analytics & Intelligence

Issue/Introduction

Following a fresh installation or upgrade to Automic Automation Intelligence (AAI) 24.4, users encounter the following issues:

• The login GUI does not display the default 'JAWS' domain.
• Admin users are unable to log in because the domain field is blank or missing expected values.
• The Configuration Tool may show incorrect database schema versions.

Environment

Automation Analytics & Intelligence 24.x

Cause

This issue occurs when the database initialization scripts (e.g., createJawsDB.sql) are executed using external tools like Oracle SQL Developer. These tools often require an explicit manual commit to finalize the data insertion into the jawsproperties table. Without this commit, the AAI application cannot retrieve the necessary domain and version information from the database.

Resolution

To resolve this issue, ensure that all SQL commands executed during the database setup are properly committed:

1. Log in to your Oracle database using a SQL client (e.g., SQL Developer) with the AAI database user (e.g., AAI).
2. Execute the following command to ensure all previous script actions are saved:
   sql

   COMMIT;

3. (Optional) Verify the schema version is correctly set:
   sql

   SELECT * FROM jawsproperties WHERE propertyName = 'db.schema.version';

4. Restart the AAI Configuration Tool and the AAI Application Service.
5. Refresh the Login GUI; the 'JAWS' domain should now be visible in the domain dropdown.

Additional Information

To speak with a customer representative or a Support Engineer, see Contact Support. Scroll to the bottom of the page and click on your respective region.