ReportServer Service Issue

We have multiple reports that are rendered in pdf format and delivered using
the email extension. We have started experiencing a rendering error that
stops the reports form rendering/delivery and only seems to be fixed after
restarting the ReportServer service. Could this be a timing issue? We have
multiple reports kicking off at the same time that render in pdf format. Any
help would be greatly appreciated.
Thanks,
SteveThe first thing to do is to go to the Logs for Report Server, generally under
MSSQL.3 directory of your install... Look there for clues...
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Steve Bennett" wrote:
> We have multiple reports that are rendered in pdf format and delivered using
> the email extension. We have started experiencing a rendering error that
> stops the reports form rendering/delivery and only seems to be fixed after
> restarting the ReportServer service. Could this be a timing issue? We have
> multiple reports kicking off at the same time that render in pdf format. Any
> help would be greatly appreciated.
> Thanks,
> Steve
>
>|||This is the first exception in the log file, a generic GDI+ error and then
it cascades from there...
ReportingServicesService!reportrendering!524!01/30/2006-04:00:13:: e ERROR:
Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.Runtime.InteropServices.ExternalException: A generic
error occurred in GDI+.
at System.Drawing.Graphics.MeasureString(String text, Font font, SizeF
layoutArea, StringFormat stringFormat)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasFont.LineHeight(Graphics
graphics, SizeF maxSizeF)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasBase.LineHeight(CanvasFont
font)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.TextBox.CalculateItemMeasurement(Orientation
orientation)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItem.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
theComposition, Report theReport, Boolean needTotalPages, Int32 startPage,
Int32 endPage, Boolean render)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport.RenderReport(Report
report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
evaluateHeaderFooterExpressions, CreateAndRegisterStream
createAndRegisterStreamCallback)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
A_0, GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
-- End of inner exception stack trace --
ReportingServicesService!library!524!01/30/2006-04:00:13:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!notification!524!01/30/2006-04:00:13:: Notification
4a595bbc-4073-48ac-ac3c-e39b1aa50018 completed. Success: False, Status:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., DeliveryExtension: Printer Delivery Sample, Report: TMP
ExceptionConformance Report, Attempt 1
ReportingServicesService!dbpolling!524!01/30/2006-04:00:13::
NotificationPolling finished processing item
4a595bbc-4073-48ac-ac3c-e39b1aa50018
ReportingServicesService!reportrendering!1210!01/30/2006-04:00:18:: e ERROR:
Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.Runtime.InteropServices.ExternalException: A generic
error occurred in GDI+.
at System.Drawing.Graphics.MeasureString(String text, Font font, SizeF
layoutArea, StringFormat stringFormat)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasFont.LineHeight(Graphics
graphics, SizeF maxSizeF)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasBase.LineHeight(CanvasFont
font)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.TextBox.CalculateItemMeasurement(Orientation
orientation)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItem.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
theComposition, Report theReport, Boolean needTotalPages, Int32 startPage,
Int32 endPage, Boolean render)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport.RenderReport(Report
report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
evaluateHeaderFooterExpressions, CreateAndRegisterStream
createAndRegisterStreamCallback)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
A_0, GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
-- End of inner exception stack trace --
ReportingServicesService!library!1210!01/30/2006-04:00:18:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!notification!1210!01/30/2006-04:00:18::
Notification d1ffd955-b678-4a68-83d2-dddfffa5fe9e completed. Success:
False, Status: Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., DeliveryExtension: Printer Delivery Sample, Report: GWD
ExceptionConformance Report, Attempt 1
Sorry, the first reply went to the wrong message...
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:687E1061-75DB-400E-BB7A-5975FE043A9B@.microsoft.com...
> The first thing to do is to go to the Logs for Report Server, generally
> under
> MSSQL.3 directory of your install... Look there for clues...
>
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Steve Bennett" wrote:
>> We have multiple reports that are rendered in pdf format and delivered
>> using
>> the email extension. We have started experiencing a rendering error that
>> stops the reports form rendering/delivery and only seems to be fixed
>> after
>> restarting the ReportServer service. Could this be a timing issue? We
>> have
>> multiple reports kicking off at the same time that render in pdf format.
>> Any
>> help would be greatly appreciated.
>> Thanks,
>> Steve
>>