Showing posts with label sending. Show all posts
Showing posts with label sending. Show all posts

Tuesday, March 20, 2012

Report subscription and Failure sending mail:

I am using Reporting Services 2005. SP1 is applied (version 9.0.2047). I configured one of the reports with subscription and sending
report via email. I used Report Manager to setup the report subscriptions,
but I get the following status message:


"Failure sending mail: The Report Server has encountered a configuration
error; more details in the log files"

The log file contains the following:

ERROR: Throwing
Microsoft.ReportingServices .Diagnostics.Utilities.ServerConfigurationErrorE-xception: The Report Server has encountered a configuration error. See the report server log files for more information., AuthzInitializeContextFromSid: Win32 error: 110;

Any ideas?

I am also getting the error on SQL Server 2005 with SP1 and am currently trying to get the email working.

The only bit of extra information I can give is that when I do

net helpmsg 110

I get: The system cannot open the device of file specified.

As yet, I have no idea what device or file report server is trying to open.

I'll update this message if I figure this out.

Report subscription and Failure sending mail:

I am using Reporting Services 2005. SP1 is applied (version 9.0.2047). I configured one of the reports with subscription and sending
report via email. I used Report Manager to setup the report subscriptions,
but I get the following status message:


"Failure sending mail: The Report Server has encountered a configuration
error; more details in the log files"

The log file contains the following:

ERROR: Throwing
Microsoft.ReportingServices

.Diagnostics.Utilities.ServerConfigurationErrorE-xception: The Report Server has encountered a configuration error. See the report server log files for more information., AuthzInitializeContextFromSid: Win32 error: 110;

Any ideas?

I am also getting the error on SQL Server 2005 with SP1 and am currently trying to get the email working.

The only bit of extra information I can give is that when I do

net helpmsg 110

I get: The system cannot open the device of file specified.

As yet, I have no idea what device or file report server is trying to open.

I'll update this message if I figure this out.

Monday, March 12, 2012

Report size distplays incorrectly

I have a report that I have generated in VS and using the push method I'm sending the data to the report when it displays in the web page on localhost.

When the report displays only the topleft corner of the report can be viewed, also the report taskbar has a horizontal scroll bar attached to it as the width of the report is too small. If I use any of the buttons on the report taskbar when its running, when the page is refreshed I get the crystal reports viewer object instead of the report.

I have tried to change the size of the report in code but it doesn't affect it.

Has anyone come across this before?

TIADid you set the proper Printer settings?

Wednesday, March 7, 2012

Report Server refuse to send attachments

Hi,
We recently encountered a problem with RS subscriptions: it suddenly stopped
sending attachmetns. Reports without attachments are sent without problems.
The RSReportServer.Config is defined properly (including the <SMTPServer>
and <From> properties.
This is part of the error file:
ReportingServicesService!library!3b2c!03/28/2005-12:01:20:: i INFO: Call to
RenderFirst( '/TNDReports/TicketCurrent' )
ReportingServicesService!library!3b2c!03/28/2005-12:01:20:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 1355;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
I noticed there is something with a HotFix (number KB834859) but I could not
get to it.
Server: Windows 2003 (Web server is seperated from database server)
RS Service Pack 1 installed.
SQL Server 2000 SP3a
Thanks in advance,
AvishayHi Avishay,
I believe the KB-article 834859 applies to the issue you are encountering.
As mentioined in the KB 834859, there is a known issue that
AuthzInitializeContextFromSid function passes a non-null-terminated string
to the DsGetDcName function. Apparently this issue potentially cause
problems when Windows report service tries to use this function. I've ever
seen some customers have resolved the similar issues by installing the
hotfix.
To obtain the hotfix, please contact Microsoft Product Support Services.
For a complete list of Microsoft Product Support Services phone numbers and
information about support costs, visit the following Microsoft Web site:
http://support.microsoft.com/default.aspx?scid=fh;[LN];CNTACTMS
Note In special cases, charges that are ordinarily incurred for support
calls may be canceled if a Microsoft Support Professional determines that a
specific update will resolve your problem. The usual support costs will
apply to additional support questions and issues that do not qualify for
the specific update in question.
If the issue persists, I suggest that you refer to the following article to
troubleshoot the issue:
842423 A call to the AuthzInitializeContextFromSid API function may fail
during
http://support.microsoft.com/?id=842423
If anything is unclear, feel free to let us know.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Report Server refuse to send attachments
>thread-index: AcU55EU7XhajZL6GRdOem5RG403t2w==>X-WBNR-Posting-Host: 193.27.93.1
>From: =?Utf-8?B?QXZpc2hheSBCZW4tWnZp?= <Avishay@.community.nospam>
>Subject: Report Server refuse to send attachments
>Date: Tue, 5 Apr 2005 06:35:02 -0700
>Lines: 28
>Message-ID: <B9E0730C-23D5-411F-BFE9-B7846AF2DE57@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:40070
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>Hi,
>We recently encountered a problem with RS subscriptions: it suddenly
stopped
>sending attachmetns. Reports without attachments are sent without problems.
>The RSReportServer.Config is defined properly (including the <SMTPServer>
>and <From> properties.
>This is part of the error file:
>ReportingServicesService!library!3b2c!03/28/2005-12:01:20:: i INFO: Call
to
>RenderFirst( '/TNDReports/TicketCurrent' )
>ReportingServicesService!library!3b2c!03/28/2005-12:01:20:: e ERROR:
>Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
>The Report Server has encountered a configuration error; more details in
the
>log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
>The Report Server has encountered a configuration error; more details in
the
>log files
>I noticed there is something with a HotFix (number KB834859) but I could
not
>get to it.
>Server: Windows 2003 (Web server is seperated from database server)
>RS Service Pack 1 installed.
>SQL Server 2000 SP3a
>Thanks in advance,
>Avishay
>|||Hi,
We have exactly the same problem
First I switched the report server windows account to a domain user account
(as detailed in solution 2 below (found this while searching the net)
PROBLEM #1::
ReportingServicesService!libra­ry!878!04/19/2004-11:42:01:: e ERROR: Throwing
Microsoft.ReportingServices.Di­agnostics.Utilities.ServerConf­igurationErrorEx
ception: The Report Server has encountered a configuration error; more
details in the log files, AuthzInitializeContextFromSid: Win32 error: 1355;
Info:
Microsoft.ReportingServices.Di­agnostics.Utilities.ServerConf­igurationErrorEx
ception: The Report Server has encountered a configuration error; more
details in the log files
The key is the Win32 error 1355. This is a rights issue.
SOLUTION #1: The fix is to obtain from Microsoft hotfix #834859. This may
require opening a Support Call. Afte this was installed, that error went
away.
Still no reports being generated. Now we get a
different error when the email attachment is being processed for delivery.
PROBLEM #2:
ReportingServicesService!libra­ry!c10!02/25/2004-15:31:04:: e ERROR: Throwing
Microsoft.ReportingServices.Di­agnostics.Utilities.ServerConf­igurationErrorEx
ception: The Report Server has encountered a configuration error; more
details in the log files, AuthzInitializeContextFromSid: Win32 error: 5;
possible reason - service account doesn't have rights to check domain user
SIDs.; Info:
Microsoft.ReportingServices.Di­agnostics.Utilities.ServerConf­igurationErrorEx
ception: The Report Server has encountered a configuration error; more
details in the log files.
SOLUTION #2.
This second error was due to security issues. The Report Server NT Service
was running under the NT Authority\Network Service account. This account is
being seen by the domain controller when it makes the Authz call as an
anonymous user. So we need to change the account to a domain user account so
it will have sufficient privileges to make the Authz call this works since
their domain was a Windows 2000 domain and running in Mixed mode. To change
the Report Server NT Service account, we went through these steps.
1. Delete the references to the old key: rskeymgmt -r <installation id> (the
installation ID can be found in the rsreportserver.config file
2. Stop IIS and the Report Server windows service
3. Change the account service runs under
4. start IIS and the Report Server windows service
5. Reapply the encryption key: rskeymgmt -a -f <filename from step 1> -p
<password from step 1>
This didn't work so we installed Service Pack 1 for Windows2003 and it all
started working!
"William Wang[MSFT]" wrote:
> Hi Avishay,
> I believe the KB-article 834859 applies to the issue you are encountering.
> As mentioined in the KB 834859, there is a known issue that
> AuthzInitializeContextFromSid function passes a non-null-terminated string
> to the DsGetDcName function. Apparently this issue potentially cause
> problems when Windows report service tries to use this function. I've ever
> seen some customers have resolved the similar issues by installing the
> hotfix.
> To obtain the hotfix, please contact Microsoft Product Support Services.
> For a complete list of Microsoft Product Support Services phone numbers and
> information about support costs, visit the following Microsoft Web site:
> http://support.microsoft.com/default.aspx?scid=fh;[LN];CNTACTMS
> Note In special cases, charges that are ordinarily incurred for support
> calls may be canceled if a Microsoft Support Professional determines that a
> specific update will resolve your problem. The usual support costs will
> apply to additional support questions and issues that do not qualify for
> the specific update in question.
> If the issue persists, I suggest that you refer to the following article to
> troubleshoot the issue:
> 842423 A call to the AuthzInitializeContextFromSid API function may fail
> during
> http://support.microsoft.com/?id=842423
> If anything is unclear, feel free to let us know.
> Sincerely,
> William Wang
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> >Thread-Topic: Report Server refuse to send attachments
> >thread-index: AcU55EU7XhajZL6GRdOem5RG403t2w==> >X-WBNR-Posting-Host: 193.27.93.1
> >From: =?Utf-8?B?QXZpc2hheSBCZW4tWnZp?= <Avishay@.community.nospam>
> >Subject: Report Server refuse to send attachments
> >Date: Tue, 5 Apr 2005 06:35:02 -0700
> >Lines: 28
> >Message-ID: <B9E0730C-23D5-411F-BFE9-B7846AF2DE57@.microsoft.com>
> >MIME-Version: 1.0
> >Content-Type: text/plain;
> > charset="Utf-8"
> >Content-Transfer-Encoding: 7bit
> >X-Newsreader: Microsoft CDO for Windows 2000
> >Content-Class: urn:content-classes:message
> >Importance: normal
> >Priority: normal
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> >Newsgroups: microsoft.public.sqlserver.reportingsvcs
> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> >Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> >Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:40070
> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> >
> >Hi,
> >We recently encountered a problem with RS subscriptions: it suddenly
> stopped
> >sending attachmetns. Reports without attachments are sent without problems.
> >The RSReportServer.Config is defined properly (including the <SMTPServer>
> >and <From> properties.
> >This is part of the error file:
> >ReportingServicesService!library!3b2c!03/28/2005-12:01:20:: i INFO: Call
> to
> >RenderFirst( '/TNDReports/TicketCurrent' )
> >ReportingServicesService!library!3b2c!03/28/2005-12:01:20:: e ERROR:
> >Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
> ception:
> >The Report Server has encountered a configuration error; more details in
> the
> >log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> > Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
> ception:
> >The Report Server has encountered a configuration error; more details in
> the
> >log files
> >
> >I noticed there is something with a HotFix (number KB834859) but I could
> not
> >get to it.
> >Server: Windows 2003 (Web server is seperated from database server)
> >RS Service Pack 1 installed.
> >SQL Server 2000 SP3a
> >
> >Thanks in advance,
> >
> >Avishay
> >
> >
>