LoopMax Exceeded: 99999

WARNING: You currently have Javascript disabled!
This website will not function correctly without Javascript enabled.

IWT

6 discussion posts

I've been on here a few times. A bit lost as to whether this has been addressed or not.

Logically, there is a file limitation on it, but can this be overcome? Perhaps enlarged with a variable?

I would have thought it would be the number 1 issue? I get it all the time (working with big files of course).

Anyone know? Would be appreciated.

Thx

David

Jul 6, 2016 (modified Jul 6, 2016) • #1

Could you attach screenshots of the Search tab and Advanced tab for the search that produces this error? There aren't any file limits that I'm aware of.

Jul 6, 2016 • #2

IWT

6 discussion posts

Thanks.

Screenshots attached. In case there are any oddities with them, I have redacted part of the screen and edited the search text. Nothing that ought to affect the analysis I don't believe.

I'm not super technical, but I can hold my own. It looks like a fairly logical loop restriction, but I do work with large files of records sometimes in the millions. The utility is great, but limiting if I can't resolve the ability to search bigger files is all.

Thanks

David

• Attachment [protected]: Screenshot 1.jpg [255,624 bytes]

• Attachment [protected]: Screenshot 2.jpg [237,346 bytes]

Jul 7, 2016 • #3

Thanks! Looks like this is indeed a self-imposed limit on the number of lines that can be passed into a file handler, to prevent FileSeek or the handler from hanging up. Do those Excel files have more than 100,000 rows?

Jul 7, 2016 • #4

IWT

6 discussion posts

Yes they do.

I was wondering if it is possible to overcome this limitation.

I can understand the potential risk insofar as an error of some kind might see the application going around in an infinite loop, however, being aware of that, it could still be managed if it can be overcome.

Thx

David

Jul 8, 2016 • #5

We should be able to increase that limit. Approximately how many lines are in your files? Just want to make sure we set it high enough

Jul 8, 2016 • #6

IWT

6 discussion posts

Well although it's not very common, would 10 million be entirely rediculous?

I have checked files of that size before. Once they are that large, it's difficult to cut them down without (say) SQl in which case I would just be querying it SQL.

Thanks

David

Jul 8, 2016 • #7

We should be able to do that. I'll let you know when the next version is available so that you can try it out

Thanks!

Jul 13, 2016 • #8

IWT

6 discussion posts

That would be great

Thanks for your help.

David

Jul 13, 2016 • #9

IWT

6 discussion posts

Just so I know when to possibly look out for it.... any ideas on when the new version will be out?

Thanks

David

Jul 22, 2016 • #10