AAI Connectivity inssue to server

[Sibhi Harshavardhan]

Hi Community,

I've installed AAI using the one-click installation method, but I'm currently unable to connect to the domains. Has anyone encountered this issue before or have any insights into what might be causing it?

Thanks in advance

[Christopher Walsh]

Has the CreateDevices.sql and CreateJawsDB.sql both been run against your database?

I have seen instances on Oracle that the CreateJawsDB was run in SQL Developer and the changes were not committed and it caused this error.

You can query a few tables in the AAI DB to check to see if they have the expected values:

//JawsProperties should show schema version and other configuration details

select * from JawsPropertis;

//Userprofile should show at least 2 users

select * from userProfile;

//Should show at least the JAWS domain

select * from ldapDomain;

You can also check the server.log and jaws.log from the <Install Dir>/jboss/standalone/log directory for any errors.

------------------------------
Christopher Walsh
Broadcom Support
------------------------------