Dynamics Community Forum Thread Details

We have been troubleshooting an intermittent error generating reports from Management Reporter (ver. 2.0.`1664.19 (FP1)). After selecting companies the report window opens and remains blank for a time and eventually returns the message 'There was a problem communicating with the server'. The message is received on all three physical Terminal Servers though not consistently. Running the reports from GP/Management reporter locally on the database server (Windows Server 2008 R2/MSSQL 2008 R2) does not produce the error. Network tests reveal no dropped packets and wiring and switches were recently replaced.

Applog from the event viewer on the database server show the following:

Source: Management Reporter Report Viewer

Date: 11/8/2012 3:35:34 PM

Event ID: 0

Task Category: None

Level: Error

Keywords: Classic

User: N/A

Computer: xxxxxx

Description:

Timestamp: 11/8/2012 3:35:34 PM

Message: Microsoft.Dynamics.Performance.Common.ReportingServerCommunicationException: There was a problem communicating with the server.

at Microsoft.Dynamics.Performance.Common.Service.ClientBase.Execute[TExec](Func`1 executor, Action`1 handler)

at Microsoft.Dynamics.Performance.Reporting.Repository.Item.<>c__DisplayClassb`1.<ListItems>b__a()

at Microsoft.Dynamics.Performance.Common.ExceptionHandling.<>c__DisplayClass1`2.<MakeHandler>b__0(Func`1 execute)

Event Xml:

<Channel>Application</Channel>

</System>

<Data>

Timestamp: 11/8/2012 3:35:34 PM

Message: Microsoft.Dynamics.Performance.Common.ReportingServerCommunicationException: There was a problem communicating with the server.

at Microsoft.Dynamics.Performance.Common.Service.ClientBase.Execute[TExec](Func`1 executor, Action`1 handler)

at Microsoft.Dynamics.Performance.Reporting.Repository.Item.<>c__DisplayClassb`1.<ListItems>b__a()

at Microsoft.Dynamics.Performance.Common.ExceptionHandling.<>c__DisplayClass1`2.<MakeHandler>b__0(Func`1 execute)

</Data>

</EventData>

</Event>

___________________________________________________________________________________

Log Name: Application

Source: Management Reporter Report Viewer

Date: 11/8/2012 3:35:34 PM

Event ID: 0

Task Category: None

Level: Error

Keywords: Classic

User: N/A

Computer: ENT-TSE-001.ent.ads

Description:

Timestamp: 11/8/2012 3:35:34 PM

Message: 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:10:00'. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host

at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)

--- End of inner exception stack trace ---

at System.Net.ConnectStream.Read(Byte[] buffer, Int32 offset, Int32 size)

at System.ServiceModel.Channels.HttpInput.WebResponseHttpInput.WebResponseInputStream.Read(Byte[] buffer, Int32 offset, Int32 count)

--- End of inner exception stack trace ---

Server stack trace:

at System.ServiceModel.Channels.HttpInput.WebResponseHttpInput.WebResponseInputStream.Read(Byte[] buffer, Int32 offset, Int32 count)

at System.ServiceModel.Channels.HttpInput.ReadBufferedMessage(Stream inputStream)

at System.ServiceModel.Channels.HttpInput.ParseIncomingMessage(Exception& requestException)

at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)

at System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout)

at System.ServiceModel.Channels.ClientReliableChannelBinder`1.RequestClientReliableChannelBinder`1.OnRequest(TRequestChannel channel, Message message, TimeSpan timeout, MaskingMode maskingMode)

at System.ServiceModel.Channels.ClientReliableChannelBinder`1.Request(Message message, TimeSpan timeout, MaskingMode maskingMode)

at System.ServiceModel.Security.SecuritySessionClientSettings`1.SecurityRequestSessionChannel.Request(Message message, TimeSpan timeout)

at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)

at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)

at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]:

at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)

at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)

at Microsoft.Dynamics.Performance.Reporting.Repository.IRepositoryService.ListItems(Guid itemId, Boolean containersOnly, Int32 depth, Boolean includeAncestors)

at Microsoft.Dynamics.Performance.Reporting.Repository.RepositoryProxy.<>c__DisplayClass4.<ListItems>b__3()

at Microsoft.Dynamics.Performance.Common.Service.ClientBase.<>c__DisplayClass8`1.<Execute>b__5()

at Microsoft.Dynamics.Performance.Common.Service.ClientBase.<>c__DisplayClass8`1.<Execute>b__3(Func`1 T)

at Microsoft.Dynamics.Performance.Common.Service.ClientBase.<>c__DisplayClass8`1.<Execute>b__4()