Wikis - Page Details

First published by Tschauer
When: 22 May 2012 1:04 PM
Last revision by Gokan Ozcifci (eMicrosoft Partne)
When: 15 Aug 2013 3:26 AM
Revisions: 15
Comments: 4

Options

Can You Improve This Article?

Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.

SharePoint 2010: Data Refresh Failed: "String was not recognized as a valid DateTime" (PowerPivot)

Issue
If "Enable" has not been checked, you are able to enter the "Schedule Refresh…" screen.
- Cause
- Workaround

Issue

When clicking on “Manage Refresh”, you can see the scheduled refreshes are succeeding. However, when you click on "Schedule Refresh…", a Correlation ID (different each time) is thrown.

If "Enable" has not been checked, you are able to enter the "Schedule Refresh…" screen.

        Error in ULS log: w3wp.exe (0x29B0)

        0x2564

        SSAS Mid-Tier Service

        Background Jobs

        99

        High

EXCEPTION: System.FormatException: String was not recognized as a valid DateTime.     at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)     at System.Convert.ToDateTime(String value, IFormatProvider provider)     at Microsoft.AnalysisServices.SharePoint.Integration.Redirector.Assignment.Equals(Database db, String dbStoragePath, String serverEndPointAddress)     at Microsoft.AnalysisServices.SharePoint.Integration.Redirector.CacheManager.CheckIntegrity()

Cause

The Scheduled Data Refresh Job does not correctly parse the "Non (English - United States) dates".

Workaround

Open the site on which you want to change the default regional settings. On the Site Actions menu , click Site Settings. On the Site Settings page, under Site Administration, click Regional settings. On the Regional Settings page, select (English - United States) and then click OK.