tFileExcel-Components 11.0 with Talend Cloud Studio 7.2.1

Five Stars

tFileExcel-Components 11.0 with Talend Cloud Studio 7.2.1

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

Twelve Stars

Re: tFileExcel-Components 11.0 with Talend Cloud Studio 7.2.1

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.

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Five Stars

Re: tFileExcel-Components 11.0 with Talend Cloud Studio 7.2.1

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.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Self-service Talend Migration: Moving from On-Premises to the Cloud

Move from On-Premises to the Cloud by following the advice of experts

Read Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog