Database found but AAI tables do not exist

Products

• Automation Analytics & Intelligence

Issue/Introduction

I followed a lesson video (Getting Started with AAI for Automic Automation) in Broadcom Software Academy to set up AAI on windows. However, after I executed both the createDevices & createJawsDB scripts in the database management studio, the configtool database connection test shows "Database found but AAI tables do not exist". I followed an article that has the following issue's resolution. To copy the ojdbc8 jar file from Oracle Install Client into the AAI\jboss\standalone\deployments folder. However, the same connection issue persists.

 

Environment

Release :

Resolution

We could see network error in the configtool logs

The server name in configtool  was AUTOMIC

In the MSSQLstudio  it was AUTOMIC\SQLEXPRESS

Edited database in configtool to use AUTOMIC\SQLEXPRESS but still, it did not connect.

The SQL server manager -> Network configuration -> protocols

The TCPIP was disabled. Only Shared memory was enabled.

This is the reason why we were not able to connect as the port 1433 specified in configtool was not available

Customer will install an enterprise version of the database and do the install. If he comes across any issue then he will open a case and agreed that this case can be closed.