SSRS 2016 Mobile Report Publisher Error 500

Hi All,

So In case you struggle as I was with SQL Server 2016 Reporting Services and specifically I had two issues:

• SRS website simply will not show any content which I ignored at start with some similar 500 Error
• Then when I tried to use Mobile Report Publisher I saw this 500 error

In the SRS logs ("C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\LogFiles" in my case) I can see something like that

Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!fe!06/20/2017-12:13:09:: e ERROR: [frrma4f2]: OData exception occurred: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ArgumentOutOfRangeException: The UTC time represented when the offset is applied must be between year 0 and 10,000.

Now you have to remeber words OData and the string about UTC time.

Turned out the issue is with the fact that... wait for it... your server is living east of London :)

Reset timezone to EST (GMT with minus "-", to the left, west side :)) and the error is gone

I mean, Microsoft, really? :)

I was able to find a solution from this blog post
https://morgansimonsen.com/2015/12/07/office-365-hybrid-configuration-wizard-fails-due-to-datetime-minvalue-issue/
Which is about a problem in C# reported here, a problem known in 2012!!!

Hope this helps someone else out there :)