tfileinputexcel with Event mode is not working with Limit clause.

[Anonymous]

Hi there,

I have created a very simple job to reproduce the scenario. 

tfileinput_excel --> tlogrow

1.) tfileinputexcel: The input file has 1000 rows. Trying to read xlsx file with Event mode to reduce less memory. Tried to limit the row from the file to 50. 

When I try to run the job, it is not limiting the output for 50 rows. Instead it runs for all rows.

Any suggestions.

This is a very simple job. 

The original Job (which I am working on)  tries to read input file (multiple spreadsheets with User mode.) in multiple jobs. The file is quite about 5M.  But it throws memory error because of the file size.

I thought to use the Event mode, but Event mode is not working with Limit clause as I described in my example job above.

[TRF]

Hi,

What do you call "Event mode"?

Can you share your job design?

[Anonymous]

I am assuming you are referring to the generation mode when you talk about user mode or event mode. Irrespective of what this mode is set to, the limit clause should work.

[Anonymous]

No. The limit cause is not working when using the event mode.

[Anonymous]

well like @TRF mentioned, we need the job design to identify what's the actual issue..

[cterenzi]

Which version are you using? I tested this scenario in 6.3, and it works as expected, but there is an old (2014) bug tracker entry for this issue.

[Anonymous]

Hi ,

I am using 5.6.1.

[cterenzi]

I believe that version predates the fix for this issue.

[Anonymous]

Hi,

Please find the attached very simple job.

Version: 5.6.1
Build id: V5.6.1_20141207_1530

I have also found one more issue:

• If in the Excel component, in the "Sheet List": If you specify the Sheet name, and run the job in Event mode , it works fine. But if you specify the sheet position (i.e. 0) , it will fail.
• If you run the above scenarios in User mode, no issues at all.

testeventmode.zip

[Anonymous]

Hi sanketmistry
Can you download and test the latest versions 6.3.1 or 6.4.0? I have made some testing on v6.4.0 and it works fine.
BTW: v5.6.1 is a very old version.

Regards
Shong