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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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