Forum Stats

  • 3,826,800 Users
  • 2,260,708 Discussions
  • 7,897,074 Comments

Discussions

ODI Java Heap Error

SuddhasatwaBhaumik
SuddhasatwaBhaumik Member Posts: 17
edited Sep 10, 2015 12:40AM in Data Integrator

Hello All,

While trying to connect to the Hive topology, I am getting the below error, which refers to increase in the Java heap size.

I am using Windows 8.1 on laptop where this testing is being done. In the OS settings, I have already increased the -Xmx settings to 2048m.

The error message / stack trace is as under:

java.lang.RuntimeException: java.lang.OutOfMemoryError: Java heap space

  at oracle.odi.ui.framework.adapter.DefaultAdapter.executeBackgroundTask(DefaultAdapter.java:611)

  at oracle.odi.ui.framework.UIFramework.executeBackgroundTask(UIFramework.java:354)

  at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.localConnect(SnpsDialogTestConnet.java:512)

  at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.dialogOkActionHook(SnpsDialogTestConnet.java:86)

  at com.sunopsis.graphical.definition.DialogDefinitionNode$1.vetoableChange(DialogDefinitionNode.java:407)

  at java.beans.VetoableChangeSupport.fireVetoableChange(VetoableChangeSupport.java:335)

  at java.beans.VetoableChangeSupport.fireVetoableChange(VetoableChangeSupport.java:252)

  at oracle.bali.ewt.dialog.JEWTDialog.fireVetoableChange(JEWTDialog.java:1530)

  at oracle.bali.ewt.dialog.JEWTDialog.dismissDialog(JEWTDialog.java:1560)

  at oracle.bali.ewt.dialog.JEWTDialog$UIListener.actionPerformed(JEWTDialog.java:1961)

  at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)

  at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)

  at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)

  at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)

  at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)

  at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)

  at java.awt.Component.processMouseEvent(Component.java:6297)

  at javax.swing.JComponent.processMouseEvent(JComponent.java:3275)

  at java.awt.Component.processEvent(Component.java:6062)

  at java.awt.Container.processEvent(Container.java:2039)

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

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

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

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

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

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

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

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

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

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

  at java.awt.EventQueue.access$400(EventQueue.java:81)

  at java.awt.EventQueue$2.run(EventQueue.java:633)

  at java.awt.EventQueue$2.run(EventQueue.java:631)

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

  at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)

  at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)

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

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

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

  at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)

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

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

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

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

  at java.awt.Dialog$1.run(Dialog.java:1052)

  at java.awt.Dialog$3.run(Dialog.java:1104)

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

  at java.awt.Dialog.show(Dialog.java:1102)

  at java.awt.Component.show(Component.java:1591)

  at java.awt.Component.setVisible(Component.java:1543)

  at java.awt.Window.setVisible(Window.java:843)

  at java.awt.Dialog.setVisible(Dialog.java:987)

  at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:395)

  at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:356)

  at oracle.odi.ui.framework.adapter.DefaultAdapter.displayDialog(DefaultAdapter.java:242)

  at oracle.odi.ui.framework.UIFramework.displayDialog(UIFramework.java:90)

  at com.sunopsis.graphical.frame.edit.EditFrameSnpConnect.jButtonTest_ActionEvents(EditFrameSnpConnect.java:2156)

  at com.sunopsis.graphical.frame.SnpsEditFrame$IvjEventHandler.actionPerformed(SnpsEditFrame.java:204)

  at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)

  at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)

  at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)

  at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)

  at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)

  at java.awt.Component.processMouseEvent(Component.java:6297)

  at javax.swing.JComponent.processMouseEvent(JComponent.java:3275)

  at java.awt.Component.processEvent(Component.java:6062)

  at java.awt.Container.processEvent(Container.java:2039)

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

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

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

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

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

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

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

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

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

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

  at java.awt.EventQueue.access$400(EventQueue.java:81)

  at java.awt.EventQueue$2.run(EventQueue.java:633)

  at java.awt.EventQueue$2.run(EventQueue.java:631)

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

  at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)

  at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)

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

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

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

  at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)

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

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

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

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

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

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

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

Caused by: java.lang.OutOfMemoryError: Java heap space

  at org.apache.thrift.transport.TSaslTransport.receiveSaslMessage(TSaslTransport.java:181)

  at org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:288)

  at org.apache.thrift.transport.TSaslClientTransport.open(TSaslClientTransport.java:37)

  at org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:203)

  at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:178)

  at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)

  at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:410)

  at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:386)

  at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:353)

  at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:332)

  at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run(LoginTimeoutDatasourceAdapter.java:217)

  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)

  at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

  at java.util.concurrent.FutureTask.run(FutureTask.java:138)

  at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)

  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)

  at java.lang.Thread.run(Thread.java:662)

Kindly advise if anyone of you has faced similar issues with ODI, in which case, if anyone can advise for a solution.

Thanks

Suddhasatwa

Tagged:

Answers

  • mmtn_jy
    mmtn_jy Member Posts: 101
    edited Sep 10, 2015 12:36AM

    Hi,

    Please try to change the ODI_INIT_HEAP and ODI_MAX_HEAP values in odi parameter file (odiparams.bat). Set these variables to a higher value. This should help increase heap size.

    Thanks,

    Ajay

    SuddhasatwaBhaumik
  • SuddhasatwaBhaumik
    SuddhasatwaBhaumik Member Posts: 17
    edited Sep 10, 2015 12:40AM

    Hello Ajay

    Thanks for your helpful answer.

    I now have the below settings in odiparams.bat file:

    set ODI_INIT_HEAP=1024m

    set ODI_MAX_HEAP=1024m

    I am not able to increase the max heap value beyond 1024M since it is giving error while starting the agent.

    However, this did not resolve the matter. The original error still persists.

    Regards

    Suddhasatwa

This discussion has been closed.