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.

[Anonymous]

Hi,
There is a Null Pointer Exception. Could you please give us your work flow and component setting screenshots so that we can address your issue quickly.
Please see the online component reference: tVerticaOutputBulkExec

Best regards
Sabrina

[Anonymous]

I am trying to connect to Vertica 6, but in the component i am able to see only Version till 4.1. I have attached the Job Screen shot.
The flow is like below
tMySQL=>tMap=>tVerticaOutputBulkExec.
MySQL and vertica DBs are in different Network

[Anonymous]

Hi,

We are using Talend 4.2.2r63143 enterprice edition

The version 4.2.2 you are using is very old. Vertica 6 is supported since version 5.0, please download the latest version 5.3.0 and test if it works, if you want to upgrade product, please report a ticket in support portal, our colleagues will help you and show you the detailed instructions.
Best regards
Sabrina

[_AnonymousUser]

hi

Im getting below exception when using vertica component ,the job flow is
tfileinputdelimited--->tmap--->tsort---->tuniqrow---->tvericaoutputbulkexec

Exception in component tVerticaOutputBulkExec_2_tVBE
java.lang.RuntimeException: No record was loaded into component tVerticaOutputBulkExec_2_tVBE
at master_project.ip_bill_cdr_6a_0_1.IP_BILL_CDR_6a.tFileList_1Process(IP_BILL_CDR_6a.java:10707)
at master_project.ip_bill_cdr_6a_0_1.IP_BILL_CDR_6a.runJobInTOS(IP_BILL_CDR_6a.java:11625)
at master_project.ip_bill_cdr_6a_0_1.IP_BILL_CDR_6a.main(IP_BILL_CDR_6a.java:11493)

[Anonymous]

Hi,
From the error "No record was loaded into component tVerticaOutputBulkExec", it seems there is no processed row in the work flow.
Did you use tlogrow to take a testing in order to see if the data is normal?
Best regards
Sabrina

[_AnonymousUser]

hi sabrina,

Yes, i checked it with tlogrow the dataflow is normal.

[Anonymous]

Hi,
That means something wrong with the setting of tVerticaOutputBulkExec. Is it OK for tVerticaOutput?
A trouble screenshot will be helpful.
In addition, while using tVerticaOutputBulkExec, be sure to set the right field delimitor(default is ";") according to the source data file.

Best regards
Sabrina

[_AnonymousUser]

hi,
I tried with tverticaoutput the data is getting inserted properly ,i dont know why bulk loading is not working im not able to upload images

[Anonymous]

Hi,
You should register and log in as a Community member first, then you'll get a Image upload box that allows to upload screen captures and images up to 200KB.
For registered users, please click on "post reply" (not through the quick post").
Best regards
Sabrina