tFileExcel-Components 11.0 with Talend Cloud Studio 7.2.1

[Anonymous]

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

[fdenis]

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.

[Anonymous]

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.

[nmodi]

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?