Hi All,
i have a SSRS report, running from AX 2012 R3, which is receiving error message in Production environment. The error is -
"An existing connection was forcibly closed by the remote host."
It happens almost exactly at 5 minutes of execution time. In other environments, it runs successfully, takes about 10-15 mins to finish, depending on data volume.
-First i tried optimizing the underlying queries, with no significant performance improvement. Same with creating indexes on specific tables.
-Then, i tried different settings on SSRS report side - increasing timeout and execution time to 30 mins. Still it would error out at 5 min mark.
-Finally, In production, on both host and SSRS client end, we set the “sendtimeout” and “receivetimeout” to 30 minutes for “QueryServiceBinding”.
However, by default, “MetadataServicebinding” at server end is set as following:
So we changed the sendTimeOut to 10 mins.
The report is still failing after 5 mins. The setting s on the other environments, both client, AOS, or Reporting server, are the same, yet the report is coming out fine.
Any suggestions, where else may i look for the source of an error?
The captured log from Reporting sever:
library!ReportServer_0-1!2c0!11/11/2020-01:26:41:: i INFO: RenderForNewSession(’/DynamicsAX/AVANIHBBankReconcilationReport.Report’)
processing!ReportServer_0-1!2c0!11/11/2020-01:31:54:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset ‘BankRecon_DS’. —> System.InvalidOperationException: An exception occurred in the query metadata execution. The exception is The socket connection was aborted. This could be caused by an error processing your message or a receive timeout being exceeded by the remote host, or an underlying network resource issue. Local socket timeout was ‘00:30:00’… —> Microsoft.Dynamics.AX.Framework.Services.Client.QueryServiceException: The socket connection was aborted. This could be caused by an error processing your message or a receive timeout being exceeded by the remote host, or an underlying network resource issue. Local socket timeout was ‘00:30:00’. —> System.ServiceModel.CommunicationException: The socket connection was aborted. This could be caused by an error processing your message or a receive timeout being exceeded by the remote host, or an underlying network resource issue. Local socket timeout was ‘00:30:00’. —> System.IO.IOException: The read operation failed, see inner exception. —> System.ServiceModel.CommunicationException: The socket connection was aborted. This could be caused by an error processing your message or a receive timeout being exceeded by the remote host, or an underlying network resource issue. Local socket timeout was ‘00:30:00’. —> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host
at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.ServiceModel.Channels.SocketConnection.ReadCore(Byte[] buffer, Int32 offset, Int32 size, TimeSpan timeout, Boolean closing)
— End of inner exception stack trace —
at System.ServiceModel.Channels.SocketConnection.ReadCore(Byte[] buffer, Int32 offset, Int32 size, TimeSpan timeout, Boolean closing)
at System.ServiceModel.Channels.SocketConnection.Read(Byte[] buffer, Int32 offset, Int32 size, TimeSpan timeout)
at System.ServiceModel.Channels.DelegatingConnection.Read(Byte[] buffer, Int32 offset, Int32 size, TimeSpan timeout)
at System.ServiceModel.Channels.ConnectionStream.Read(Byte[] buffer, Int32 offset, Int32 count, TimeSpan timeout)
at System.ServiceModel.Channels.ConnectionStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at System.Net.FixedSizeReader.ReadPacket(Byte[] buffer, Int32 offset, Int32 count)
at System.Net.Security.NegotiateStream.StartFrameHeader(Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest)
at System.Net.Security.NegotiateStream.StartReading(Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest)
at System.Net.Security.NegotiateStream.ProcessRead(Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest)
— End of inner exception stack trace —