outofmemory exception with pdf or xls export

[Sandro Cavazzoni]

Hi to all,
i started to test telerik report system. I made a really simple report (a simple grid from an sql table of about 100 rows... without images). I added webreportviewer to my project and connected it to my report. When i test my application i can see the report preview, i can export it in RTF or CSV but i cannot export it in PDF or XLS due an out of memory exception.
I'm using it on windows azure development enviroment. My system is an updated windows 7 64 bit with 4GB of ram and visual studio 2010 pro.

This is the exception stack trace

[OutOfMemoryException: Memoria insufficiente.]
   System.Drawing.Graphics.FromHdcInternal(IntPtr hdc) +203
   System.Drawing.Font.ToLogFont(Object logFont) +184
   System.Drawing.Font.ToHfont() +166
   Telerik.Reporting.Pdf.Fonts.TrueType.FontReader.GetFontData(Font font, Boolean& isTTC) +390
   Telerik.Reporting.Pdf.Fonts.TrueType.TrueTypeDescriptor..ctor(Font gdiFont) +736
   Telerik.Reporting.Pdf.Fonts.TrueType.TrueTypeDescriptor..ctor(PdfFont font) +84
   Telerik.Reporting.Pdf.PdfFontTable.GetDescriptor(PdfFont font) +399
   Telerik.Reporting.Pdf.PdfFontDictionary..ctor(PdfDocument document, PdfFont drawingFont) +198
   Telerik.Reporting.Pdf.PdfFontType0Dictionary..ctor(PdfDocument document, PdfFont font) +73
   Telerik.Reporting.Pdf.PdfFontTable.GetFont(PdfFont font) +315
   Telerik.Reporting.Pdf.PdfPageDictionary.GetFontName(PdfFont font, PdfFontDictionary& fontDictionary) +132
   Telerik.Reporting.Pdf.Rendering.PdfRenderer.GetFontName(PdfFont font, PdfFontDictionary& fontDictionary) +101
   Telerik.Reporting.Pdf.Rendering.PdfRendererGraphicsState.Update(PdfFont font, Brush brush, Int32 renderMode) +179
   Telerik.Reporting.Pdf.Rendering.PdfRenderer.Update(PdfFont pdfFont, Brush brush, Int32 renderMode) +184
   Telerik.Reporting.Pdf.Rendering.PdfRenderer.DrawString(String text, PdfFont font, Brush brush, RectangleF rect, Boolean rightToLeft) +404
   Telerik.Reporting.Pdf.Drawing.PdfGraphics.DrawString(String s, Font font, Brush brush, RectangleF rect, StringFormat format) +303
   Telerik.Reporting.ImageRendering.CanvasPdf.DrawStringMultiline(String s, Font font, Brush brush, RectangleF rect, StringFormat format) +954
   Telerik.Reporting.ImageRendering.TextBox.Render() +846
   Telerik.Reporting.ImageRendering.RenderingElement.RenderToPage(RectangleRF clip, RoundedFloat parentLeft, RoundedFloat parentTop, RoundedFloat parentReservedTop, RoundedFloat parentReservedBottom, RoundedFloat parentReservedLeft, RoundedFloat parentReservedRight) +2858
   Telerik.Reporting.ImageRendering.RenderingElement.RenderChildren(RectangleRF clip) +473
   Telerik.Reporting.ImageRendering.RenderingElement.RenderToPage(RectangleRF clip, RoundedFloat parentLeft, RoundedFloat parentTop, RoundedFloat parentReservedTop, RoundedFloat parentReservedBottom, RoundedFloat parentReservedLeft, RoundedFloat parentReservedRight) +3025
   Telerik.Reporting.ImageRendering.CompositionBase.RenderPageSection(PageArea pageArea, RenderingElement pageSection, Single height) +713
   Telerik.Reporting.ImageRendering.CompositionBase.ApplyPageSections() +405
   Telerik.Reporting.ImageRendering.CompositionBase.SendPhysicalPages(Boolean force) +142
   Telerik.Reporting.ImageRendering.CompositionBase.End() +145
   Telerik.Reporting.ImageRendering.CompositionPdf.End() +262
   Telerik.Reporting.ImageRendering.CompositionBase.Dispose(Boolean disposing) +94
   Telerik.Reporting.ImageRendering.CompositionPdf.Dispose(Boolean disposing) +91
   Telerik.Reporting.ImageRendering.CompositionBase.System.IDisposable.Dispose() +53
   Telerik.Reporting.ImageRendering.ImageRendererBase.RenderReport(Report report, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback) +557
   Telerik.Reporting.ImageRendering.ImageRendererBase.Telerik.Reporting.Processing.IRenderingExtension.Render(Report report, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback) +96
   Telerik.Reporting.Processing.ReportProcessor.Render(IList`1 reports, ExtensionInfo extensionInfo, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback) +2090
   Telerik.Reporting.Processing.ReportProcessor.RenderReport(String format, IReportDocument reportDocument, Hashtable deviceInfo, Hashtable renderingContext, CreateStream createStreamCallback) +814
   Telerik.ReportViewer.WebForms.ServerReport.Render(HttpResponse response, String format, Int32 pageIndex) +1390
   Telerik.ReportViewer.WebForms.ReportExportOperation.PerformOperation(NameValueCollection urlQuery, HttpContext context) +180
   Telerik.ReportViewer.WebForms.HttpHandler.ProcessRequest(HttpContext context) +501
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +1182
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +230

Some suggestion about to solve (or workaround) the problem?

Thanks

Sandro

[Peter]

Hello Sandro Cavazzoni,

Currently there are several known issues of the Azure platform itself when hosting a reporting product, namely export to PDF and Excel are not working. Take a look at the following MSDN thread where MS acknowledges the problem. 

You can check out the Medium Trust Support article to find out more about the limitations and requirements for deploying an ASP.NET application containing Telerik Reporting on a web host that imposes modified Trust permission level.

Best wishes,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Sandro Cavazzoni]

Thank you for your reply.
In a future the problems will be solved? Today i'm valuating if buy only asp.net radcontrols or the complete telerik premium collection. My decision depend from telerik reporting. If the issues will be solved in a future i can buy and use telerik reporting in my project. Instead i need to search for another solution.

Best regards

Sandro Cavazzoni

[Steve]

Hi Sandro,

We don't want to disappoint you, but most likely you would not be able to find a reporting product that supports export to PDF and XLS in medium trust. The problem is that both both formats rely on permissions that are available in Full Trust and there is not much we can do to change that.

Greetings,
Steve
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Kevin]

At least as of the June release, there shouldn't be a trust issue anymore since Azure supports full trust.  While running under Full Trust, I get the same error.

Here is the code I use to set up the export:

ReportProcessor processor = new ReportProcessor();
CMS.Reports.CurrentMember report = new CurrentMember();

processor.RenderReport("PDF", report, null);

I get the same OutOfMemory exception trying to render the report.

[Steve]

Hi Kevin,

As my colleague pointed out in the first reply, this is a problem of Windows Azure. Here is a link to a more recent thread where Microsoft acknowledges the problem with Report Viewers and export to PDF: LocalReport viewing (rdlc) report in Windows Azure gives Out of Memory Exception.

All the best,
Steve
the Telerik team

[Tolga Tari]

hi telerik,

we are getting same error.
we are not using azure services, we only using telerik report in our asp.net application.
sample code;

Telerik.Reporting.Processing.ReportProcessor reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();
Telerik.Reporting.Processing.RenderingResult result = reportProcessor.RenderReport("PDF", this.ReportViewer1.Report, null);

This error continues permanently after first occurrance. But it is uncertain to know when will occurr first time..
And another bad news, after first occurrance, any reports pdf export does not work.. All of throws "Out of memory" exception..

Web application run under full trust level.
Operating system is windows server 2008 r2 and server has 64 GB ram.
IIS configured without memory limit or time limit.
We are using telerik reporting Q2 2010 and also included service pack for Q2 2010

So we must solve this error as soon as possible.
We need some suggestion or workaround to solve the problem..
Thank you..

[Deva]

We are able using q2 2011 and the prior 2 version to export to pdf in azure... we do run into issues when our reports exceed 100 pages, even though we have set all the web config buffer settings to int32.Max in our bindings / readerquota, and added the httpruntime executiontimeout, and maxrequestlength to system.web and added a datacontractserializer maxItemsInObjectGraph to Int32.max... but below a 100 pages they seem to export just fine.  Our client is silverlight, and our ReportServer.svc is hosted in azure. (as is our client web site though the xap gets pulled down locally and run.)

-Deva

[Steve]

Hi guys,

Indeed exporting to both PDF and Excel is working correctly now. What you should have installed:

• Windows Azure SDK 1.3 (November 2010) or later
• Telerik Reporting Q3 2010 or later.

@Deva: Please use this code in the MainPage.xaml.cs:

Copy Code

public partial class MainPage : UserControl, IReportServiceClientFactory

{

    public MainPage()

    {

        InitializeComponent();

        this.ReportViewer1.ReportServiceClientFactory = this;

    }

    ReportServiceClient IReportServiceClientFactory.Create(System.Uri remoteAddress)

    {

        // if the service is used with SSL use this overload !

        var binding = new BasicHttpBinding(BasicHttpSecurityMode.Transport)

        {

            MaxBufferSize = int.MaxValue, 
            MaxReceivedMessageSize = int.MaxValue,

            ReceiveTimeout = new TimeSpan(0, 15, 0),

            SendTimeout = new TimeSpan(0, 15, 0)

        };

        var endpointAddress = new EndpointAddress(remoteAddress);

        return new ReportServiceClient(binding, endpointAddress);

    }

}

Greetings,
Steve
the Telerik team