Showing posts with label delivered. Show all posts
Showing posts with label delivered. Show all posts

Friday, March 23, 2012

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

Monday, March 12, 2012

Reports Delivered Email On Demand

The business people at my office would like be able to generate emails with
the results of a SQL query attached as an excel spreadsheet on demand.
Please note that these queries take more than 30 seconds so any use needs to
be asynchronous. Iâ'd like to have the same functionality as email sent to
subscribers, but without creating a subscription. Is there a way to do this
in SQL Reporting Services? If not is there a good alternative?
Thanks for any help.Hello,
Based on my experience, you need to write your customer .net code to
generate the excel file and send it to the user.
Reporting Services has provide a Web Services Interface and you could use
this to render the report to Excel.
Then you could use the code to send the file to the customer.
Here are the articles about how to use Web Services to render the Report:
How to create a sample application that uses the Reporting Services SOAP
APIs to render a report to a selected file format on a Web page
http://support.microsoft.com/kb/875447/en-us
ReportingService.Render Method (Reporting Services 2000)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/
rsp_ref_soapapi_service_lz_6x0z.asp
ReportExecutionService.Render Method (Reporting Services 2005)
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswe
bservice.rsexecutionservice2005.reportexecutionservice.render.aspx
Also, here is a sample for how to send the email
Send Mail Sample
http://msdn2.microsoft.com/en-us/library/ms173026.aspx
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)