Error - tVerticaOutputBulkExec component - MySQL 2 Vertica migration

[Anonymous]

We are using Talend 4.2.2r63143 enterprice edition, stuck up with the below Exception.
Exception in component tVerticaOutputBulkExec_1_tVBE
com.vertica.util.PSQLException: Something unusual has occured to cause the driver to fail. Please report this exception.
at com.vertica.Driver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at dev_sam.j_mysql_2_vertica_error_0_1.j_MySQL_2_Vertica_Error.tMysqlInput_1Process(j_MySQL_2_Vertica_Error.java:988)
at dev_sam.j_mysql_2_vertica_error_0_1.j_MySQL_2_Vertica_Error.runJobInTOS(j_MySQL_2_Vertica_Error.java:1268)
at dev_sam.j_mysql_2_vertica_error_0_1.j_MySQL_2_Vertica_Error.main(j_MySQL_2_Vertica_Error.java:1142)
Caused by: java.lang.NullPointerException
at com.vertica.core.v3.QueryExecutorImpl.receiveRFQ(Unknown Source)
at com.vertica.core.v3.QueryExecutorImpl.processResults(Unknown Source)
at com.vertica.core.v3.QueryExecutorImpl.execute(Unknown Source)
at com.vertica.core.v3.ConnectionFactoryImpl.runSetupQuery(Unknown Source)
at com.vertica.core.v3.ConnectionFactoryImpl.runInitialQueries(Unknown Source)
disconnected
at com.vertica.core.v3.ConnectionFactoryImpl.openConnectionImpl(Unknown Source)
at com.vertica.core.ConnectionFactory.openConnection(Unknown Source)
at com.vertica.jdbc2.AbstractJdbc2Connection.<init>(Unknown Source)
at com.vertica.jdbc3.AbstractJdbc3Connection.<init>(Unknown Source)
at com.vertica.jdbc3g.Jdbc3gConnection.<init>(Unknown Source)
at com.vertica.Driver.makeConnection(Unknown Source)
... 6 more
Job j_MySQL_2_Vertica_Error ended at 04:15 10/05/2013.

[_AnonymousUser]

I am trying to use tVerticaOutputBulkExec component. It is throwing the error "No record was loaded into component tVerticaOutputBulkExec". tVerticaOutput component is working properly. I am using Talend 5.4 and for date format, I handled it separately.
Any lights on the error?

[jerownimow]

Hi Folks,

Is there already a light on this? I'm encountering the same problem. Seems that there were no rows loaded when there are fields that has blanks or null values.

In this way, we can add a tmap to transform those fields, but I'm not getting the correct syntax, I tried to add the below logic, but I'm encountering a java.lang.IllegalArgumentException: java.lang.ClassCastException.

(row2.moneyback_credit==null)||("".equals(row2.moneyback_credit))?1:row2.moneyback_credit 

Datatype of this field is decimal. Can you share with me your inputs?

Thank you.