|
manju1234
Starting Member
1 Posts |
 Posted - 12/27/2012 : 03:25:48
|
Hi,
I have SQL server 2005 Reporting service setup for our TFS2010 reports, with some of our customized report(.rdl) Used two data source 'Tfs2010ReportDS' & 'Tfs2010OlapReportDS'comon for all the reports.
Issue: Everything was working fine till last week, now when i try to execute/view for ONE report I am getting the below error
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'dsStates'. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
-There was no changes in datasource and user credentials but still one report is not working.
- There is no subscription set for this report, but stiil its giving the some mail communication error.
Some more logs from SQL reporing :
</Header>library!WindowsService_36!1c78!12/27/2012-00:00:01:: i INFO: Schedule 40498cbd-3f1e-4d18-89f9-f23425236b3e executed at 12/27/2012 00:00:01.
schedule!WindowsService_36!1c78!12/27/2012-00:00:01:: Creating Time based subscription notification for subscription: e0950945-b03d-4fbd-95de-85cae86ea102
library!WindowsService_36!1c78!12/27/2012-00:00:01:: i INFO: Schedule 40498cbd-3f1e-4d18-89f9-f23425236b3e execution completed at 12/27/2012 00:00:01.
notification!WindowsService_36!11c8!12/27/2012-00:00:04:: i INFO: Handling subscription e0950945-b03d-4fbd-95de-85cae86ea102 to report Bug Status, owner: AMERICAS\USRIOGO, delivery extension: Report Server Email.
library!WindowsService_36!11c8!12/27/2012-00:00:04:: i INFO: RenderForNewSession('/TfsReports/DefaultCollection/800xA for PG Vision/Bugs/Bug Status')
library!WindowsService_36!11c8!12/27/2012-00:00:05:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. , AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service account doesn't have rights to check domain user SIDs.;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.
library!WindowsService_36!11c8!12/27/2012-00:00:05:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
emailextension!WindowsService_36!11c8!12/27/2012-00:00:05:: e ERROR: Error sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The report server has encountered a configuration error. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.
at Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsUserMemebrOfGroup(String userName, IntPtr groupSid)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdminImpl(String userName, IntPtr userToken)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.<>c__DisplayClass7.<CheckAccess>b__6()
at Microsoft.ReportingServices.Diagnostics.RevertImpersonationContext.<>c__DisplayClass1.<Run>b__0(Object state)
at System.Security.SecurityContext.runTryCode(Object userData)
at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
at System.Security.SecurityContext.Run(SecurityContext securityContext, ContextCallback callback, Object state)
at Microsoft.ReportingServices.Diagnostics.RevertImpersonationContext.Run(ContextBody callback)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.<>c__DisplayClass22.<CheckAccess>b__20()
at Microsoft.ReportingServices.Library.AuthorizationExtensionBoundary.Invoke(Method m)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper, String reportPath)
at Microsoft.ReportingServices.Library.SecurityRequirements.CheckAccess(ItemType itemType, Byte[] securityDescriptor, String itemPath)
at Microsoft.ReportingServices.Library.DefinitionLoader.GetParameterDefinition(CatalogItemContext itemContext, String historyId, Boolean forRendering, SecurityRequirements requirements)
at Microsoft.ReportingServices.Library.RSService.GetReportParameters(ClientRequest session, CatalogItemContext reportContext, Boolean forRendering)
at Microsoft.ReportingServices.Library.RSServiceDataProvider.GetParameters(ClientRequest session, CatalogItemContext reportContext)
at Microsoft.ReportingServices.Library.RenderForNewSession.GetReportParameters()
at Microsoft.ReportingServices.Library.RenderForNewSession.GetReportMetadata()
at Microsoft.ReportingServices.Library.RenderForNewSession.get_ExecuteExistingSnapshot()
at Microsoft.ReportingServices.Library.RenderForNewSession.GetExecutionStrategy()
at Microsoft.ReportingServices.Library.ReportExecutionBase.InternalExecuteReport()
at Microsoft.ReportingServices.Library.ReportExecutionBase.Execute()
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at Microsoft.ReportingServices.Library.ExecutionDisposerProxy.ExecuteReport()
at Microsoft.ReportingServices.Library.RenderReportAction.PerformExecution()
at Microsoft.ReportingServices.Library.RenderReportAction.Render()
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)
notification!WindowsService_36!11c8!12/27/2012-00:00:05:: e ERROR: Error occured processing subscription e0950945-b03d-4fbd-95de-85cae86ea102: Failure sending mail: The report server has encountered a configuration error. Mail will not be resent.
Pease can any one help me to resolve this issue ?
Thanks
|
|
Query execution failed for dataset 'dsStates'. (rs
