Showing posts with label subscription. Show all posts
Showing posts with label subscription. Show all posts

Wednesday, March 21, 2012

Problem with HTML slightly garbled sending email as web archive

I'm experiencing a problem with HTML code being slightly messed up when
sending a subscription via email in web archive format.
The report displays fine in the Report Manager. However, went emailed some
whitespace is seemingly randomly added to the HTML page. Depending on where
that whitespace is, this might not be a problem. But if the whitespace is
inserted in some places within an HTML tag, then the tag isn't rendered
properly.
Example: a space is added following the "<" in "</DIV>", thus giving "<
/DIV>". Since this is invalid HTML, it displays as text in the report.
Example: a cell in a table is defined as right-aligned and in a specific
font. All 25 rows in the table (x 3 columns = 75 cells) all display
correctly:
<P class=MsoNormal style="TEXT-ALIGN: right" align=right><FONT
face="Eras Medium ITC" color=black size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Eras
Medium ITC'">
*EXCEPT* one cell, where the following HTML is used:
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">
Why did RS render this cell differently?This might be an issue with the local SMTP. Are you using the pickup
directory to send email?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Columbia Kai" <Columbia Kai@.discussions.microsoft.com> wrote in message
news:A0190874-9273-4F1C-9BD1-CF0CEB79616D@.microsoft.com...
> I'm experiencing a problem with HTML code being slightly messed up when
> sending a subscription via email in web archive format.
> The report displays fine in the Report Manager. However, went emailed
> some
> whitespace is seemingly randomly added to the HTML page. Depending on
> where
> that whitespace is, this might not be a problem. But if the whitespace is
> inserted in some places within an HTML tag, then the tag isn't rendered
> properly.
> Example: a space is added following the "<" in "</DIV>", thus giving "<
> /DIV>". Since this is invalid HTML, it displays as text in the report.
> Example: a cell in a table is defined as right-aligned and in a specific
> font. All 25 rows in the table (x 3 columns = 75 cells) all display
> correctly:
> <P class=MsoNormal style="TEXT-ALIGN: right" align=right><FONT
> face="Eras Medium ITC" color=black size=2><SPAN
> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Eras
> Medium ITC'">
> *EXCEPT* one cell, where the following HTML is used:
> <P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
> style="FONT-SIZE: 12pt">
> Why did RS render this cell differently?|||Thanks for your reply, Daniel.
I've tried this with two SMTP mail servers, both with the same result. I
changed the definition via the RSReportServer.config file.
Neither SMTP server is on my local machine.
One resides on a Win2003 box and is a MS mail server; the other resides on a
Win2000 Server box and is a product called Merak Mail Server. Ultimately
they send via the Columbia University mail server, which is sendmail, I
believe.
(I'm not a systems guy so sorry if my answers aren't dead-on what you asked
for.)
Please also see my comments on another post title "Web archive subrsciption
gets messed up" (note misspelling of 'subscription'). I ran into an
identical problem like this when sending email from an Oracle PL/SQL program.
The resolution is to intersprese CRLF into the msg at least every 990 bytes.
Thanks Daniel. This is the one problem that's keeping me from implementing
RS and beginning to retire Crystal Enterprise.
"Daniel Reib [MSFT]" wrote:
> This might be an issue with the local SMTP. Are you using the pickup
> directory to send email?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Columbia Kai" <Columbia Kai@.discussions.microsoft.com> wrote in message
> news:A0190874-9273-4F1C-9BD1-CF0CEB79616D@.microsoft.com...
> > I'm experiencing a problem with HTML code being slightly messed up when
> > sending a subscription via email in web archive format.
> >
> > The report displays fine in the Report Manager. However, went emailed
> > some
> > whitespace is seemingly randomly added to the HTML page. Depending on
> > where
> > that whitespace is, this might not be a problem. But if the whitespace is
> > inserted in some places within an HTML tag, then the tag isn't rendered
> > properly.
> >
> > Example: a space is added following the "<" in "</DIV>", thus giving "<
> > /DIV>". Since this is invalid HTML, it displays as text in the report.
> >
> > Example: a cell in a table is defined as right-aligned and in a specific
> > font. All 25 rows in the table (x 3 columns = 75 cells) all display
> > correctly:
> > <P class=MsoNormal style="TEXT-ALIGN: right" align=right><FONT
> > face="Eras Medium ITC" color=black size=2><SPAN
> > style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Eras
> > Medium ITC'">
> > *EXCEPT* one cell, where the following HTML is used:
> > <P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
> > style="FONT-SIZE: 12pt">
> > Why did RS render this cell differently?
>
>|||I haven't done this yet but what was suggested to me (I too am having
problems and am using an external smtp server too) was to use Windows 2003
smtp service and have it forward/route (not sure the term) to the external
smtp server. The Windows 2003 smtp server is configured to be looking at a
directory and forwarding things on from there. Then you have your report
saved to the pickup directory. Note that I haven't done this so I am a
little vague on how it all works.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Columbia Kai" <ColumbiaKai@.discussions.microsoft.com> wrote in message
news:8995F878-CB68-4766-BB00-654D7580BAF1@.microsoft.com...
> Thanks for your reply, Daniel.
> I've tried this with two SMTP mail servers, both with the same result. I
> changed the definition via the RSReportServer.config file.
> Neither SMTP server is on my local machine.
> One resides on a Win2003 box and is a MS mail server; the other resides on
> a
> Win2000 Server box and is a product called Merak Mail Server. Ultimately
> they send via the Columbia University mail server, which is sendmail, I
> believe.
> (I'm not a systems guy so sorry if my answers aren't dead-on what you
> asked
> for.)
> Please also see my comments on another post title "Web archive
> subrsciption
> gets messed up" (note misspelling of 'subscription'). I ran into an
> identical problem like this when sending email from an Oracle PL/SQL
> program.
> The resolution is to intersprese CRLF into the msg at least every 990
> bytes.
> Thanks Daniel. This is the one problem that's keeping me from
> implementing
> RS and beginning to retire Crystal Enterprise.
>
> "Daniel Reib [MSFT]" wrote:
>> This might be an issue with the local SMTP. Are you using the pickup
>> directory to send email?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Columbia Kai" <Columbia Kai@.discussions.microsoft.com> wrote in message
>> news:A0190874-9273-4F1C-9BD1-CF0CEB79616D@.microsoft.com...
>> > I'm experiencing a problem with HTML code being slightly messed up when
>> > sending a subscription via email in web archive format.
>> >
>> > The report displays fine in the Report Manager. However, went emailed
>> > some
>> > whitespace is seemingly randomly added to the HTML page. Depending on
>> > where
>> > that whitespace is, this might not be a problem. But if the whitespace
>> > is
>> > inserted in some places within an HTML tag, then the tag isn't rendered
>> > properly.
>> >
>> > Example: a space is added following the "<" in "</DIV>", thus giving "<
>> > /DIV>". Since this is invalid HTML, it displays as text in the report.
>> >
>> > Example: a cell in a table is defined as right-aligned and in a
>> > specific
>> > font. All 25 rows in the table (x 3 columns = 75 cells) all display
>> > correctly:
>> > <P class=MsoNormal style="TEXT-ALIGN: right" align=right><FONT
>> > face="Eras Medium ITC" color=black size=2><SPAN
>> > style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY:
>> > 'Eras
>> > Medium ITC'">
>> > *EXCEPT* one cell, where the following HTML is used:
>> > <P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
>> > style="FONT-SIZE: 12pt">
>> > Why did RS render this cell differently?
>>sql

Monday, February 20, 2012

Problem with data-driven subscription

I have a data-driven subscription that launches once a day and delivers

emails to subscribers. The problem is that it delivers only about half

the emails. It runs ok and then it produces error. I ran it once and it

ran ok and completed without errors. 20 minutes later it produced

errors. Log looks like this:

ReportingServicesService!library!c!11/16/2006-10:27:45::

i INFO: Call to RenderFirst( '/Subscribed notifications/Subscribed

notifications' )

ReportingServicesService!library!11!11/16/2006-10:27:45:: e ERROR:

Throwing

Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:

The report server has encountered a configuration error. See the report

server log files for more information., AuthzInitializeContextFromSid:

Win32 error: 58;

Info:

Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:

The report server has encountered a configuration error. See the report

server log files for more information.

ReportingServicesService!library!c!11/16/2006-10:27:45:: e ERROR:

Throwing

Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:

The report server has encountered a configuration error. See the report

server log files for more information., AuthzInitializeContextFromSid:

Win32 error: 58;

Info:

Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:

The report server has encountered a configuration error. See the report

server log files for more information.

ReportingServicesService!library!11!11/16/2006-10:27:45:: i INFO:

Initializing EnableExecutionLogging to 'True' as specified in

Server system properties.

ReportingServicesService!library!c!11/16/2006-10:27:45:: i INFO:

Initializing EnableExecutionLogging to 'True' as specified in

Server system properties.

ReportingServicesService!emailextension!11!11/16/2006-10:27:45:: Error

sending email.

Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The

report server has encountered a configuration error. See the report

server log files for more information. >

Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:

The report server has encountered a configuration error. See the report

server log files for more information.

at Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)

at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName)

at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken)

at

Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String

userName, IntPtr userToken, Byte[] secDesc, ReportOperation

requiredOperation)

at

Microsoft.ReportingServices.Library.RSService.GetReportAndDataSourcesForExecution(ClientRequest

session, CatalogItemContext itemContext, String queryParametersXml,

Boolean& hasData, DataSourceInfoCollection& dataSources,

String& reportProperties, ReportSnapshot& intermediateSnapshot,

Guid& reportId, ReportSnapshot& snapshotData, String&

description, Boolean& cachingRequested, DateTime&

executionDateTime, DateTime& expirationDateTime, Int32&

execOptions, Boolean& foundInCache)

at

Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext

reportContext, ClientRequest session, Warning[]& warnings,

ParameterInfoCollection& effectiveParameters)

at

Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext

reportContext, ClientRequest session, Warning[]& warnings,

ParameterInfoCollection& effectiveParameters, String[]&

secondaryStreamNames)

at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()

at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()

End of inner exception stack trace

at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()

at

Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService

rs, CatalogItemContext reportContext, ClientRequest session, JobType

type, Warning[]& warnings, ParameterInfoCollection&

effectiveParameters, String[]& secondaryStreamNames)

at Microsoft.ReportingServices.Library.ReportImpl.Render(String renderFormat, String deviceInfo)

at

Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage

message, Notification notification, SubscriptionData data)

at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)

at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)

ReportingServicesService!emailextension!c!11/16/2006-10:27:45:: Error

sending email.

Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The

report server has encountered a configuration error. See the report

server log files for more information. >

Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:

The report server has encountered a configuration error. See the report

server log files for more information.

at Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)

at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName)

at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken)

at

Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String

userName, IntPtr userToken, Byte[] secDesc, ReportOperation

requiredOperation)

at

Microsoft.ReportingServices.Library.RSService.GetReportAndDataSourcesForExecution(ClientRequest

session, CatalogItemContext itemContext, String queryParametersXml,

Boolean& hasData, DataSourceInfoCollection& dataSources,

String& reportProperties, ReportSnapshot& intermediateSnapshot,

Guid& reportId, ReportSnapshot& snapshotData, String&

description, Boolean& cachingRequested, DateTime&

executionDateTime, DateTime& expirationDateTime, Int32&

execOptions, Boolean& foundInCache)

at

Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext

reportContext, ClientRequest session, Warning[]& warnings,

ParameterInfoCollection& effectiveParameters)

at

Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext

reportContext, ClientRequest session, Warning[]& warnings,

ParameterInfoCollection& effectiveParameters, String[]&

secondaryStreamNames)

at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()

at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()

End of inner exception stack trace

at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()

at

Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService

rs, CatalogItemContext reportContext, ClientRequest session, JobType

type, Warning[]& warnings, ParameterInfoCollection&

effectiveParameters, String[]& secondaryStreamNames)

at Microsoft.ReportingServices.Library.ReportImpl.Render(String renderFormat, String deviceInfo)

at

Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage

message, Notification notification, SubscriptionData data)

at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)

at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification

Any ideas? Am running SQL Server 2005 with SP1.

As it seems it displays the subreports fine until one point when the

generated report includes an error message that a subreport couldn't be

shown and then it just stops generating and mailing the reports. Please

help...|||

Subscription fails with Win32 error 58 (ERROR_BAD_NET_RESP): The specified server cannot perform the requested operation. Error happens during report rendering when report server tries to check subscription owner’s access rights, within the IsAdmin check. Error seems to be intermittent as other e-mails for the same subscription succeed. It looks like error is caused by problems with network or AD, and is not directly related to SSRS.

It may be another flavor of the problem described at http://support.microsoft.com/kb/842423/en-us

Check this posting – it’s about identical error: http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/9ee81fc7d5a31c79/8f6d34a993478e8c?lnk=st&q=AuthzInitializeContextFromSid+error+58&rnum=2&hl=en#8f6d34a993478e8c

Couple KBs below are not related to SSRS but still deal with Win32 error 58:

http://support.microsoft.com/kb/900345

http://support.microsoft.com/kb/896427

|||I changed the Reporting Services Windows service to run under a domain

user account and my domain admin configured the Microsoft Windows

domain after that didn't work. Still the same error. I am waiting for

the server admin to apply the update from the last link and hope for

the best. I really want to thank you for the effort to help me with

this problem but my question is what to do if that doesn't work either.

What

is there left for me to do but to reinstall SQL Server and hope for the

best? What really bugs me about this is that everything worked fine for

about 8 months and then one Windows 2k3 update deleted a dll from SQL

Server, managed to resolve that without reinstall, and now again

Windows 2k3 update messed with the SQL Server... Will the SP2 of the

SQL Server fix any of the problems and the vulnerability to system

updates?|||Please, help anyone? Much appreciated...