[Fiware-creatifi-coaching] [CreatiFI Barcelona Hub] General Support #392: Connect to Hive - Connection Refused

[Gerard Castillo Lasheras]

Hi,

an applicant has reported the following high priority issue:

*Hi! *

*We are connecting SpagoBI to Cosmos via
jdbc:hive://cosmos.lab.fi-ware.org:10000/default
<http://cosmos.lab.fi-ware.org:10000/default> and sometimes it works and
sometimes we get the exception below. Is there a quota by day or If I made
"many" invalid connections it just banned the connections from that IP for
a period of time...*

*The exception below is using SpagoBI Studio, using SpagoBI Web application
I have the same exception Connection refused, but with other StackTrace.*

*org.eclipse.birt.report.data.**oda.jdbc.JDBCException: There is an
error in get connection, Could not establish connection to
cosmos.lab.fi-ware.org:10000/default
<http://cosmos.lab.fi-ware.org:10000/default>:
java.net.ConnectException: Connection refused: connect.
    at org.eclipse.birt.report.data.**oda.jdbc.JDBCDriverManager.**doConnect(JDBCDriverManager.**java:303)
    at org.eclipse.birt.report.data.**oda.jdbc.JDBCDriverManager.**getConnection(**JDBCDriverManager.java:205)
    at org.eclipse.birt.report.data.**oda.jdbc.JDBCDriverManager.**tryCreateConnection(**JDBCDriverManager.java:787)
    at org.eclipse.birt.report.data.**oda.jdbc.JDBCDriverManager.**testConnection(**JDBCDriverManager.java:708)
    at org.eclipse.birt.report.data.**oda.jdbc.ui.util.DriverLoader.**testConnection(DriverLoader.**java:147)
    at org.eclipse.birt.report.data.**oda.jdbc.ui.util.DriverLoader.**testConnection(DriverLoader.**java:175)
    at org.eclipse.birt.report.data.**oda.jdbc.ui.util.DriverLoader.**testConnection(DriverLoader.**java:156)
    at org.eclipse.birt.report.data.**oda.jdbc.ui.profile.**JDBCSelectionPageHelper.**testConnection(**JDBCSelectionPageHelper.java:**729)
    at org.eclipse.birt.report.data.**oda.jdbc.ui.profile.**JDBCSelectionPageHelper.**access$8(**JDBCSelectionPageHelper.java:**697)
    at org.eclipse.birt.report.data.**oda.jdbc.ui.profile.**JDBCSelectionPageHelper$8.**widgetSelected(**JDBCSelectionPageHelper.java:**620)
    at org.eclipse.swt.widgets.**TypedListener.handleEvent(**TypedListener.java:234)
    at org.eclipse.swt.widgets.**EventTable.sendEvent(**EventTable.java:84)
    at org.eclipse.swt.widgets.**Widget.sendEvent(Widget.java:**1053)
    at org.eclipse.swt.widgets.**Display.runDeferredEvents(**Display.java:4066)
    at org.eclipse.swt.widgets.**Display.readAndDispatch(**Display.java:3657)
    at org.eclipse.jface.window.**Window.runEventLoop(Window.**java:825)
    at org.eclipse.jface.window.**Window.open(Window.java:801)
    at org.eclipse.birt.report.**designer.ui.dialogs.**BaseDialog.open(BaseDialog.**java:111)
    at org.eclipse.birt.report.**designer.data.ui.providers.**EditableDataSourceNodeProvider**.performEdit(**EditableDataSourceNodeProvider**.java:73)
    at org.eclipse.birt.report.**designer.internal.ui.views.**DefaultNodeProvider.**performRequest(**DefaultNodeProvider.java:442)
    at org.eclipse.birt.report.**designer.internal.ui.views.**actions.EditAction.doAction(**EditAction.java:90)
    at org.eclipse.birt.report.**designer.internal.ui.views.**actions.AbstractElementAction.**run(AbstractElementAction.**java:70)
    at org.eclipse.birt.report.**designer.internal.ui.views.**RenameListener.doubleClick(**RenameListener.java:214)
    at org.eclipse.jface.viewers.**StructuredViewer$1.run(**StructuredViewer.java:824)
    at org.eclipse.core.runtime.**SafeRunner.run(SafeRunner.**java:42)
    at org.eclipse.ui.internal.**JFaceUtil$1.run(JFaceUtil.**java:49)
    at org.eclipse.jface.util.**SafeRunnable.run(SafeRunnable.**java:175)
    at org.eclipse.jface.viewers.**StructuredViewer.**fireDoubleClick(**StructuredViewer.java:822)
    at org.eclipse.jface.viewers.**AbstractTreeViewer.**handleDoubleSelect(**AbstractTreeViewer.java:1421)
    at org.eclipse.jface.viewers.**StructuredViewer$4.**widgetDefaultSelected(**StructuredViewer.java:1225)
    at org.eclipse.jface.util.**OpenStrategy.**fireDefaultSelectionEvent(**OpenStrategy.java:238)
    at org.eclipse.jface.util.**OpenStrategy.access$0(**OpenStrategy.java:235)
    at org.eclipse.jface.util.**OpenStrategy$1.handleEvent(**OpenStrategy.java:296)
    at org.eclipse.swt.widgets.**EventTable.sendEvent(**EventTable.java:84)
    at org.eclipse.swt.widgets.**Widget.sendEvent(Widget.java:**1053)
    at org.eclipse.swt.widgets.**Display.runDeferredEvents(**Display.java:4066)
    at org.eclipse.swt.widgets.**Display.readAndDispatch(**Display.java:3657)
    at org.eclipse.ui.internal.**Workbench.runEventLoop(**Workbench.java:2640)
    at org.eclipse.ui.internal.**Workbench.runUI(Workbench.**java:2604)
    at org.eclipse.ui.internal.**Workbench.access$4(Workbench.**java:2438)
    at org.eclipse.ui.internal.**Workbench$7.run(Workbench.**java:671)
    at org.eclipse.core.databinding.**observable.Realm.**runWithDefault(Realm.java:332)
    at org.eclipse.ui.internal.**Workbench.**createAndRunWorkbench(**Workbench.java:664)
    at org.eclipse.ui.PlatformUI.**createAndRunWorkbench(**PlatformUI.java:149)
    at org.eclipse.ui.internal.ide.**application.IDEApplication.**start(IDEApplication.java:115)
    at org.eclipse.equinox.internal.**app.EclipseAppHandle.run(**EclipseAppHandle.java:196)
    at org.eclipse.core.runtime.**internal.adaptor.**EclipseAppLauncher.**runApplication(**EclipseAppLauncher.java:110)
    at org.eclipse.core.runtime.**internal.adaptor.**EclipseAppLauncher.start(**EclipseAppLauncher.java:79)
    at org.eclipse.core.runtime.**adaptor.EclipseStarter.run(**EclipseStarter.java:369)
    at org.eclipse.core.runtime.**adaptor.EclipseStarter.run(**EclipseStarter.java:179)
    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 org.eclipse.equinox.launcher.**Main.invokeFramework(Main.**java:620)
    at org.eclipse.equinox.launcher.**Main.basicRun(Main.java:575)
    at org.eclipse.equinox.launcher.**Main.run(Main.java:1408)
*

Regards,
--------------------------------------------------------

 Gerard Castillo Lasheras
  Enginyer de Projectes
  Fundació i2CAT - Unitat Audiovisual
  SkypeID: gerardcl85
  Telf.: +34.93.553.26.30 (530)
--------------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.fiware.org/private/fiware-creatifi-coaching/attachments/20150811/c4fa4029/attachment.html>