JAWS error after upgrading Autosys

Products

• Automic Automation Intelligence

Issue/Introduction

After upgrading Autosys the following exceptions is received:

com.termalabs.common.JawsException: Could not create ScrollableResults (cause: org.hibernate.exception.SQLGrammarException: could not execute query using scroll)

 

Cause

Synonyms and/or permissions were reset after upgrade

Resolution

For AutoSys databases using Oracle, you will need to create synonyms and grant read-only permissions for tables the Automic Automation Intelligence (AAI) application accesses. Please see attached word file.