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)
Release : 6.4.0
Component : AUTOMIC AUTOMATION INTELLIGENCE INTEGRATION FOR AUTOSYS
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.