tracker issue : CF-3432184

select a category, or use search below
(searches all categories and all time range)
Title:

SpreadSheetAddRows Can Not Handle Large Queries with Date-like columns

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Alex M / Alex M (Alex_xml)

Created: 12/19/2012

Components: Document Management, Office Integration

Versions: 9.0.1

Failure Type: Crash

Found In Build/Fixed In Build: 9.0.1 / 284725

Priority/Frequency: Critical / All users will encounter

Locale/System: English / Windows 7

Vote Count: 0

Problem Description: When adding a substantially large (18000+) query object via SpreadSheetAddRows() the POI will crash with an error. The culprit seems to be in how CF deals with date-like fields.

Steps to Reproduce: http://pastebin.com/WCwi0Dea

Actual Resfult: POI crash

Expected Result: Excel spreadsheet object with a large query.

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3432184

External Customer Info:
External Company:  
External Customer Name: Alex_xml
External Customer Email:  
External Test Config: My Hardware and Environment details: CF 9,0,1,274733, JVM 1.6.0_38, POI (unknown, default)

Attachments:

Comments:

http://stackoverflow.com/questions/DVAAE-13921754/how-to-fix-an-arrayindexoutofbounds-exception-when-adding-a-new-row/
Comment by External U.
16880 | December 19, 2012 02:30:24 PM GMT
I haven't yet verified that it only crashes on large queries with date columns. However, my query object returns over 66,000+ rows.
Comment by External U.
16881 | March 19, 2013 04:49:56 PM GMT
Piyush - Can you check if this is all ok in CF11?
Comment by Vamseekrishna N.
16882 | June 12, 2013 10:02:42 PM GMT