This project has moved. For the latest updates, please go here.
3
Vote

Project Portal shows an error on Dashboard Reports

description

I am sure I am just missing something in the documentation or something even simpler.
I have completed setting up the Global List Updater and I have imported the process template. When I create a new project using the template I receive an error when running the Burndown and Burndown rate reports. The error is, "An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'dsDefaultIteration'. (rsErrorExecutingCommand) Invalid column name 'StartDate'. Invalid column name 'FinishDate'. Invalid column name 'StartDate'. Invalid column name 'FinishDate'.
I am using TFS 2010, I have a full installation with TFS 2010 SP1, WSS 3.0 SP2, SQL2008R2 SP1 DB, AS RS. It is running on Windows Server 2008 R2 with SP1. Any help you can provide in finding the issue will be greatly appreciated.

comments

joao_almeida_poa wrote Jun 5, 2013 at 5:13 PM

I Have same problem.
I download the Burndown.rdl and I found dsDefaultIteration dataset, the query that run inside of dataset is below.
When I get the query and try to run inside SQL Management Studio, the table DimIteration inside TFS_Warehouse, search for collumns StartDate and FinishDate that are not installed when we upload Kanban Process Template.

This is the problem, but now, how can I solve it? I do not have Idea, I think that is possible to create this collumns but how can I change the jobs to load data into this collumns when the jobs from TFS run?

My Environment is:
TFS 2010 SP1
Windows 2008 R2 Up to Date
SQL Server 2008 R2 SP1
SharePoint 2010 Foundation
Analysis Services and Reporting Services

The reports aren't running:
DashBoards\Burndown.rdl
DashBoards\Burn Rate.rdl
Project Management\Unplanned Work
Project Management\Remaning Work
__Error for reports above.
Erro no processamento de relatório. (rsProcessingAborted)
    Falha na execução da consulta para o conjunto de dados 'dsDefaultIteration'. (rsErrorExecutingCommand)
        Para obter mais informações sobre este erro, navegue até o servidor de relatório, na máquina de servidor local, ou habilite erros remotos__


DECLARE @theDate DATE
SET @theDate = GETDATE()

DECLARE @Results TABLE (
IterationSK INT,
StartDate DATE,
FinishDate DATE,
IterationGUID NVARCHAR(256),
Depth INT,
IterationPath NVARCHAR(4000)
)
DECLARE @IterationSK INT

INSERT @Results
SELECT  IterationSK,
        StartDate, 
        FinishDate,
        IterationGUID,
        Depth,
        IterationPath
 FROM DimIteration
WHERE 
  StartDate IS NOT NULL
  AND FinishDate IS NOT NULL
  AND ProjectGUID = @ProjectGuid
--

-- Return the results with the correct formatting

-- select iterations where we are within start-end dates
SELECT TOP 1 @IterationSK = IterationSK
FROM @Results
WHERE (@theDate BETWEEN StartDate AND FinishDate) AND Depth > 0
ORDER BY StartDate, FinishDate, IterationPath

-- if not found, find the most recently completed iteration
IF @IterationSK IS NULL BEGIN
SELECT TOP 1 @IterationSK = IterationSK
FROM @Results
WHERE FinishDate <= @theDate AND Depth > 0
ORDER BY FinishDate DESC, StartDate, IterationPath
END

-- if not found, find the first iteration in the future
-- or the first (alphabetical) iteration if no iteration dates are set
IF @IterationSK IS NULL BEGIN
SELECT TOP 1 @IterationSK = IterationSK
FROM @Results
WHERE Depth > 1
ORDER BY COALESCE(StartDate,'9999-12-31'), FinishDate, IterationPath
END

IF @IterationSK IS NULL
SELECT @AllNoFilter AS IterationName, '[Work Item].[Iteration Hierarchy].[All]' AS ParameterValue
ELSE
SELECT SUBSTRING(IterationPath, CHARINDEX('\', IterationPath, 2) + 1, LEN(IterationPath)) AS IterationName,
'[Work Item].[Iteration Hierarchy].[Iteration' + CONVERT(varchar, Depth) + '].&[' +
                CONVERT(nvarchar, CONVERT(bigint, SUBSTRING(CONVERT(binary(16), CONVERT(uniqueidentifier, IterationGUID)), 1, 8))) +
                ']&[' +
                CONVERT(nvarchar, CONVERT(bigint, SUBSTRING(CONVERT(binary(16), CONVERT(uniqueidentifier, IterationGUID)), 9, 8))) +
            ']' AS ParameterValue
            ,IterationPath
FROM DimIteration
WHERE IterationSK = @IterationSK

wrote Jun 5, 2013 at 5:21 PM

wrote Oct 18, 2013 at 9:31 AM