tFileExcel-Components 11.0 with Talend Cloud Studio 7.2.1

Anonymous — Thu, 19 Sep 2019 21:42:56 GMT

Hi,

We are using Cloud studio 7.2.1 and one of our parent job contains around 20 subjobs. Only on parent job I am using tFileExcelWorkbookOpen and tFileExcelSheetList from Talend exchange tFileExcel-Components 11.0 developed by J.Lolling . In all subjobs I am using native tFileInputExcel. Any idea what could be the issue? It was working perfectly on studio 7.1.1.

======================Error=================

[statistics] connecting to socket on port 4036 [statistics] connected tFileExcelSheetList_1_SHEET_INDEX: 0 tFileExcelSheetList_1_SHEET_NAME: Rev. History Rev. History tFileExcelSheetList_1_SHEET_INDEX: 1 tFileExcelSheetList_1_SHEET_NAME: 0.Program 0.Program Exception in thread "main" java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Cell.getCellType()Lorg/apache/poi/ss/usermodel/CellType; at programconfig.subjob_program_0_1.subjob_Program.tFileInputExcel_1Process(subjob_Program.java:3965) at programconfig.subjob_program_0_1.subjob_Program.tJava_1Process(subjob_Program.java:1667) at programconfig.subjob_program_0_1.subjob_Program.runJobInTOS(subjob_Program.java:10592) at programconfig.subjob_program_0_1.subjob_Program.runJob(subjob_Program.java:10235) at programconfig.programconfiguration_in_main_job_0_1.ProgramConfiguration_In_Main_job.tFileExcelSheetList_1Process(ProgramConfiguration_In_Main_job.java:8698) at programconfig.programconfiguration_in_main_job_0_1.ProgramConfiguration_In_Main_job.tFileExcelWorkbookOpen_1Process(ProgramConfiguration_In_Main_job.java:2849) at programconfig.programconfiguration_in_main_job_0_1.ProgramConfiguration_In_Main_job.tJava_2Process(ProgramConfiguration_In_Main_job.java:18292) at programconfig.programconfiguration_in_main_job_0_1.ProgramConfiguration_In_Main_job.tFileList_1Process(ProgramConfiguration_In_Main_job.java:18075) at programconfig.programconfiguration_in_main_job_0_1.ProgramConfiguration_In_Main_job.tJava_1Process(ProgramConfiguration_In_Main_job.java:18449) at programconfig.programconfiguration_in_main_job_0_1.ProgramConfiguration_In_Main_job.runJobInTOS(ProgramConfiguration_In_Main_job.java:25397) at programconfig.programconfiguration_in_main_job_0_1.ProgramConfiguration_In_Main_job.main(ProgramConfiguration_In_Main_job.java:24932) [statistics] disconnected [statistics] disconnected [statistics] disconnected [statistics] disconnected [statistics] disconnected

Re: tFileExcel-Components 11.0 with Talend Cloud Studio 7.2.1

fdenis — Fri, 20 Sep 2019 12:50:00 GMT

if subjobs are isolated You have to reopen your excel each time.
be careful about concurrent access to your excel.
maybe the best way is to write excel on only one job using return values of subjobs.

Re: tFileExcel-Components 11.0 with Talend Cloud Studio 7.2.1

Anonymous — Fri, 20 Sep 2019 15:00:12 GMT

Thanks for your response but I am not writing anything to excel , just reading in each subjob. Also I don't think it a concurrency issue.

Re: tFileExcel-Components 11.0 with Talend Cloud Studio 7.2.1

nmodi — Thu, 30 Jul 2020 20:08:47 GMT

we are having same issue with accessing custom component developed by J.Lolling, we are using custom excel component along with talend standard tfileexcelinput in our job

it was working fine with talend 6.4.1 however we migrated to 7.2.1 now & since then we are getting this issue. any idea on the solution?

topic tFileExcel-Components 11.0 with Talend Cloud Studio 7.2.1 in Talend Studio

tFileExcel-Components 11.0 with Talend Cloud Studio 7.2.1

Re: tFileExcel-Components 11.0 with Talend Cloud Studio 7.2.1

Re: tFileExcel-Components 11.0 with Talend Cloud Studio 7.2.1

Re: tFileExcel-Components 11.0 with Talend Cloud Studio 7.2.1