Error after loading Excel file

MaxIT — Fri, 15 Nov 2024 21:57:46 GMT

Hi, I created a job loading several Excel files. It works for most of them while for few of them , I do not notice any difference in structure, I receive the following error after the file data are loaded in a SQL table:

Starting job STEP1_fm_ExcelProtected_to_ODS_DatiProd at 15:44 23/03/2023.

[statistics] connecting to socket on port 3821

[statistics] connected

Exception in component tFileInputExcel_1 (STEP1_fm_ExcelProtected_to_ODS_DatiProd)

org.apache.poi.EmptyFileException: The supplied file was empty (zero bytes long)

at org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.java:215)

at org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.java:170)

at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:322)

at trasportiromagna.step1_fm_excelprotected_to_ods_datiprod_0_1.STEP1_fm_ExcelProtected_to_ODS_DatiProd.tFileList_2Process(STEP1_fm_ExcelProtected_to_ODS_DatiProd.java:2715)

at trasportiromagna.step1_fm_excelprotected_to_ods_datiprod_0_1.STEP1_fm_ExcelProtected_to_ODS_DatiProd.tFileList_1Process(STEP1_fm_ExcelProtected_to_ODS_DatiProd.java:1313)

at trasportiromagna.step1_fm_excelprotected_to_ods_datiprod_0_1.STEP1_fm_ExcelProtected_to_ODS_DatiProd.tDBRow_1Process(STEP1_fm_ExcelProtected_to_ODS_DatiProd.java:984)

at trasportiromagna.step1_fm_excelprotected_to_ods_datiprod_0_1.STEP1_fm_ExcelProtected_to_ODS_DatiProd.tDBConnection_1Process(STEP1_fm_ExcelProtected_to_ODS_DatiProd.java:826)

at trasportiromagna.step1_fm_excelprotected_to_ods_datiprod_0_1.STEP1_fm_ExcelProtected_to_ODS_DatiProd.runJobInTOS(STEP1_fm_ExcelProtected_to_ODS_DatiProd.java:7683)

at trasportiromagna.step1_fm_excelprotected_to_ods_datiprod_0_1.STEP1_fm_ExcelProtected_to_ODS_DatiProd.main(STEP1_fm_ExcelProtected_to_ODS_DatiProd.java:7500)

[statistics] disconnected

Job STEP1_fm_ExcelProtected_to_ODS_DatiProd ended at 15:44 23/03/2023. [Exit code = 1]

Any clue?

Thanks,

Max

Re: Error after loading Excel file

Anonymous — Fri, 24 Mar 2023 02:00:29 GMT

Hello Max,

Regarding to the error log, seems there is something wrong with some of your excel files.

Could you please design a simple job as the below

use tJava component to find out the bad excel files

System.out.println(globalMap.get("tFileList_1_CURRENT_FILEPATH"));

BTW: the above simple job work fine in my side

topic Error after loading Excel file in Talend Data Catalog

Error after loading Excel file

Re: Error after loading Excel file