Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
SachinD
Creator
Creator

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


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

Labels (3)
1 Solution

Accepted Solutions
SachinD
Creator
Creator
Author

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.

 

View solution in original post

8 Replies
cterenzi
Specialist
Specialist

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

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)

 

SachinD
Creator
Creator
Author

0683p000009Lu6B.jpg0683p000009Ltgp.jpg0683p000009Lu7X.jpg

SachinD
Creator
Creator
Author

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 attached0683p000009Lu8Q.jpg

 

I am using "Jaspersoft ETL" enterprise edition

Version: 5.6.2
Build id: V5.6.2_20150508_1414

SachinD
Creator
Creator
Author

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

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

SachinD
Creator
Creator
Author

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.

 

cterenzi
Specialist
Specialist

Thanks for posting your solution!