tFileExcel component error when using tFileArchive in the same job since migrating to TOS 7.2.1

[Anonymous]

Hello Guys,

Since I've upgrade TOS 7.1.1 to 7.2.1, i have a error in All Job containing tFileInputExcel and tFileArchive in the same Job.

I've got this error on tFileInputExcel component :

Exception in component tFileInputExcel_2 (Test)

java.lang.IllegalArgumentException: InputStream of class class org.apache.commons.compress.archivers.zip.ZipFile$1 is not implementing InputStreamStatistics.

at org.apache.poi.openxml4j.util.ZipArchiveThresholdInputStream.<init>(ZipArchiveThresholdInputStream.java:64)

at org.apache.poi.openxml4j.util.ZipSecureFile.getInputStream(ZipSecureFile.java:147)

at org.apache.poi.openxml4j.util.ZipSecureFile.getInputStream(ZipSecureFile.java:34)

at org.apache.poi.openxml4j.util.ZipFileZipEntrySource.getInputStream(ZipFileZipEntrySource.java:66)

at org.apache.poi.openxml4j.opc.ZipPackage.getPartsImpl(ZipPackage.java:260)

at org.apache.poi.openxml4j.opc.OPCPackage.getParts(OPCPackage.java:726)

at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:237)

at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:166)

at org.apache.poi.ooxml.POIXMLDocument.openPackage(POIXMLDocument.java:89)

at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:336)

at asm_import.test_0_1.Test.tFileInputExcel_2Process(Test.java:805)

at asm_import.test_0_1.Test.runJobInTOS(Test.java:1728)

at asm_import.test_0_1.Test.main(Test.java:1553)

Just by removing the tFileArchive component of the job, so all work fine without error.

I've trying to test a Job with only tFileInputExcel -> tLogRow. It work fine.
I've trying to test a Job with only tFileArchive. It work fine too.

Finaly, I've testing a Job with one tFileInputExcel -> tLogRow and tFileArchive and then I've got this error !

In TOS 7.1.1 all the jobs works fine.

I've testing all this case on a another computer with same environnement, and I've the same isssue.

Is someone can help me to resolve this troubleshooting ?

Thank you for yor help.

Eric

-----------------------

Environnement context :
- MacOS Mojave 10.14.6
- TOS 7.2.1,
- Java : jdk1.8.0_221

[Anonymous]

Hello,

Have you tried to use "OnsubjobOK" instead of "OnComponentOk" trigger to see if this job works?

Your tFileArchive subjob starts only when the previous subjob completely finishes.

Best regards

Sabrina

[Anonymous]

Thank you Sabrina for your help,

This is a Job developed with TOS 7.1 and witch works perfectly.

After importing it into TOS 7.2, all Jobs containing an Excel tFileInput and a tFile Archive crash at compilation. Before you even start.

I have several Job whose tFileArchive is at the end of Job linked by an OnSubJobOk and all of them are crashing.


The error concerns tFile InputExcel and when I delete the tFileArchive from the job then everything works perfectly.

It seems that there is an incompatibility between these two versions of components

Bests regards

Eric.

[GTS-Talend]

Hi Eric, 

Did you ever get this issue resolved? 

[diemerga]

Hi,

I have the same problem in TOS 7.2.1

Try also in TOS 7.3.1 M1, same problem there...

I try in a simple job, just take a tFileArchive and after a OnSubJobOk a tFileInputExcel and you have the crash !

https://jira.talendforge.org/browse/TDI-42979

[Anonymous]

I have had a similar issue with a job created in 6.5.2 and migrated to 7.2.1.

It uses a tFileInputExcel component that fails with the exact same error message, we do not have any archiving components in the job.

The job is a sub-job when executed on its own it works fine, if called from its parent job then I get the same error as you.

The fix for us is to create a new sub job and copy in the components from the original sub-job and hey presto, it works!

[diemerga]

Hi,

There is a workaround given by talend :

1. Download commons-compress Jar from official maven repo - https://mvnrepository.com/artifact/org.apache.commons/commons-compress/1.19
2. Open Window / Show View / Modules (Talend).
3. Search in tab: commons-compress
4. Perform changes to tFileArchive: click on [...] - > chose for Module File - downloaded jar - > Check Custom mvn uri - provide unique URI (e.g. - mvnrg.talend.libraries/commons-compress-1.19/6.1.0/jar) - > Detect the module install status -> Ok.
5. Perform changes on tFileInputExcel: Click on [...] - > Check Custom mvn uri - provide unique URI from step 4 - > Detect the module install status -> Ok.

[Anonymous]

Hi, 

I have the same issue and I have to separate into 2 independent processes as follows and It works perfectly. 

It is recommended to check on "Use an independent process to run subjob" of tFileUnarchive.

Regards, 

Thu Le