My Oracle Support Banner

Intermittent "com.sunopsis.dwg.SQLWorkReposException: The connection is closed" Error Using ODI Studio (Doc ID 2485825.1)

Last updated on MAY 18, 2020

Applies to:

Oracle Data Integrator - Version 12.2.1.2.6 and later
Information in this document applies to any platform.

Symptoms

While using Oracle Data Integrator (ODI) Studio to develop, the following error occurs.

java.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.AbsCefNode.getLongLabel(AbsCefNode.java:109)
  at oracle.ideri.navigator.DefaultNavigatorWindow.updateStatusBar(DefaultNavigatorWindow.java:1222)
  at oracle.ideri.navigator.DefaultNavigatorWindow.access$200(DefaultNavigatorWindow.java:122)
  at oracle.ideri.navigator.DefaultNavigatorWindow$3.viewSelectionChanged(DefaultNavigatorWindow.java:261)
  at oracle.ide.view.View.fireViewSelectionChangedImpl(View.java:493)
  at oracle.ide.view.ViewDecorator.fireViewSelectionChangedImpl(ViewDecorator.java:69)
  at oracle.ide.view.View.fireViewSelectionChanged(View.java:483)
  at oracle.ide.view.View.updateSelectionImpl0(View.java:442)
  at oracle.ide.view.View.updateSelectionImpl(View.java:427)
  at oracle.ide.view.View.updateSelection(View.java:306)
  at oracle.ideri.navigator.DefaultNavigatorWindow$5.viewSelectionChanged(DefaultNavigatorWindow.java:1200)
  at oracle.ide.view.View.fireViewSelectionChangedImpl(View.java:493)
  at oracle.ide.view.View.fireViewSelectionChanged(View.java:483)
  at oracle.ide.view.View$2.actionPerformed(View.java:349)
  at javax.swing.Timer.fireActionPerformed(Timer.java:313)
  ...
Caused by: java.lang.reflect.InvocationTargetException
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  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)
  ... 36 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.GeneratedSnpProject.getObjectByIdent(GeneratedSnpProject.java:468)
  ... 41 more

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.