ISSUE: SQLGrammarException: could not extract result set

Hi all,

I've just installed AA v11 in a single node environment for POC purposes. Everything installed correctly and I am able to log into control room and add a Bot Creator user.

On a few of the screens in Control Room (User, Roles, Audit trail) I am getting an error message indicating:

org.hibernate.exception.SQLGrammarException: Could not extract ResultSet 

On the User screen this error is preventing the table from showing the Bot Creator user that was added. I can see in the database that the user exists, and the user is able to log into AA Client.

It looks like some of the queries that select from the user, roles, and audit tables are not working for me. Is there a log file that I can view these queries in?

Has anyone seen this error before?

Sign In or Register to comment.