Exception: No record was loaded into component

Anonymous — Fri, 02 Oct 2015 18:57:28 GMT

Talend Enterprise Data Integration Administration Center
Version 5.5.1.118616

Simple job of moving data from MySQL to Vertica
tVerticaConnection -> tMysqlInput --> tVerticaOutputBulkExec

Exception in component tVerticaOutputBulkExec_1_tVBE
java.lang.RuntimeException: No record was loaded into component tVerticaOutputBulkExec_1_tVBE
   at talend_v55.vertica_init2_0_1.vertica_init2.tMysqlInput_5Process(vertica_init2.java:3900)
   at talend_v55.vertica_init2_0_1.vertica_init2.tVerticaRow_2Process(vertica_init2.java:719)
   at talend_v55.vertica_init2_0_1.vertica_init2.tVerticaConnection_2Process(vertica_init2.java:513)
   at talend_v55.vertica_init2_0_1.vertica_init2.runJobInTOS(vertica_init2.java:4710)
   at talend_v55.vertica_init2_0_1.vertica_init2.main(vertica_init2.java:4547)

I tried replacing tVerticaOutputBulkExec with tVerticaOutput, that worked.
[color=#000000][font=arial, helvetica, sans-serif]I tried tlogrow, the dataflow was normal.[/font][/color]
[color=#000000][font=arial, helvetica, sans-serif]I checked the data, there are no NULLs.[/font][/color]
I tried replacing tVerticaOutputBulkExec with tVerticaOutputBulk and tVerticaBulkExec, that gave the same error.

Re: Exception: No record was loaded into component

Anonymous — Thu, 08 Oct 2015 04:07:35 GMT

Hi davidjhp,
There is somthing wrong with your bulk insert. Have you already checked document about: TalendHelpCenter:Installing database client software (for bulk mode)?

Best regards
Sabrina

topic Re: Exception: No record was loaded into component in Talend Studio

Exception: No record was loaded into component

Re: Exception: No record was loaded into component