CCR - Problem with generating reports - timeout...?

[tatol75]

I have:
IPO 7.0(5)
CCR 7.0.2.2
Win 2008 Server (64bit)
Microsoft SQL Server 2008 R2

and problem:
I would like to carry the report Agent Time Card for all agents (something about 30) and for one month. I have marked Automatic field and I have filled up other remaining fields (pdf, email, etc.).
After the about three hours an incorrect report is a result (Failure - Scheduled Task Failed).
Note:
- I use Housekeeping Task - Rebuild Database Indexes one for each day.
In Windows Events i have a few messages:



- The Report Scheduler Task stopped. Note: This will be whenever a scheduled report is run.



- ExecuteScheduledReportTask() Exception: System.ApplicationException: HistoricalReportingService.GetReportFileContent failed ---> System.ServiceModel.CommunicationException: An error occurred while receiving the HTTP response to

http://localhost/CCRHistoricalReportingService/HistoricalReportingService.asmx.

This could be due to the service endpoint binding not using the HTTP protocol. This could also be due to an HTTP request context being aborted by the server (possibly due to the service shutting down). See server logs for more details. ---> System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a receive. ---> 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.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
--- End of inner exception stack trace ---
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.Net.PooledStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.Net.Connection.SyncRead(HttpWebRequest request, Boolean userRetrievedStream, Boolean probeRead)
--- End of inner exception stack trace ---
at System.Net.HttpWebRequest.GetResponse()
at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
--- End of inner exception stack trace ---

Server stack trace:
at System.ServiceModel.Channels.HttpChannelUtilities.ProcessGetResponseWebException(WebException webException, HttpWebRequest request, HttpAbortReason abortReason)
at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
at System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout)
at Avaya.SBCC.Security.UserNamePasswordSecurityChannel.Request(Message message, TimeSpan timeout)
at System.ServiceModel.Dispatcher.RequestChannelBinder.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.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs)
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 Avaya.SBCC.WebClient.ServiceAgents.historicalReportingService.HistoricalReportingService.GetReportFileContent(GetReportFileContentRequest request)
at Avaya.SBCC.WebClient.ServiceAgents.historicalReportingService.HistoricalReportingServiceClient.Avaya.SBCC.WebClient.ServiceAgents.historicalReportingService.HistoricalReportingService.GetReportFileContent(GetReportFileContentRequest request)
at Avaya.SBCC.WebClient.ServiceAgents.historicalReportingService.HistoricalReportingServiceClient.GetReportFileContent(ReportSavedParameters reportParameterObject, String connectionId, Int32 priority)
at Avaya.SBCC.WebClient.ServiceAgents.HistoricalReportingServiceAgent.GetReportFileContent(ReportSavedParameters savedParameters, String connectionId, Int32 priority)
--- End of inner exception stack trace ---
at Avaya.SBCC.WebClient.ServiceAgents.HistoricalReportingServiceAgent.GetReportFileContent(ReportSavedParameters savedParameters, String connectionId, Int32 priority)
at Avaya.SBCC.ReportSchedulerTask.ExecuteScheduledTask.ExecuteTask(Int32& baseReportId)
at Avaya.SBCC.ReportSchedulerTask.ExecuteScheduledTask.ExecuteScheduledReportTask(). ScheduledReportId=19



- The Report Scheduler Task experienced communication failure with the Historical Reporting Service. Exception: System.ApplicationException: HistoricalReportingService.LoadSavedReportParameterSet failed ---> System.ServiceModel.ServerTooBusyException: The HTTP service located at

http://localhost/CCRHistoricalReportingService/HistoricalReportingService.asmx

is too busy. ---> System.Net.WebException: The remote server returned an error: (503) Server Unavailable.
at System.Net.HttpWebRequest.GetResponse()
at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
--- End of inner exception stack trace ---

Server stack trace:
at System.ServiceModel.Channels.HttpChannelUtilities.ProcessGetResponseWebException(WebException webException, HttpWebRequest request, HttpAbortReason abortReason)
at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
at System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout)
at Avaya.SBCC.Security.UserNamePasswordSecurityChannel.Request(Message message, TimeSpan timeout)
at System.ServiceModel.Dispatcher.RequestChannelBinder.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.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs)
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 Avaya.SBCC.WebClient.ServiceAgents.historicalReportingService.HistoricalReportingService.LoadSavedReportParameterSet(Int32 reportParameterId, Int32 userId)
at Avaya.SBCC.WebClient.ServiceAgents.HistoricalReportingServiceAgent.LoadSavedReportParameterSet(Int32 reportParameterID, Int32 userID)
--- End of inner exception stack trace ---
at Avaya.SBCC.WebClient.ServiceAgents.HistoricalReportingServiceAgent.LoadSavedReportParameterSet(Int32 reportParameterID, Int32 userID)
at Avaya.SBCC.ReportSchedulerTask.ExecuteScheduledTask.UpdateDatabase(Boolean printSuccess, Boolean emailSuccess, Boolean processingSuccess, Boolean processingTimeout)



- UpdateDatabase() Exception: System.ApplicationException: HistoricalReportingService.LoadSavedReportParameterSet failed ---> System.ServiceModel.ServerTooBusyException: The HTTP service located at

http://localhost/CCRHistoricalReportingService/HistoricalReportingService.asmx

is too busy. ---> System.Net.WebException: The remote server returned an error: (503) Server Unavailable.
at System.Net.HttpWebRequest.GetResponse()
at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
--- End of inner exception stack trace ---

Server stack trace:
at System.ServiceModel.Channels.HttpChannelUtilities.ProcessGetResponseWebException(WebException webException, HttpWebRequest request, HttpAbortReason abortReason)
at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
at System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout)
at Avaya.SBCC.Security.UserNamePasswordSecurityChannel.Request(Message message, TimeSpan timeout)
at System.ServiceModel.Dispatcher.RequestChannelBinder.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.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs)
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 Avaya.SBCC.WebClient.ServiceAgents.historicalReportingService.HistoricalReportingService.LoadSavedReportParameterSet(Int32 reportParameterId, Int32 userId)
at Avaya.SBCC.WebClient.ServiceAgents.HistoricalReportingServiceAgent.LoadSavedReportParameterSet(Int32 reportParameterID, Int32 userID)
--- End of inner exception stack trace ---
at Avaya.SBCC.WebClient.ServiceAgents.HistoricalReportingServiceAgent.LoadSavedReportParameterSet(Int32 reportParameterID, Int32 userID)
at Avaya.SBCC.ReportSchedulerTask.ExecuteScheduledTask.UpdateDatabase(Boolean printSuccess, Boolean emailSuccess, Boolean processingSuccess, Boolean processingTimeout). ScheduledReportId=19



Any idea for fix this problem?
Thx for help!

 

[intrigrant]

I have seen that happen if reports are generated covering a lot of data. Still no fix from Avaya.

If it ain't dutch it ain't much

 

[IPOclueless]

There's a PB available from Avaya for the ATC Report taking too long to run - PB CCR 7.0.3.11.

This sounds like the same issue. If you run an ATC report for more than 3 weeks the report will timeout.

The fix will be incorporated into the 1Q 2012 Maintenance Release.

However, I would raise a ticket with Avaya just to make sure that it is the same issue.

 

[hairlessupportmonkey]

Also try a different browser like FF or Chrome.

however this is the primary reason why we totally dropped CCR and went with Chronicall.

good luck with help from Avaya - ive been waiting two years for a resolve.

ACSS - SME
General Geek

 

[IPOConsultant6]

PB mentioned above will most likely solve this problem.