java.sql.SQLDataException: [Vertica][VJDBC](2035) ERROR: COPY: Input record 657 has been rejected (Field size (67) is corrupted for column 6 (city). It does not fit within the row)

Pentaho BI Platform Tracking | Emanuel Teixeira | 5 months ago
  1. 0

    Open this case from PDI-15001. Need UX feedback if we need to improve the current implementation when user has checked the option Lazy Conversation and then we have this error: {noformat} 2016/07/22 12:07:34 - Vertica Bulk Loader 2.0 - ERROR (version 7.0-QAT-233, build 1 from 2016-07-20 22.13.02 by buildguy) : SQL Error during statement execution. 2016/07/22 12:07:34 - Vertica Bulk Loader 2.0 - ERROR (version 7.0-QAT-233, build 1 from 2016-07-20 22.13.02 by buildguy) : java.sql.SQLDataException: [Vertica][VJDBC](2035) ERROR: COPY: Input record 657 has been rejected (Field size (67) is corrupted for column 6 (city). It does not fit within the row) 2016/07/22 12:07:34 - Vertica Bulk Loader 2.0 - at com.vertica.util.ServerErrorData.buildException(Unknown Source) 2016/07/22 12:07:34 - Vertica Bulk Loader 2.0 - at com.vertica.io.ProtocolStream.readExpectedMessage(Unknown Source) 2016/07/22 12:07:34 - Vertica Bulk Loader 2.0 - at com.vertica.dataengine.VQueryExecutor.readCopyDataResponse(Unknown Source) 2016/07/22 12:07:34 - Vertica Bulk Loader 2.0 - at com.vertica.dataengine.VQueryExecutor.handleExecuteResponse(Unknown Source) 2016/07/22 12:07:34 - Vertica Bulk Loader 2.0 - at com.vertica.dataengine.VQueryExecutor.execute(Unknown Source) 2016/07/22 12:07:34 - Vertica Bulk Loader 2.0 - at com.vertica.jdbc.VerticaCopyStream.execute(Unknown Source) 2016/07/22 12:07:34 - Vertica Bulk Loader 2.0 - at org.pentaho.di.verticabulkload.VerticaBulkLoader$1.run(VerticaBulkLoader.java:266) 2016/07/22 12:07:34 - Vertica Bulk Loader 2.0 - at java.lang.Thread.run(Thread.java:745) 2016/07/22 12:07:34 - Vertica Bulk Loader 2.0 - Caused by: com.vertica.support.exceptions.DataException: [Vertica][VJDBC](2035) ERROR: COPY: Input record 657 has been rejected (Field size (67) is corrupted for column 6 (city). It does not fit within the row) 2016/07/22 12:07:34 - Vertica Bulk Loader 2.0 - ... 8 more {noformat} +Since we know workarounds to solve this error, could we propose user the workarounds?+ *Steps to Reproduce* go to PDI-15001.

    Pentaho BI Platform Tracking | 5 months ago | Emanuel Teixeira
    java.sql.SQLDataException: [Vertica][VJDBC](2035) ERROR: COPY: Input record 657 has been rejected (Field size (67) is corrupted for column 6 (city). It does not fit within the row)

    Root Cause Analysis

    1. com.vertica.support.exceptions.DataException

      [Vertica][VJDBC](2035) ERROR: COPY: Input record 657 has been rejected (Field size (67) is corrupted for column 6 (city). It does not fit within the row)

      at com.vertica.util.ServerErrorData.buildException()
    2. com.vertica.util
      ServerErrorData.buildException
      1. com.vertica.util.ServerErrorData.buildException(Unknown Source)
      1 frame
    3. com.vertica.io
      ProtocolStream.readExpectedMessage
      1. com.vertica.io.ProtocolStream.readExpectedMessage(Unknown Source)
      1 frame
    4. com.vertica.dataengine
      VQueryExecutor.execute
      1. com.vertica.dataengine.VQueryExecutor.readCopyDataResponse(Unknown Source)
      2. com.vertica.dataengine.VQueryExecutor.handleExecuteResponse(Unknown Source)
      3. com.vertica.dataengine.VQueryExecutor.execute(Unknown Source)
      3 frames
    5. com.vertica.jdbc
      VerticaCopyStream.execute
      1. com.vertica.jdbc.VerticaCopyStream.execute(Unknown Source)
      1 frame
    6. org.pentaho.di
      VerticaBulkLoader$1.run
      1. org.pentaho.di.verticabulkload.VerticaBulkLoader$1.run(VerticaBulkLoader.java:266)
      1 frame
    7. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame