Wednesday, 16 May 2018

Solution for Error: MSCRM reports Error "The report execution ampbze45rbglyvb4u4qfldr4 has expired or cannot be found. (rsExecutionNotFound)"

Link:
https://blogs.msdn.microsoft.com/dynamicsaxbi/2013/02/14/how-to-addressing-ssrs-session-timeouts/


Run On SQL Server:
rs -i sessionaccess.rss -s http://indel-mscrmuat1/ReportServer_RSUAT

SessionAccessTimeOut.rss file:

Public Sub Main() Dim props() as [Property] props = new [Property] () { new [Property](), new [Property]() } props(0).Name = "SessionTimeout" props(0).Value = 60000 props(1).Name = "SessionAccessTimeout" props(1).Value = 60000 rs.SetSystemProperties(props) End Sub


And

Enable Remote Errors:

Public Sub Main()
  Dim P As New [Property]()
  P.Name = "EnableRemoteErrors"
  P.Value = True
  Dim Properties(0) As [Property]
  Properties(0) = P
  Try
    rs.SetSystemProperties(Properties)
    Console.WriteLine("Remote errors enabled.")
  Catch SE As SoapException
    Console.WriteLine(SE.Detail.OuterXml)
  End Try
End Sub