topic Re: error with tFileInputExcel : Can only iterate over an array or an instance of java.lang.Iterable in Talend Studio

error with tFileInputExcel : Can only iterate over an array or an instance of java.lang.Iterable

SachinD — Tue, 09 May 2017 14:24:04 GMT

I am developing one Job in which I am facing some issue in below segment for component tFileInputExcel

tfilelist --> iterate -- > tFileInputDelimited --> tmap --> tmssqloutput --> tFileInputExcel (another file) --> Tmap --> tmssqloutput

I am getting error for tFileInputExcel (another XLSX file)
Exception in thread "main" java.lang.Error: Unresolved compilation problem:
Can only iterate over an array or an instance of java.lang.Iterable

but i hv observed when i uncheck
Read excel2007 fileformat (xlsx) and use xls file it works fine

Re: error with tFileInputExcel : Can only iterate over an array or an instance of java.lang.Iterable

cterenzi — Tue, 09 May 2017 16:50:18 GMT

What type of connection do you have between tMSSqlOutput and tFileInputExcel?

Re: error with tFileInputExcel : Can only iterate over an array or an instance of java.lang.Iterable

vapukov — Wed, 10 May 2017 01:15:15 GMT

What connection between - tmssqloutput --> tFileInputExcel (another file)?

tfilelist --> iterate -- > tFileInputDelimited --> tmap --> tmssqloutput --> OnComponentOk (??) --> tFileInputExcel (another file) --> Tmap --> tmssqloutput

better if You attach picture of You Job (with settings)

Re: error with tFileInputExcel : Can only iterate over an array or an instance of java.lang.Iterable

SachinD — Wed, 10 May 2017 07:30:55 GMT

Re: error with tFileInputExcel : Can only iterate over an array or an instance of java.lang.Iterable

SachinD — Wed, 10 May 2017 13:13:02 GMT

I was thinking, here is some issue with job/ component configuration.

But I observed that even if I just try to create METADATA for any .xlsx file, its gives me same error

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
Can only iterate over an array or an instance of java.lang.Iterable

screenshot attached

I am using "Jaspersoft ETL" enterprise edition

Version: 5.6.2
Build id: V5.6.2_20150508_1414

Re: error with tFileInputExcel : Can only iterate over an array or an instance of java.lang.Iterable

SachinD — Wed, 10 May 2017 13:14:44 GMT

I am getting same error even while creating metadata for .xlsx, please check latest sceenhost

Re: error with tFileInputExcel : Can only iterate over an array or an instance of java.lang.Iterable

vapukov — Wed, 10 May 2017 13:20:35 GMT

I do not have 5.6 for now, all migrated

oldest available version - 6.1

the problem could be and in Jasper (Talend) and with Excel (office)

if You want - You can send .xlsx example I can test with 6.1 - 6.4

Re: error with tFileInputExcel : Can only iterate over an array or an instance of java.lang.Iterable

SachinD — Thu, 11 May 2017 09:16:37 GMT

nothing specific to particular .xlsx file, it was giving error for all xlsx files.

So, finally solution that worked for me is,

I exported that job to another machine, which exactly has same version Version: 5.6.2
and it worked absolutely fine without any issues.

I wasted my 2 days though.

Thanks All for helping.

Re: error with tFileInputExcel : Can only iterate over an array or an instance of java.lang.Iterable

cterenzi — Thu, 11 May 2017 14:11:56 GMT

Thanks for posting your solution!