Wednesday, January 12, 2011

TF221122: TFS Error While Processing Cube

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:

Bebo said...

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! ;-)