Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug]: Microsoft excel input can't load heavy file #2307

Closed
gwenael-mahe opened this issue Feb 10, 2023 · 1 comment
Closed

[Bug]: Microsoft excel input can't load heavy file #2307

gwenael-mahe opened this issue Feb 10, 2023 · 1 comment
Assignees
Labels
Milestone

Comments

@gwenael-mahe
Copy link

Apache Hop version?

2.3.0

Java version?

16.0.1

Operating system

Windows

What happened?

When opening an excel file with 5 sheet and around 90k rows each.
I tried loading only 1 sheet and limiting the number of rows to load but I alwyas have the error:
Caused by: org.apache.poi.util.RecordFormatException: Tried to allocate an array of length 256,059,344, but the maximum length for this record type is 100,000,000.
If the file is not corrupt and not large, please open an issue on bugzilla to request
increasing the maximum allowable size for this record type.
You can set a higher override value with IOUtils.setByteArrayMaxOverride()

I went on https://chat.project-hop.org/hop/channels/town-square and have been told to open an issue here and that it might be a regression from HOP or POI

Issue Priority

Priority: 3

Issue Component

Component: Actions

@hansva
Copy link
Contributor

hansva commented Mar 8, 2023

.take-issue

@hansva hansva closed this as completed in 227ca98 Mar 8, 2023
@hansva hansva added this to the 2.4 milestone Mar 8, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants