Error when adding Autosys scheduler to AAI - Error while executing query: "from Timezone" (cause: org.hibernate.exception.SQLGrammarException: could not execute query)

Products

• Automic Automation Intelligence

Issue/Introduction

Error seen when attempting to add an Autosys scheduler to AAI

Uncaught JawsException occurred

Time: 2021/11/03 15:19:08.047 GMT
JAWS version: 6.4.0 (6.4.0-202110141505) [6.4.0-202110141505]

Java version: 1.8.0_291 (Oracle Corporation)
OS: Windows Server 2016 10.0

Exception detail:
com.termalabs.common.JawsException: Error while executing query: "from Timezone" (cause: org.hibernate.exception.SQLGrammarException: could not execute query)
 at com.termalabs.common.connection.hibernate.RichQueryCommon.executeAndTime(RichQueryCommon.java:1047)
 at com.termalabs.common.connection.hibernate.RichQueryCommon.list(RichQueryCommon.java:969)
 at com.termalabs.common.connection.hibernate.RichQueryCommon$CollectionQueryCommon.asListUnfiltered(RichQueryCommon.java:260)
 at com.termalabs.common.connection.hibernate.RichQueryCommon$CollectionQueryCommon.asList(RichQueryCommon.java:193)
 at com.termalabs.common.connection.hibernate.autosys.HibernateAutosysData.getTimezones(HibernateAutosysData.java:134)
 at com.termalabs.server.AutosysTimeZoneMapping.init(AutosysTimeZoneMapping.java:99)
 at com.termalabs.server.AutosysTimeZoneMapping.<init>(AutosysTimeZoneMapping.java:90)
 at com.termalabs.server.AutosysTimeZoneMapping$Factory.create(AutosysTimeZoneMapping.java:79)
 at com.termalabs.server.cache.SchedulerVendorImpl.setTimezoneAndInstance(SchedulerVendorImpl.java:650)
 at com.termalabs.server.cache.SchedulerVendorImpl.addAutosysSchedulerToDatabase(SchedulerVendorImpl.java:613)
 at com.termalabs.server.cache.SchedulerVendorImpl.addSchedulerToDatabase(SchedulerVendorImpl.java:546)
 at com.termalabs.server.app.scheduler.AddScheduler.addScheduler(AddScheduler.java:231)
 at com.termalabs.server.app.scheduler.AddScheduler.addScheduler(AddScheduler.java:144)
 at com.termalabs.server.ejb3.SchedulerDataManagerEJB.addScheduler(SchedulerDataManagerEJB.java:365)
 ... 12 skipped
 at com.termalabs.server.ejb3.RequestScopeEJB3Interceptor.invoke(RequestScopeEJB3Interceptor.java:94)
 ... 88 skipped
 at com.sun.proxy.$Proxy5.addScheduler(Unknown Source)
 at com.termalabs.client.model.impl.ejb.EJBSchedulerModelManagerImpl$14.processRequest(EJBSchedulerModelManagerImpl.java:567)
 at com.termalabs.client.model.impl.ejb.EJBSchedulerModelManagerImpl$14.processRequest(EJBSchedulerModelManagerImpl.java:563)
 at com.termalabs.client.util.request.RequestWorker$1.construct(RequestWorker.java:107)
 at com.termalabs.client.util.SwingWorker$2.run(SwingWorker.java:130)
 at java.lang.Thread.run(Unknown Source)

Caller:
 at com.termalabs.client.model.impl.ejb.EJBSchedulerModelManagerImpl.addScheduler(EJBSchedulerModelManagerImpl.java:582)
 at com.termalabs.client.ui.admin.EditSchedulerDialog.doOk(EditSchedulerDialog.java:1228)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at net.sourceforge.tahini.Tahini$ControllerLinker$1.actionPerformed(Unknown Source)
 at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
 at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
 at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
 at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
 at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
 at java.awt.Component.processMouseEvent(Unknown Source)
 at javax.swing.JComponent.processMouseEvent(Unknown Source)
 at java.awt.Component.processEvent(Unknown Source)
 at java.awt.Container.processEvent(Unknown Source)
 at java.awt.Component.dispatchEventImpl(Unknown Source)
 at java.awt.Container.dispatchEventImpl(Unknown Source)
 at java.awt.Component.dispatchEvent(Unknown Source)
 at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
 at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
 at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
 at java.awt.Container.dispatchEventImpl(Unknown Source)
 at java.awt.Window.dispatchEventImpl(Unknown Source)
 at java.awt.Component.dispatchEvent(Unknown Source)
 at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
 at java.awt.EventQueue.access$500(Unknown Source)
 at java.awt.EventQueue$3.run(Unknown Source)
 at java.awt.EventQueue$3.run(Unknown Source)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
 at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
 at java.awt.EventQueue$4.run(Unknown Source)
 at java.awt.EventQueue$4.run(Unknown Source)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
 at java.awt.EventQueue.dispatchEvent(Unknown Source)
 at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
 at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
 at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
 at java.awt.WaitDispatchSupport$2.run(Unknown Source)
 at java.awt.WaitDispatchSupport$4.run(Unknown Source)
 at java.awt.WaitDispatchSupport$4.run(Unknown Source)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.awt.WaitDispatchSupport.enter(Unknown Source)
 at java.awt.Dialog.show(Unknown Source)
 at java.awt.Component.show(Unknown Source)
 at java.awt.Component.setVisible(Unknown Source)
 at java.awt.Window.setVisible(Unknown Source)
 at java.awt.Dialog.setVisible(Unknown Source)
 at com.termalabs.client.ui.admin.EditSchedulerDialog.doCallbackFailure(EditSchedulerDialog.java:1159)
 at com.termalabs.client.ui.admin.EditSchedulerDialog.access$900(EditSchedulerDialog.java:93)
 at com.termalabs.client.ui.admin.EditSchedulerDialog$6.requestFailed(EditSchedulerDialog.java:1099)
 at com.termalabs.client.util.request.RequestUtilities$2.requestFailed(RequestUtilities.java:87)
 at com.termalabs.client.util.request.RequestWorker$1.finished(RequestWorker.java:160)
 at com.termalabs.client.util.SwingWorker$1.run(SwingWorker.java:124)
 at java.awt.event.InvocationEvent.dispatch(Unknown Source)
 at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
 at java.awt.EventQueue.access$500(Unknown Source)
 at java.awt.EventQueue$3.run(Unknown Source)
 at java.awt.EventQueue$3.run(Unknown Source)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
 at java.awt.EventQueue.dispatchEvent(Unknown Source)
 at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
 at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
 at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
 at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
 at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
 at java.awt.EventDispatchThread.run(Unknown Source)

Environment

Release : 6.4.0

Component : AUTOMIC AUTOMATION INTELLIGENCE INTEGRATION FOR AUTOSYS

Resolution

This error will occur if the database user that was added to the AAI Scheduler configuration for this Autosys instance does not have access to read all tables in Autosys.

 

With Oracle, you will usually need to add synonyms for the user in the Autosys database to allow the user to read all of the tables that AAI needs to read.

 

The article below has the full list of synonyms that need to be added:

https://knowledge.broadcom.com/external/article?articleId=194263

 

After adding the synonyms, attempt to add the scheduler again to AAI.