SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Query execution failed for dataset 'dsStates'. (rs
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

manju1234
Starting Member

1 Posts

Posted - 12/27/2012 :  03:25:48  Show Profile  Reply with Quote
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



prett
Posting Yak Master

USA
203 Posts

Posted - 12/31/2012 :  04:14:33  Show Profile  Visit prett's Homepage  Reply with Quote
This error may occur when the Data Source Type for TFS Data Sources in SSRS is set incorrectly. Using the Microsoft SQL Server Reporting Services web site, ensure the two TFS Data Sources point to the proper Data Source Type:

1. Connect to the Microsoft SQL Server Reporting Services web site. This is usually HTTP://LOCALHOST/REPORTS on the TFS application tier machine, but may be different. Check with your TFS administrator for this location.

2. Open the details for the "TfsReportDS" Data Source and ensure its Data Source Type is set to "Microsoft SQL Server".

3. Return to the HOME page then open the details for the "TfsOlapReportDS" Data Source. Ensure that the Data Source Type is set to "Microsoft SQL Server Analysis Services".

For more information, please visit this link: http://support.microsoft.com/kb/976701
Go to Top of Page

garydossan
Starting Member

6 Posts

Posted - 09/02/2014 :  03:04:31  Show Profile  Reply with Quote
You can use Recovery Toolbox for SQL Server database recovery tool which helps you to restore deleted SQL database. You can download this tool from here: http://goo.gl/nQO0zH
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000