TFS 2010 "The Iteration dates are not valid" error after upgrade to SQL 2008 R2

This article has been archived. It is offered "as is" and will no longer be updated.
SYMPTOMS
After upgrading SQL Server Analysis Services 2008 hosting TFS 2010 to SQL Analysis Services 2008 R2, users cannot refresh the Burndown chart in an Agile project workbook. They receive the following error:

The Iteration dates are not valid. Switch back to the Settings tab and enter valid dates.


CAUSE
This is caused by changes introduced in SQL Server Analysis Services 2008 R2
RESOLUTION
To workaround this issue:


Open msmdsrv.ini on the Analysis Services server; this file should be located in the "%ProgramFiles%\Microsoft SQL Server\MSAS10\OLAP\Config" directory (if you are using a named instance of SQL, the path will include this in the MSAS10 directory, i.e. MSAS10.<SQL Instance name>)

Locate the line containing the <AllowSEFiltering> tag.

Change the value for this tag from "1" to "0" (without the quotation marks)

For example, change from

<AllowSEFiltering>1</AllowSEFiltering>

to

<AllowSEFiltering>0</AllowSEFiltering>

After saving the updated msmdsrv.ini file you will need to restart SQL Server Analysis Services for these changes to take effect.
MORE INFORMATION
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 2222312 - Last Review: 12/12/2015 09:15:47 - Revision: 2.0

Microsoft Visual Studio Team Foundation Server 2010

  • kbnosurvey kbarchive KB2222312
Feedback