Report server error

After a successfully TFS installation any new projects fails showing any of the reports.

If we run the reports directly from reporting services, following error are returned:

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set 'dsIterationPathParam'. (rsErrorExecutingCommand)
The Team System cube either does not exist or has not been processed.

We have a dual installation with SQL 2005 June ENT and TFS july.

How can we correct the error ?

Regards
Christian

[1838 byte] By [ChristianGram] at [2007-12-16]

«« team build from a specific (local) version
»» KPIS Help

# 1

Found the solution in Robs Caron's Blog.

http://blogs.msdn.com/robcaron/archive/2005/08/05/448377.aspx

Did not work at first. We had to for the cubes to be generated.

Christian

ChristianGram at 2007-9-9 >

top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Setup...

# 2

Hi, I also am getting the same error:

An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Query execution failed for data set 'dsIterationPathParam'. (rsErrorExecutingCommand) Get Online Help
- For more information about this error navigate to the report server on the local server machine, or enable remote errors

How do you force the cubes to be generated? I did not have this problem the last time I installed the July CTP. Both installs were done on completely clean machines. Do you know what causes this error?
Thanks,
Rob

RobC at 2007-9-9 >

# 3

Hi Rob

I really dont know :-)

I belive you have to wait for the report server to create them. After about 8 or 10 hours the sudently worked for us.

Christian

ChristianGram at 2007-9-9 >

# 4

OK, thanks for the reply though. We were getting several errors now so we are going to reinstall Team Foundation Server (again). The only difference from last time when we didn't get these errors is that new Windows Updates were applied.

RobC at 2007-9-9 >

# 5

I'm experincing a simialr error:

An error has occurred during report processing. (rsProcessingAborted)
- Query execution failed for data set 'dsIterationPathParam'. (rsErrorExecutingCommand)
  - Errors in the OLAP storage engine: The restrictions imposed on partition slice where violated.

I have already made the adjustments as outlined in the blog listed above. I receive this error when running directly from report services. Any sugestions?

jhoney at 2007-9-9 >

# 6

Hi,
I have also gotton that error. Unfortunately we reinstalled Team Foundation Server data and application tiers to fix it. There may be a better way, but I don't know of it.

RobC at 2007-9-9 >

# 7

Hi,

Has anyone found a solution to this error other than a complete rebuild?

Tks

Zack

Zack22 at 2007-9-9 >

Visual Studio Team System

Team Foundation Server - Setup

Visual Studio Team System Hot Topic

Visual Studio Team System New Topic

Visual Studio Team System

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech