Putoch
asked on
Problems Exporting Report or getting the subscription to run- SQL SERVER 2005
Hi,
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/201 0-11:31:00 :: i INFO: Call to RenderFirst( '/UNO Reporting/UNO and Walled Garden/All Wimax Sales Leads' )
w3wp!webserver!1!09/03/201 0-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/201 0-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.ReportingService s.ReportPr ocessing.W rapperRepo rtRenderin gException : An error occurred during rendering of the report., ;
Info: Microsoft.ReportingService s.ReportPr ocessing.W rapperRepo rtRenderin gException : An error occurred during rendering of the report. ---> Microsoft.ReportingService s.ReportRe ndering.Re portRender ingExcepti on: An error occurred during rendering of the report. ---> System.OutOfMemoryExceptio n: Exception of type 'System.OutOfMemoryExcepti on' was thrown.
at Microsoft.ReportingService s.Renderin g.ExcelRen derer.Styl eHandler.G etStyleIdF orReportIt em(PageRep ortItemInf o reportItemInfo, ReportItem reportItem, ReportColor& parentBackgroundColor, String reportLanguage, Boolean constLang, WorkBook workBook)
at Microsoft.ReportingService s.Renderin g.ExcelRen derer.Exce lRenderer. PreScanPag e(ReportIt em parentDataRegion, Boolean isPageNeedsEvaluation, PageLayout& pageLayout, PageReportItems& pageRIItems, Stack& dynamicLayoutStack, Hashtable& rowHeightStateList, OutlineRenderStates[]& verticalOutlineStates, OutlineRenderStates[]& horizontalOutlineStates)''
I cant understand the 'System.OutOfMemoryExcepti on' 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?
Regards,
Putoch
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/201
w3wp!webserver!1!09/03/201
w3wp!library!1!09/03/2010-
w3wp!runningjobs!8!9/3/201
w3wp!reportrendering!1!09/
Info: Microsoft.ReportingService
at Microsoft.ReportingService
at Microsoft.ReportingService
I cant understand the 'System.OutOfMemoryExcepti
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?
Regards,
Putoch
ASKER
Thanks Eugene,
I cheked the version, its actually SP2
''Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86) May 26 2009 14:24:20 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) ''
---
I also checked the Event viewer
This is what i found:
''Report Server (MSSQLSERVER) cannot connect to the report server database.''
''Report Server (MSSQLSERVER) cannot load the Report Server DocumentLibrary extension.''
--
I actually waited back one of the evenings when i knew no one was using it, and restarded the server, but this didnt do anything.
I believe its the size of the report? maybe i'm wrong. But it has 85 colunms on it.
which i'm sure not all are being used.
i've exported it sucessfully now as CSV as its half the size in this format.
Do you think this could be the problem.
Thanks,
putoch.
I cheked the version, its actually SP2
''Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86) May 26 2009 14:24:20 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) ''
---
I also checked the Event viewer
This is what i found:
''Report Server (MSSQLSERVER) cannot connect to the report server database.''
''Report Server (MSSQLSERVER) cannot load the Report Server DocumentLibrary extension.''
--
I actually waited back one of the evenings when i knew no one was using it, and restarded the server, but this didnt do anything.
I believe its the size of the report? maybe i'm wrong. But it has 85 colunms on it.
which i'm sure not all are being used.
i've exported it sucessfully now as CSV as its half the size in this format.
Do you think this could be the problem.
Thanks,
putoch.
can you upload\add report via SSRS report admin as file?
btw: after restart did you get "out of memory " errors?
ASKER
it seems to export and rendor fine when i export as CSV
its the EXCEL file format it has a problem with.
Its not even the biggest file size wise as i have thats saving ok all the time. however it is the widest (85 fields on teh report)
When you say ''can you upload\add report via SSRS report admin as file?''
do you mean can i export this file as EXCEL using SSRS visual studio.
or do you mean am i having any trouble uploading hte file from SSRS?
thanks,
putoch
its the EXCEL file format it has a problem with.
Its not even the biggest file size wise as i have thats saving ok all the time. however it is the widest (85 fields on teh report)
When you say ''can you upload\add report via SSRS report admin as file?''
do you mean can i export this file as EXCEL using SSRS visual studio.
or do you mean am i having any trouble uploading hte file from SSRS?
thanks,
putoch
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Seemed to be a space issue thanks Eugine
make sure it is fresh (sp3)
--
check event viewer \sql error log errors from sql server (and where you push report)
and post here if you see some:
--
if it is not prod server and it is OK reboot it -> try to reboot it and try deploy report again