Problem Note 70595: Importing some specific Microsoft Excel files in SAS® Visual Analytics might fail with the error "The following file could not be processed"
 |  |  |  |  |
When importing some specific Microsoft Excel files in SAS Visual Analytics or SAS® Visual Data Builder, the following error might occur:
The following file could not be processed. Anonymous.xlsx – Show details
If you click Show details, the following exception is displayed:
com.sas.bicommon.selfserv.extractor.ExtractorException: org.apache.poi.util.RecordFormatException: Tried to allocate an array of length 113,316,011, but the maximum length for this record type is 100,000,000.
If the file is not corrupt or large, please open an issue on bugzilla to request
increasing the maximum allowable size for this record type.
As a temporary workaround, consider setting a higher override value with IOUtils.setByteArrayMaxOverride()
org.apache.poi.util.RecordFormatException: Tried to allocate an array of length 113,316,011, but the maximum length for this record type is 100,000,000.
If the file is not corrupt or large, please open an issue on bugzilla to request
increasing the maximum allowable size for this record type.
As a temporary workaround, consider setting a higher override value with IOUtils.setByteArrayMaxOverride()
Tried to allocate an array of length 113,316,011, but the maximum length for this record type is 100,000,000.
If the file is not corrupt or large, please open an issue on bugzilla to request
increasing the maximum allowable size for this record type.
As a temporary workaround, consider setting a higher override value with IOUtils.setByteArrayMaxOverride()
If the file is not corrupt or large, please open an issue on bugzilla to request
increasing the maximum allowable size for this record type.
As a temporary workaround, consider setting a higher override value with IOUtils.setByteArrayMaxOverride()
org.apache.poi.util.RecordFormatException: Tried to allocate an array of length 113,316,011, but the maximum length for this record type is 100,000,000.
If the file is not corrupt or large, please open an issue on bugzilla to request
increasing the maximum allowable size for this record type.
As a temporary workaround, consider setting a higher override value with IOUtils.setByteArrayMaxOverride()
Tried to allocate an array of length 113,316,011, but the maximum length for this record type is 100,000,000.
If the file is not corrupt or large, please open an issue on bugzilla to request
increasing the maximum allowable size for this record type.
As a temporary workaround, consider setting a higher override value with IOUtils.setByteArrayMaxOverride()
This problem does not affect all types of Microsoft Excel files that you import, but only some of them.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Analytics (on SAS 9.x) | Microsoft® Windows® for x64 | 7.52 | 8.5 | 9.4 TS1M8 | Viya |
| Linux for x64 | 7.52 | 8.5 | 9.4 TS1M8 | Viya | ||
A fix for this issue for SAS Visual Analytics 7.52 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/M4N.html#70595| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2024-03-15 10:10:48 |
| Date Created: | 2024-01-10 04:06:53 |