You are currently offline, waiting for your internet to reconnect

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

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: 06/25/2010 18:44:00 - Revision: 2.0

  • Microsoft Visual Studio Team Foundation Server 2010
  • KB2222312
Feedback