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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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