JAWS error after upgrading Autosys

book

Article ID: 194303

calendar_today

Updated On:

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.

Attachments

1593696337660__Creating synonyms for AutoSys databases.docx get_app