Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Report Failure when rendering - SQL SERVER 2005 - Report manager

Avatar of Putoch
PutochFlag for Afghanistan asked on
Microsoft SQL ServerMicrosoft SQL Server 2005SSRS
12 Comments1 Solution2021 ViewsLast Modified:
Hi,
i am using SQL SERVER 2005
I have a report that sits on the report manager and exports nightly to a named drive.
this has been working fine until this week
one night it works the next night it does not

when i check the subscription to see if it has saved down it says
''Failure writing file ReportName : An error occurred during rendering of the report.''

When i checked out the log files for this it says:
''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.''


The report is huge
its well over 160k rows
I can run the report but can no longer export it on the rpeort manager using the Export Tool
I had been able to ftp or set up a subscription to save the file to a drive but now thats not working.

Can anyone give any advise on what to do please?
Kind Regards,
Putoch snapshot-of-report-not-rendering.txt snapshot-of-report-not-rendering.txt
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohanFlag of Canada imageDatabase Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 12 Comments.
See Answers