You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2015/01/18 04:18:38 UTC
[Bug 57456] New: RecordFormatExpection (Not enough data) with
External Data Source
https://issues.apache.org/bugzilla/show_bug.cgi?id=57456
Bug ID: 57456
Summary: RecordFormatExpection (Not enough data) with External
Data Source
Product: POI
Version: unspecified
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
Assignee: dev@poi.apache.org
Reporter: jpfourny@gmail.com
I know there have been resolved cases of RecordFormatException involving
SSTRecord in the past, but I think I found a new case. The stack trace looks
like this:
org.apache.poi.hssf.record.RecordFormatException: Not enough data (0) to read
requested (2) bytes
at
org.apache.poi.hssf.record.RecordInputStream.checkRecordPosition(RecordInputStream.java:216)
at
org.apache.poi.hssf.record.RecordInputStream.readShort(RecordInputStream.java:233)
at
org.apache.poi.hssf.record.common.UnicodeString.<init>(UnicodeString.java:405)
at
org.apache.poi.hssf.record.SSTDeserializer.manufactureStrings(SSTDeserializer.java:57)
at org.apache.poi.hssf.record.SSTRecord.<init>(SSTRecord.java:247)
SSTDeserializer.manufactureStrings(..) is told there are strings, but the
RecordInputStream has 0 bytes remaining (although there are more records that
follow). I find it interesting that the code attempts to read a Unicode string
when there are no bytes remaining ... it will always fail, no?
General Steps to Reproduce:
* Create blank workbook in Excel 2010 (or later).
* Add a web query (or any other data source) and insert into the sheet. This
creates an external sheet ref.
* In the "Usage" tab of the connection properties, specify "Remove data from
external data range before saving the workbook".
* Save workbook as XLS file.
* Open XLS file in POI. *Boom*.
Upon saving, Excel is writing the SSTRecord that claims to have strings, but it
is actually empty. Odd, but it is what it is. I know POI cannot handle external
data sources, but I expect to be able to open the file with POI without blowing
up. There may be other sheets with useful data that I want to scrape.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 57456] RecordFormatExpection (Not enough data) with External
Data Source
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=57456
--- Comment #2 from Joseph F. <jp...@gmail.com> ---
Created attachment 32376
--> https://issues.apache.org/bugzilla/attachment.cgi?id=32376&action=edit
File to reproduce the issue.
The file contains no data - just a Web Query that is populated when opened in
Excel and the data is removed by Excel on save. Note: The Web Query is not
reachable outside of a private intranet, so do not expect it to populate in
Excel. The point is to demonstrate that Excel is saving an SSTRecord that
chokes up POI. Interestingly, this file opens without error in OpenOffice,
which I thought was built on POI, no?
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 57456] RecordFormatExpection (Not enough data) with External
Data Source
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=57456
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #1 from Dominik Stadler <do...@gmx.at> ---
Can you please add such a file so it becomes easier to reproduce this.
Additional points if you can include a unit test as well.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 57456] RecordFormatExpection (Not enough data) with External
Data Source
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=57456
Joseph F. <jp...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
--- Comment #3 from Joseph F. <jp...@gmail.com> ---
I am setting the status back to "NEW", since I have attached an input file to
reproduce the issue, as requested. Unfortunately, I do not have time to build a
unit test :(.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 57456] RecordFormatExpection (Not enough data) with External
Data Source
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=57456
Joseph F. <jp...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |jpfourny@gmail.com
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 57456] RecordFormatExpection (Not enough data) with External
Data Source
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=57456
Joseph F. <jp...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Version|unspecified |3.10-FINAL
OS| |All
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 57456] RecordFormatExpection (Not enough data) with External
Data Source
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=57456
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |FIXED
--- Comment #4 from Dominik Stadler <do...@gmx.at> ---
The problem is caused by a SSTRecord that is not built correctly by Excel.
According to the spec it should contain the number of strings overall in the
file and the number of unique strings that then follow in the record. However
in this case the number of strings overall is zero (which itself is not allowed
per the spec) and the number of unique strings seems to be randomly set. So we
try to read a random number of strings, which predictably fails.
I have worked around this in r1659650 so that if the number of string overall
is zero, the SST record is read as empty and thus parsing this file works.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org