Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

java.lang.RuntimeException: java.lang.reflect.InvocationTargetException ,SQLWorkReposException: The

2709933Oct 13 2017 — edited Nov 5 2017

Hi ,

We are using ODI 12.2.1.2.6

After open ODI studio, if we keep idle for more than 90 min, we are getting below exceptions, Maybe this is the cause of the error or not exactly I do not know.

Could you please help how to fix this issue.

ava.lang.RuntimeException: java.lang.reflect.InvocationTargetException

at com.sunopsis.graphical.gbo.DwgBasicGBObject.createAssociatedBusinessObject(DwgBasicGBObject.java:339)

at com.sunopsis.graphical.gbo.DwgBasicGBObject.getMainObject(DwgBasicGBObject.java:605)

at oracle.odi.window.node.OdiNodeFactory.computeEditorTitle(OdiNodeFactory.java:1274)

at oracle.odi.window.node.OdiNavTreeNode.getEditorTitle(OdiNavTreeNode.java:1340)

at oracle.cef.ui.component.window.node.AbsCefNode.getShortLabel(AbsCefNode.java:97)

at oracle.cef.ui.component.window.node.CefModelerNode.getShortLabel(CefModelerNode.java:163)

at oracle.ide.editor.Editor.getTabLabel(Editor.java:260)

at com.oracle.jdeveloper.nbwindowsystem.NbEditorContainer$4.run(NbEditorContainer.java:645)

at com.oracle.jdeveloper.nbwindowsystem.NbEditorContainer.updateEditorTab(NbEditorContainer.java:655)

at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.handleEditorEvent(NbEditorManager.java:1303)

at com.oracle.jdeveloper.nbwindowsystem.NbEditorContainer.notifyEditorManager(NbEditorContainer.java:521)

at com.oracle.jdeveloper.nbwindowsystem.NbEditorContainer.componentActivated(NbEditorContainer.java:436)

at org.openide.windows.WindowManager.activateComponent(WindowManager.java:291)

at org.netbeans.core.windows.WindowManagerImpl.notifyRegistryTopComponentActivated(WindowManagerImpl.java:1171)

at org.netbeans.core.windows.Central.setActiveMode(Central.java:258)

at org.netbeans.core.windows.Central.userActivatedMode(Central.java:1901)

at org.netbeans.core.windows.view.DefaultView.userActivatedModeView(DefaultView.java:668)

at org.netbeans.core.windows.view.ui.TabbedHandler$ActivationManager.handleActivation(TabbedHandler.java:548)

at org.netbeans.core.windows.view.ui.TabbedHandler$ActivationManager.eventDispatched(TabbedHandler.java:495)

at java.awt.Toolkit$SelectiveAWTEventListener.eventDispatched(Toolkit.java:2425)

at java.awt.Toolkit$ToolkitEventMulticaster.eventDispatched(Toolkit.java:2317)

at java.awt.Toolkit$ToolkitEventMulticaster.eventDispatched(Toolkit.java:2316)

at java.awt.Toolkit.notifyAWTEventListeners(Toolkit.java:2275)

at java.awt.Component.dispatchEventImpl(Component.java:4785)

at java.awt.Container.dispatchEventImpl(Container.java:2294)

at java.awt.Component.dispatchEvent(Component.java:4711)

at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)

at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4522)

at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)

at java.awt.Container.dispatchEventImpl(Container.java:2280)

at java.awt.Window.dispatchEventImpl(Window.java:2746)

at java.awt.Component.dispatchEvent(Component.java:4711)

at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)

at java.awt.EventQueue.access$500(EventQueue.java:97)

at java.awt.EventQueue$3.run(EventQueue.java:709)

at java.awt.EventQueue$3.run(EventQueue.java:703)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)

at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:90)

at java.awt.EventQueue$4.run(EventQueue.java:731)

at java.awt.EventQueue$4.run(EventQueue.java:729)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)

at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)

at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)

at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)

at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)

at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)

at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)

Caused by: java.lang.reflect.InvocationTargetException

at sun.reflect.GeneratedMethodAccessor249.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at com.sunopsis.graphical.gbo.DwgBasicGBObject.createAssociatedBusinessObject(DwgBasicGBObject.java:330)

... 104 more

Caused by: com.sunopsis.dwg.SQLWorkReposException: The connection is closed: The connection is closed

at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:464)

at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:448)

at oracle.ucp.jdbc.proxy.JDBCConnectionProxyFactory.invoke(JDBCConnectionProxyFactory.java:307)

at oracle.ucp.jdbc.proxy.ConnectionProxyFactory.invoke(ConnectionProxyFactory.java:50)

at com.sun.proxy.$Proxy30.getAutoCommit(Unknown Source)

at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at oracle.odi.core.datasource.support.RuntimeClassLoaderDataSourceCreator$ConnectionInvocationHandler.invoke(RuntimeClassLoaderDataSourceCreator.java:132)

at com.sun.proxy.$Proxy31.getAutoCommit(Unknown Source)

at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at com.sunopsis.sql.SnpsConnection$ConnectionProxyInvocationHandler.invoke(SnpsConnection.java:143)

at com.sun.proxy.$Proxy34.getAutoCommit(Unknown Source)

at com.sunopsis.sql.SnpsConnection.connect(SnpsConnection.java:499)

at com.sunopsis.sql.SnpsQuery.updateExecStatement(SnpsQuery.java:1734)

at com.sunopsis.sql.SnpsQuery.executeQuery(SnpsQuery.java:590)

at com.sunopsis.dwg.dbobj.generated.GeneratedSnpMapping.getObjectByIdent(GeneratedSnpMapping.java:713)

... 108 more

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 3 2017

Added on Oct 13 2017

#business-intelligence-applications, #data-integrator, #system-management-and-integration

2 comments

736 views