Error - tVerticaOutputBulkExec component - MySQL 2 Vertica migration
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.
Hi Sabrina,
I have a problem with a compenent (tFileOutputExcel_5). My job Talend, recovers data from two Excel files and puts the result into another excel file. merging the two files is by tmap.
the error is:
Exception in component tFileOutputExcel_5
jxl.write.biff.RowsExceededException: The maximum number of rows permitted on a worksheet been exceeded
at jxl.write.biff.WritableSheetImpl.getRowRecord(WritableSheetImpl.java:1070)
at jxl.write.biff.WritableSheetImpl.addCell(WritableSheetImpl.java:1046)
Can you help me?
Marwa
jxl.write.biff.RowsExceededException: The maximum number of rows permitted on a worksheet been exceeded
The exception imply that when loading data to the Excel table, the data exceeds the maximum capacity of excel table.
How much data loaded into excel?
The maximum of Excel table should be 65,536 rows.
Best regards
Sabrina
Hi,
I'm have run the job which is like this tFileList->tFileInputDelimited->tMap->tSortRow->tUniqRow->tVerticaOutput.
Problem : it is inserting a 18 files rows to vertica table but after that its giving following error.
Exception in component tMap_1
java.lang.NullPointerException
at java.text.SimpleDateFormat.parse(SimpleDateFormat.java:1380)
at java.text.DateFormat.parse(DateFormat.java:355)
at routines.TalendDate.parseDate(TalendDate.java:816)
at gnh.ip_bill_load_vertica_0_1.IP_BILL_LOAD_VERTICA.tFileList_1Process(IP_BILL_LOAD_VERTICA.java:9036)
at gnh.ip_bill_load_vertica_0_1.IP_BILL_LOAD_VERTICA.runJobInTOS(IP_BILL_LOAD_VERTICA.java:11219)
at gnh.ip_bill_load_vertica_0_1.IP_BILL_LOAD_VERTICA.main(IP_BILL_LOAD_VERTICA.java:11087)
I have checked null value for date in tMap, so im not getting for what reason this error is!! can anybody help please??
Regards,
akki
Hi, Is there any compile error in your job? If so, you should switch "Design" to "Code" in studio to see what's error in java code. Then correct your component setting to fix this issue. The component setting screenshots will be preferred. In addition that, it suggest you should open a new topic for issue so that other community users have chance to give a help. Best regards Sabrina
