topic Re: Not able to create Excel files using tExcelOutput as it throws Error in Talend Studio

Not able to create Excel files using tExcelOutput as it throws Error

Sudhee_Maximus — Fri, 15 Nov 2024 21:26:54 GMT

Hi There,

I am trying to execute a job in Talend 7.3.1 where I have to load s3 buckets if the records exists in the excel file, but the job fails at creating excel file and throws error .

I have attached logs for your reference.

fyi..

I have used --> ((Integer)globalMap.get("tFileOutputExcel_1_NB_LINE")) != null && ((Integer)globalMap.get("tFileOutputExcel_1_NB_LINE")) > 0 condition post excel component to s3 bucket.

I have installed below jars, but seems it didn't resolve the issue.

poi-4.0.1.jar

poi-ooxml-4.0.1.jar

poi-ooxml-schemas-4.0.1.jar

poi-scratchpad-4.0.1.jar

Please help me with the resolution on the below ...

Error

Exception in thread "Thread-7" java.lang.NoClassDefFoundError: org/apache/commons/collections4/ListValuedMap

at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:241)

at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:211)

at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:186)

at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:273)

at org.talend.ExcelTool.prepareXlsxFile(ExcelTool.java:132)

at dceb.dceb_05_outbound_mco_survey_file_gen_0_1.DCEB_05_outbound_MCO_survey_file_gen.tDBInput_1Process(DCEB_05_outbound_MCO_survey_file_gen.java:10178)

at dceb.dceb_05_outbound_mco_survey_file_gen_0_1.DCEB_05_outbound_MCO_survey_file_gen.tJava_1Process(DCEB_05_outbound_MCO_survey_file_gen.java:1309)

at dceb.dceb_05_outbound_mco_survey_file_gen_0_1.DCEB_05_outbound_MCO_survey_file_gen.tS3Connection_1Process(DCEB_05_outbound_MCO_survey_file_gen.java:1047)

at dceb.dceb_05_outbound_mco_survey_file_gen_0_1.DCEB_05_outbound_MCO_survey_file_gen$4.run(DCEB_05_outbound_MCO_survey_file_gen.java:18749)

Caused by: java.lang.ClassNotFoundException: org.apache.commons.collections4.ListValuedMap

at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:581)

at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:178)

at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:521)

... 9 more

[INFO ] 16:00:13 dceb.dceb_01_outbound_mco_survey_control_0_1.DCEB_01_outbound_MCO_survey_Control- tRunJob_3 - The child job 'dceb.dceb_05_outbound_mco_survey_file_gen_0_1.DCEB_05_outbound_MCO_survey_file_gen' is done.

[FATAL] 16:00:13 dceb.dceb_01_outbound_mco_survey_control_0_1.DCEB_01_outbound_MCO_survey_Control- tRunJob_3 Child job running failed.

Re: Not able to create Excel files using tExcelOutput as it throws Error

Anonymous — Wed, 30 Aug 2023 02:30:17 GMT

Which Java version? Can you please share the log file which is located in <studio installation directory>/workspace/.metadata/ and check which Java version is used to launch studio.

Regards

Shong

Re: Not able to create Excel files using tExcelOutput as it throws Error

Sudhee_Maximus — Tue, 12 Sep 2023 18:00:46 GMT

HI Shong,

I see the JRE is selected to as below..

but my log says

!SESSION 2023-09-12 12:25:45.920 -----------------------------------------------

eclipse.buildId=unknown

java.version=11.0.11

java.vendor=Oracle Corporation

BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en_US

Command-line arguments: -os win32 -ws win32 -arch x86_64

!ENTRY org.talend.platform.logging 1 0 2023-09-12 12:26:07.106

!MESSAGE 2023-09-12 12:26:07,097 INFO org.talend.platform.logging.Activator -

!!------------------------------------------------------------------------------!!

!! !!

!! TALEND !!

!! Starting Talend's platform log system.VERSION= 7.3.1.20221115_1012-patch !!

!! !!

!!------------------------------------------------------------------------------!!

Note :-

I am using below script to launch Talend and not launching it by click on the exe file.

Re: Not able to create Excel files using tExcelOutput as it throws Error

Anonymous — Wed, 13 Sep 2023 03:03:07 GMT

It seems like the commons-collections4 jar doesn't contain the ListValuedMap class, make sure the right jar has been installed.

Open the Module view and check which version of the commons-collections4 jar is installed.

In my studio, the latest version commons-collections4-4.4.jar is installed, I can't reproduce the issue.

Regards

Shong