Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Exception: No record was loaded into component

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.

Labels (2)
1 Reply
Anonymous
Not applicable
Author

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