Title:
Bug 83333:Can't create xls or xlsx document using cfspreadsheet depending on size of query
| View in TrackerStatus/Resolution/Reason: Closed/Withdrawn/
Reporter/Name(from Bugbase): Vasily Pupkin / Vasily Pupkin (Greyswandir)
Created: 06/11/2010
Versions: 9.0
Failure Type: Unspecified
Found In Build/Fixed In Build: 251028 /
Priority/Frequency: Trivial / Unknown
Locale/System: English / Win All
Vote Count: 0
Problem:
Can't create xls or xlsx document using cfspreadsheet depending on size of query. When query returns more then ~150000 cells Rep.cfm stop it's execution and application.log shows: "Java heap space The specific sequence of files included or processed is: C:\ColdFusion9\wwwroot\DarnitsaRegRep-debug\Rep.cfm"
Method:
executing this Rep.cfm I take nothing except zero sized westRep.xlsx file.<cfquery datasource="OracleSBYT" name="qRep">select rownum, okpo_code, partner, distributor, partner_name_df, partner_name_morion, corporation, is_hospital, hosp_ident, partner_id from table</cfquery><cfspreadsheetaction="write"filename = "westRep.xlsx"overwrite = "true"query = "qRep"sheetname = "Report" /><cfoutput><table border = "1"></cfoutput><cfoutput query = "qRep"><tr><td>#qRep.rownum#</td><td>#qRep.partner#</td><td>#qRep.okpo_code#</td><td>#qRep.distributor#</td><td>#qRep.partner_name_df#</td><td>#qRep.partner_name_morion#</td> <td>#qRep.corporation#</td><td>#qRep.is_hospital#</td> <td>#qRep.hosp_ident#</td><td>#qRep.partner_id#</td></tr></cfoutput>When I replace cfoutput first before cfspreadsheet I'll take table with 15000 rows on the screen and zero sized westRep.xlsx file.
Result:
Can't create xls or xlsx document using cfspreadsheet depending on size of query.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3041644
External Customer Info:
External Company:
External Customer Name: Vasily Pupkin
External Customer Email: 10302A7E4B9B46980A04B838
External Test Config: 06/11/2010
Attachments:
Comments: