Table of Contents


 

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.