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

Article ID: 2222312 - View products that this article applies to.
Expand all | Collapse all

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.
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: June 25, 2010 - Revision: 2.0
APPLIES TO
  • Microsoft Visual Studio Team Foundation Server 2010
Keywords: 
KB2222312

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com