PDF Rendering Fails with Reporting Service for some JPG images... RSS

• • Reply
  

  coolsteam

  0 Points

  2 Posts

  PDF Rendering Fails with Reporting Service for some JPG images...

  Jun 13, 2010 12:14 AM|LINK

  Hi, I am using Microsoft SQL server 2008 reporting service to generate PDF reports for my application.

  All was working fine, until I start to get the following error. I came to know after some google that this is because of some JPG images having metadata. If I have png image then its fine, but for me to convert these jpg to png is not an option, since all I have available is JPG.

  I installed service pack 1 as well, but its same. I have following SQL server installed.

  "Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)   Mar 29 2009 10:11:52   Copyright (c) 1988-2008 Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2)"

  I found few solutions like mentioned here http://support.microsoft.com/kb/967618 But thats for 2005.  Surprisingly, already solved error for 2005 coming for 2008.
  
  Am I missing something? Please help me.

  Non-negative number required.
  Parameter name: value

  Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
  
  Exception Details: System.ArgumentOutOfRangeException: Non-negative number required.
  Parameter name: value
  
  Source Error: 
  
  

  An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

  
  Stack Trace: 
  
  

  [ArgumentOutOfRangeException: Non-negative number required. Parameter name: value] System.IO.MemoryStream.set_Position(Int64 value) +10435528 Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.MonochromeJpeg(MemoryStream memStream) +347 Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessImage(CanvasImagePDF image, Double left, Double top, Double width, Double height, Boolean scaleImage) +1270 Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawImage(OutlineObjects outlines, CanvasImage image, Double left, Double top, Double width, Double height) +218 Microsoft.ReportingServices.Rendering.ImageRenderer.Image.RenderToPage(Measurement parentClipBorder) +1039 Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder) +271 Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder) +271 Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder) +573 Microsoft.ReportingServices.Rendering.ImageRenderer.Table.RenderToPage(Measurement parentClipBorder) +139 Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder) +573 Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement parentClipBorder) +260 Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder) +271 Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase theComposition, Report theReport, Boolean needTotalPages, Int32 startPage, Int32 endPage, Boolean render) +661 Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStreamCallback, Int32 streamPageNumber) +553 Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream) +66 [ReportRenderingException: An error occurred during rendering of the report.] Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream) +194 Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached) +1397 [WrapperReportRenderingException: An error occurred during rendering of the report.] Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached) +2337 Microsoft.Reporting.LocalService.RenderWithDataCache(PreviewItemContext itemContext, ParameterInfoCollection reportParameters, IEnumerable dataSources, DatasourceCredentialsCollection credentials, IRenderingExtension renderer, ReportProcessing repProc, CreateAndRegisterStream createStreamCallback, ReportRuntimeSetup runtimeSetup) +1749 Microsoft.Reporting.LocalService.Render(PreviewItemContext itemContext, Boolean allowInternalRenderers, ParameterInfoCollection reportParameters, IEnumerable dataSources, DatasourceCredentialsCollection credentials, CreateAndRegisterStream createStreamCallback, ReportRuntimeSetup runtimeSetup, ProcessingMessageList& warnings) +755 Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, CreateAndRegisterStream createStreamCallback, Warning[]& warnings) +413 [LocalProcessingException: An error occurred during local report processing.] Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, CreateAndRegisterStream createStreamCallback, Warning[]& warnings) +605 Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, String& mimeType, String& encoding, String& fileNameExtension, String[]& streams, Warning[]& warnings) +181 Microsoft.Reporting.WebForms.LocalReport.Render(String format, String deviceInfo, String& mimeType, String& encoding, String& fileNameExtension, String[]& streams, Warning[]& warnings) +72 iXXX.ixxx.Page_Load(Object sender, EventArgs e) in .... System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +42 System.Web.UI.Control.OnLoad(EventArgs e) +132 System.Web.UI.Control.LoadRecursive() +66 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2428

   Regards

  ssrs 2008 pdf rendering jpg image

• • Reply
  

  You-Hu Fu

  Star

  8174 Points

  795 Posts

  Re: PDF Rendering Fails with Reporting Service for some JPG images...

  Jun 16, 2010 08:44 AM|LINK

  Hi,

  This is an old bug in Sql Server Reporting Service 2005, however it has been fixed. This bug should not exist in Sql Server Reporting Service 2008. So I would recommend you update the latest sevice page for Sql Server Reporting Service 2008. Here to workaround this issue, you could convert the JPEG images you are using to PNG images. You can try to see whether it helps.

  Regards,

  Challen Fu

  Please mark the replies as answers if they help or unmark if not.
  Feedback to us
  Microsoft One Code Framework
• • Reply
  

  coolsteam

  0 Points

  2 Posts

  Re: PDF Rendering Fails with Reporting Service for some JPG images...

  Jun 16, 2010 09:28 PM|LINK

  Hi,

  thanks for you reply.

  i understand that this is old bug for 2005 but its appearing for me on SSRS 2008 as well. i have put the latest service pack as well. but to no avail.

  it works when image is png but for me to work with only is not an option since i have to work on already uploaded jpg images and out of them some images give me this error.

  thanks again.

• • Reply
  

  cadsjo

  Member

  2 Points

  1 Post

  Re: PDF Rendering Fails with Reporting Service for some JPG images...

  Sep 16, 2010 10:27 AM|LINK

  Hi,

  
  

  You can try to convert the jpg images to png images in memory... And then showing them on the reports.

  
  

  HTH,

  Cadsjo

• • Reply
  

  Andacious

  Member

  2 Points

  1 Post

  Re: PDF Rendering Fails with Reporting Service for some JPG images...

  Feb 05, 2013 07:30 PM|LINK

  We also ran into this issue on our SQL reporting server (10.50.2550.0). The a customer had uploaded a custom image for a report that triggered this bug. The resolution was to convert the image from a JPG to a PNG.