Problems Exporting Report or getting the subscription to run- SQL SERVER 2005
Posted on 2010-09-03
I am using SQL SERVER 2005
and have set up my reports on the Report Sever.
I can run all of the reports on the report manager and export them and set up subscriptions to save to drives etc except for ONE report.
It only has about 30k rows, i have much larger rows exporting, however there are 85 colunms on the report, (i know!!) , but i wonder is this the issue?
I can't export when i try to it asks for log in details, and then it won't accept any i add in.
I tried to use the subscription and save the file to a drive and this gives me back an error saying
''Failure writing file All Wimax Sales Leads : An error occurred during rendering of the report.''
When i checked the Log files i get the following error on the file:
''w3wp!library!1!09/03/2010-11:31:00:: i INFO: Call to RenderFirst( '/UNO Reporting/UNO and Walled Garden/All Wimax Sales Leads' )
w3wp!webserver!1!09/03/2010-11:31:20:: i INFO: Processed report. Report='/UNO Reporting/UNO and Walled Garden/All Wimax Sales Leads', Stream=''
w3wp!library!1!09/03/2010-11:31:31:: i INFO: Call to RenderNext( '/UNO Reporting/UNO and Walled Garden/All Wimax Sales Leads' )
w3wp!runningjobs!8!9/3/2010-11:32:51:: i INFO: Adding: 1 running jobs to the database
w3wp!reportrendering!1!09/03/2010-11:33:23:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report., ;
Info: Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An error occurred during rendering of the report. ---> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at Microsoft.ReportingServices.Rendering.ExcelRenderer.StyleHandler.GetStyleIdForReportItem(PageReportItemInfo reportItemInfo, ReportItem reportItem, ReportColor& parentBackgroundColor, String reportLanguage, Boolean constLang, WorkBook workBook)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreScanPage(ReportItem parentDataRegion, Boolean isPageNeedsEvaluation, PageLayout& pageLayout, PageReportItems& pageRIItems, Stack& dynamicLayoutStack, Hashtable& rowHeightStateList, OutlineRenderStates& verticalOutlineStates, OutlineRenderStates& horizontalOutlineStates)''
I cant understand the 'System.OutOfMemoryException' Error.
I have checked the space on teh server and there is still lots of space on the tempdb, msdb, report server and the db that the rpeorts are built on.
Can anyone help me with this please?