If you're experiencing "Query execution failed for dataset 'ds[Whatever]'. ", more than likely, your warehouse processing is failing. Going into the Admin Console or invoking the web service directly, invoking the Start Rebuild action, I kept receiving a TF221122.
Finally, when I added the account under "Account for accessing data sources" under the "Analysis Services" tab to the SQL Server Tfs_Warehouse database TFSEXECROLE role, processing began to succeed again. Whew.
1 comment:
Well...this worked! It is just strange to me. Our reports/analysis was running find then we started getting TFS_Analysis corruption issues. I went through the normal steps of deleting and recreating, but it didn't work this time. THIS did the trick. I don't like not knowing what is going on with our TFS server! Thanks for the tip! ;-)
Post a Comment