java.sql.SQLDataException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 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.
    via by 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) at com.vertica.util.ServerErrorData.buildException(Unknown Source) at com.vertica.io.ProtocolStream.readExpectedMessage(Unknown Source) at com.vertica.dataengine.VQueryExecutor.readCopyDataResponse(Unknown Source) at com.vertica.dataengine.VQueryExecutor.handleExecuteResponse(Unknown Source) at com.vertica.dataengine.VQueryExecutor.execute(Unknown Source) at com.vertica.jdbc.VerticaCopyStream.execute(Unknown Source) at org.pentaho.di.verticabulkload.VerticaBulkLoader$1.run(VerticaBulkLoader.java:266) at java.lang.Thread.run(Thread.java:745) 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) ... 8 more
    No Bugmate found.