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
>>

Reports rendered bad in Firefox...

Because of some peculiar way of using CSS, the reports aren't rendered correctly in Firefox. I've tryed specifying different rendering options (html 4 for instance) but it didn't help. What are my options on this? I could use Webservices (SOAP) and wrap SSRS in a proxy, but I'd have to parse reports and extract the data and build my own presentation layer. This way I'd be missing half of the SSRS functionality. Any ideas?You also loose features in Firefox and besides the numerous display bugs, their is also a Session TimeOut bug. Essentially SQL reports is IE only.

http://msdn2.microsoft.com/en-us/library/ms156511.aspx

The following features are not supported in third-party browsers:

Document map
|||
Indeed. We have now ditched Ms Server completely and looking for alternatives. Too hard to integrate with anything.

ReportRenderingException when exporting to excel

Hi all
I have a report that works fine for html and pdf rendering. But when I
export it to excel RS throws a ReportRenderingException. The error is "Stack
empty". Anything else like PDF, TIFF... is rendering without errors. Does
anyone has similar problems or knows whats wrong? Can this be a bug?
Here's an extraction of the log file:
w3wp!library!ed8!12/07/2004-17:03:20:: i INFO: Call to RenderNext(
'/Astrada/Ferienuebersicht' )
w3wp!chunks!ed8!12/07/2004-17:03:20:: i INFO: ###
GetReportChunk('RenderingInfo_EXCEL', 2), chunk was not found!
this=cdb86ab2-85ce-41b8-9edc-3faffec8410b
w3wp!reportrendering!ed8!12/07/2004-17:03:24:: 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.InvalidOperationException: Stack empty.
at System.Collections.Stack.Pop()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelFormulaHandler.GetPostFixNotation(String[] tokens, ArrayList finalExpr)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelFormulaHandler.ProcessFormula(String formula, ArrayList& postFixList, Hashtable& literals)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateExcelFormula(IReportItemInfo
reportItemInfo, String outputTypeCode, Hashtable& literals)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderTextBox(ReportItemInfo
reportItemInfo, PageCell pageCell, PageTableGrid pageTableGrid, Hashtable&
duplicateItemsTable, Int32 row, Int32 col, Boolean addHeaderRows)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderGridCell(PageLayout
pageLayout, Int32 row, Int32 col, Hashtable& duplicateItemsTable, Boolean
addHeaderRows)
at
Microsoft.ReportingServices.Rendering.BIFFUtility.WorkSheet.WriteRowBlocksAndCells(ExcelRenderer
excelRenderer, Stream stream, UInt32 indexBeginOffsetPosition, Int32 minCol,
Int32 maxCol)
at
Microsoft.ReportingServices.Rendering.BIFFUtility.BaseWorkSheet.WriteWorkSheet(ExcelRenderer excelRenderer, Stream stream, Int32 offset)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageLayout(PageLayout pageLayout, Int32& currentPageNumber, Stack& stack)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection
pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout&
lastPageLayout)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateWorkSheets()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateMainSheet()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderExcelWorkBook(CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessReport(CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
-- End of inner exception stack trace --
w3wp!webserver!ed8!12/07/2004-17:03:30:: e ERROR: Reporting Services error
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.InvalidOperationException: Stack empty.
Thanks for any help!
M. PeyerThis problem occurred for me when I had a value expression in a text
box on the group header/footer. I am running SP1. Before SP1 was loaded
the report would export to excel without the Stack Empty but the
expression would not evaluate. With SP1 I get the Stack Empty error.
Once I removed the expressions the stack empty error went away.
Steve|||This problem occurred for me when I had a value expression in a text
box on the group header/footer. I am running SP1. Before SP1 was loaded
the report would export to excel without the Stack Empty but the
expression would not evaluate. With SP1 I get the Stack Empty error.
Once I removed the expressions the stack empty error went away.
Steve