Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-8680

when using the odbc jdbc bridge with vertica get a stack trace

    XMLWordPrintable

    Details

    • Story Points:
      8
    • PDI Sub-component:
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Sprint Team:
      Pervach

      Description

      The odbc/jdbc bridge gets a stack trace when using the Vertica as a databse.

      Error connecting to database [vertica51odbc] : org.pentaho.di.core.exception.KettleDatabaseException:
      Error occured while trying to connect to the database

      Error connecting to database: (using class sun.jdbc.odbc.JdbcOdbcDriver)
      [Microsoft][ODBC Driver Manager] Invalid string or buffer length

      org.pentaho.di.core.exception.KettleDatabaseException:
      Error occured while trying to connect to the database

      Error connecting to database: (using class sun.jdbc.odbc.JdbcOdbcDriver)
      [Microsoft][ODBC Driver Manager] Invalid string or buffer length

      at org.pentaho.di.core.database.Database.normalConnect(Database.java:366)
      at org.pentaho.di.core.database.Database.connect(Database.java:315)
      at org.pentaho.di.core.database.Database.connect(Database.java:277)
      at org.pentaho.di.core.database.Database.connect(Database.java:267)
      at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:86)
      at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2464)
      at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.test(DatabaseDialog.java:120)
      at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizardPage2.test(CreateDatabaseWizardPage2.java:167)
      at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizardPage2$3.widgetSelected(CreateDatabaseWizardPage2.java:156)
      at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
      at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
      at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
      at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
      at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
      at org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
      at org.eclipse.jface.window.Window.open(Window.java:796)
      at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizard.createAndRunDatabaseWizard(CreateDatabaseWizard.java:124)
      at org.pentaho.di.ui.spoon.Spoon.createDatabaseWizard(Spoon.java:6680)
      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.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
      at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)
      at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
      at org.pentaho.ui.xul.swt.tags.SwtMenuitem.access$100(SwtMenuitem.java:27)
      at org.pentaho.ui.xul.swt.tags.SwtMenuitem$1.widgetSelected(SwtMenuitem.java:77)
      at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
      at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
      at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
      at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
      at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
      at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1225)
      at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:7025)
      at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:574)
      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.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
      Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
      Error connecting to database: (using class sun.jdbc.odbc.JdbcOdbcDriver)
      [Microsoft][ODBC Driver Manager] Invalid string or buffer length

      at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:502)
      at org.pentaho.di.core.database.Database.normalConnect(Database.java:350)
      ... 39 more
      Caused by: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid string or buffer length
      at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
      at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
      at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(Unknown Source)
      at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(Unknown Source)
      at sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)
      at sun.jdbc.odbc.JdbcOdbcConnection.buildTypeInfo(Unknown Source)
      at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
      at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
      at java.sql.DriverManager.getConnection(Unknown Source)
      at java.sql.DriverManager.getConnection(Unknown Source)
      at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:482)
      ... 40 more

      Hostname :
      Port :
      Database name : vertica51

        Attachments

          Activity

            People

            Assignee:
            dzmitry_stsiapanau Dzmitry Stsiapanau (Inactive)
            Reporter:
            mwarner@vertica.com mark warner
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: