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 domainuser 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...
No comments:
Post a Comment