Query execution failed for dataset 'dsStates'. (rs

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Query execution failed for dataset 'dsStates'. (rs

Author

Topic

manju1234
Starting Member

1 Post

Posted - 2012-12-27 : 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

prett
Posting Yak Master

212 Posts

Posted - 2012-12-31 : 04:14:33

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

garydossan
Starting Member

6 Posts

Posted - 2014-09-02 : 03:04:31

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[url][/url]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources