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

Pentaho Vertica Bulk Load Error IllegalArgumentException

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 4.4.1, 5.0.6 GA
    • Fix Version/s: 5.1.0 GA
    • Component/s: Step
    • Labels:
    • Environment:
      Windows 2008 Server
      pdi-ce-4.4.0-r1, PDI EE 5.0.6
      VerticaBulkLoader-TRUNK-SNAPSHOT.zip
    • Story Points:
      3
    • 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
    • Operating System/s:
      Windows 7

      Description

      I am trying to use the new Pentaho Vertica Bulk loader and it seems to work fine for most of my tables but for this particular table I get IllegalArgumentException

      Lead Acceptance (String) to target column Lead_Acceptance (VARCHAR)
      2013/05/17 11:24:55 - Vertica Bulk Loader.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : Unexpected error
      2013/05/17 11:24:55 - Vertica Bulk Loader.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : java.lang.IllegalArgumentException
      2013/05/17 11:24:55 - Vertica Bulk Loader.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at java.nio.ByteBuffer.allocate(Unknown Source)
      2013/05/17 11:24:55 - Vertica Bulk Loader.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at com.vertica.jdbc.nativebinary.StreamEncoder.<init>(StreamEncoder.java:89)
      2013/05/17 11:24:55 - Vertica Bulk Loader.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at plugin.com.vertica.kettle.bulkloader.VerticaBulkLoader.processRow(VerticaBulkLoader.java:136)
      2013/05/17 11:24:55 - Vertica Bulk Loader.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
      2013/05/17 11:24:55 - Vertica Bulk Loader.0 - ERROR (version 4.4.0, build 1 from 2012-09-19 16.37.26 by buildguy) : at java.lang.Thread.run(Unknown Source)

      I will include a jdbc stack trace and pentaho log.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              ihar_chekan Ihar Chekan (Inactive)
              Reporter:
              mwarner@vertica.com mark warner
              Votes:
              1 Vote for this issue
              Watchers:
              9 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 28h
                  28h