x

SQL 2014 and TFS 2013 reporting errors

I've setup a new instance for TFS and Reporting. I'm able to connect to TFS and manage the code fine but the reports are not working and return the below error. I've processed the team cube and all dimensions without errors but when running any reports they fail.
processing!ReportServer_0-4!c98!04/21/2014-10:58:46:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'dsArea'. ---> Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: The Team System cube either does not exist or has not been processed.
more ▼

asked Apr 21 at 04:15 PM in Default

Flathead_SQL gravatar image

Flathead_SQL
111 3 5

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
Okay, got it figured out. After I reprocessed the analysis services team cube everything processed okay but I was still receiving the same error. Turned out there was a pending reboot on the server (server 2012) that was causing this issue. I restarted the server and once everything was back online, reports run fine. Something so trivial and the error stored in the reporting log would never indicate this to be the issue.
more ▼

answered Apr 21 at 06:06 PM

Flathead_SQL gravatar image

Flathead_SQL
111 3 5

Good to know you resolved it. Go ahead and mark this as the answer.
Apr 21 at 06:19 PM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left
Check the configuration settings. I suspect you're attempting to log in to the wrong location.
more ▼

answered Apr 21 at 05:54 PM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
100k 19 21 74

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x10

asked: Apr 21 at 04:15 PM

Seen: 355 times

Last Updated: Apr 21 at 06:19 PM