Problem with the report site.

On the team project we setup a report site. For the report site we added TfsOlapReportDS and TfsReportDS. We then added a couple of reports, Bug Rates and Issues.

The Issues report is using the data source TfsReportDS which runs fine with no problems. When I open the Bug Rates report in Team System, I get the following error message:

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set 'AreaPathPath1'. (rsErrorExecutingCommand)
Incorrect syntax near 'Measures'. Incorrect syntax near 'WorkItemType'.

I then added two more reports. Again the one that used the TfsReportDS worked fine, but the one that used the TfsOlapReportDS displayed a similar error. This seems to be a TfsOlapReportDS datasource problem, but I'm not sure how to troubleshoot with the error we've been getting.

Any suggestions?

thanks,
aaron

[950 byte] By [AaronJ] at [2007-12-16]

«« write a C++ prog in VS 2005 beta 2 to run on pocketPC device
»» Generic Base Control Collection

# 1

Check to see if Analysis Services is running on the data tier. If it's not start it, and make sure it's set up to start automatically. After that, there may be a couple of hour latency before the cube is populated and processed. See if that resolves your problem.

AllenClark-MSFT at 2007-9-9 >

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

# 2

Allen,

Thanks for the response. I actually found some similar postings and checked Analysis services. We had already had a number of bugs entered for the project.

thanks,
aaron

AaronJ at 2007-9-9 >

# 3

This can happen if you don't have any bugs in the project. Allow a couple of hours after creating the bugs before they show up in the warehouse.

AllenClark-MSFT at 2007-9-9 >

# 4

This project has a number of bugs in the project and we continue to add them, but we're still getting the same error message.

thanks,
aaron

AaronJ at 2007-9-9 >

# 5

Do you have Tfs errors in your event log?

AllenClark-MSFT at 2007-9-9 >

# 6

Yes, here is a tfs error that appears in the event log.

System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'UQ_ADObjects__DomainName_SamAccountName'. Cannot insert duplicate key in object 'dbo.ADObjects'.
at Microsoft.VisualStudio.Currituck.Server.DataAccessLayer.BisSyncGroupsAndUsers.AddToCache(ProjectInfo project, Identity identity, String parentSid, Boolean isDeleted)
at Microsoft.VisualStudio.Currituck.Server.DataAccessLayer.BisSyncGroupsAndUsers.SyncIdentity(ProjectInfo project, Identity identity, String parentSid, Boolean fPopulateMetaData)
at Microsoft.VisualStudio.Currituck.Server.DataAccessLayer.BisSyncGroupsAndUsers.SyncGlobalGroups()

thanks,
aaron

AaronJ at 2007-9-9 >

# 7

Have you tried this with the latest Beta 3 release? A lot has changed in the reporting features.

LingBao at 2007-9-9 >

# 8

Unfortunately I was involved with a number of release cycles and we haven't had a chance to go to beta 3.

I think we're going to wait for the release before moving forward.

thanks,
aaron

AaronJ at 2007-9-9 >

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