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

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


 

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.

Leave a Comment
  • Please add 8 and 4 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Ed Price - MSFT edited Revision 6. Comment: bug

  • Ed Price - MSFT edited Revision 1. Comment: Updated title per guidelines, font style update, added TOC, and added tags. Great article!

Page 1 of 1 (2 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Ed Price - MSFT edited Revision 1. Comment: Updated title per guidelines, font style update, added TOC, and added tags. Great article!

  • Ed Price - MSFT edited Revision 6. Comment: bug

  • I was so excited to see someone else had this issue but the workaround does not work for me.  I have changed the region of the master site and the sub-site to both be EN-US without any success.  Just wondering if the locale of the server running sharepoint or database or user scheduling comes into play?   I am in AU/NZ with dd/mm/yy dates.

  • KiwiDave63,

    On the server running PowerPivot.

    Go to Control Panel > Region & Language > Formats Tab > Additional Settings > Time Tab

    Look at "AM symbol:" and "PM symbol".  If they are lower case, youu can change them to:

    “AM symbol” to A.M.

    “PM symbol” to P.M.

Page 1 of 1 (4 items)