Process is remaining in running state for long time even after processing all the records

Automation Studio
1

Process is remaining in running state for long time even after processing all the records
Below is the log after processing records:
ExceptionSource - mscorlib
ExceptionTarget - Void HandleReturnMessage(System.Runtime.Remoting.Messaging.IMessage, System.Runtime.Remoting.Messaging.IMessage)
StackTrace - System.ServiceModel.FaultException: System heart beat call

Server stack trace:
at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
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 ServiceConnector.WFDataReference.IWorkFlowDataService.GetUserDetails(GetUserDetailsRequest getUserDetails1)
at ServiceConnector.WFDataReference.WorkFlowDataServiceClient.GetUserDetails(GetUserDetailsRequest getUserDetails1)
.

2

Hi,

Which activity you are using.

3

Hi Amit,

I am using excel loop activity.
After excel looping completed it is even moving file to another location also.
But it is not ending immediately.

Regards,
Pallavi.

4

Hi,

What are you trying to do in excel loop activity. briefly explain your use case

5

Hi Amit,

I am downloading ticket data in excel from application and checking the data contents with the keywords excel.If conditions matches ticket details in web application will be updated.
The whole process is executed correctly but the end of the process is taking time.
Below is the log:

message~Activity Name: File Operations, Step Result: Complete, Error Ignored: No description~NA userid~p ipaddress~
instid~0 date~8/19/2019 time~01:57:40.127 level~Error priority~0 srcmodule~EV.AE.Studio.ActivityLibrary.LoggingActivity method~ExecuteActivity message~completed the processs description~Logging Activity’s Message userid~NA ipaddress~
co_module~SE_ACE inst_key~0 trans_key~0 trans_id~ req_id~ cust_id~ crossref_id~ workspacekey~Default datetime~2019-08-19T13:57:40.127+05:30 level~Info priority~0 srcmodule~EV.AE.Studio.ActivityLibrary.NativeActivityBase method~OnActivityCompletedAction message~Activity Name: Write to Log file, Step Result: Success, Error Ignored: No description~NA userid~P ipaddress~
co_module~SE_ACE inst_key~0 trans_key~0 trans_id~ req_id~ cust_id~ crossref_id~ workspacekey~Default datetime~2019-08-19T14:28:44.391+05:30 level~Error priority~0 srcmodule~ServiceConnector.UMDataManager method~SendHeartBeat errormessage~System heart beat call errordetails~ExceptionMessage - System heart beat call
ExceptionSource - mscorlib
ExceptionTarget - Void HandleReturnMessage(System.Runtime.Remoting.Messaging.IMessage, System.Runtime.Remoting.Messaging.IMessage)
StackTrace - System.ServiceModel.FaultException: System heart beat call

Server stack trace:
at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
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 ServiceConnector.WFDataReference.IWorkFlowDataService.GetUserDetails(GetUserDetailsRequest getUserDetails1)
at ServiceConnector.WFDataReference.WorkFlowDataServiceClient.GetUserDetails(GetUserDetailsRequest getUserDetails1)
at ServiceConnector.UMDataManager.SendHeartBeat(Object sender, ElapsedEventArgs e) userid~P ipaddress~1
co_module~SE_ACE inst_key~0 trans_key~0 trans_id~ req_id~ cust_id~ crossref_id~ workspacekey~Default datetime~2019-08-19T14:58:44.198+05:30 level~Error priority~0 srcmodule~ServiceConnector.UMDataManager method~SendHeartBeat errormessage~System heart beat call errordetails~ExceptionMessage - System heart beat call
ExceptionSource - mscorlib
ExceptionTarget - Void HandleReturnMessage(System.Runtime.Remoting.Messaging.IMessage, System.Runtime.Remoting.Messaging.IMessage)
StackTrace - System.ServiceModel.FaultException: System heart beat call

Server stack trace:
at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
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 ServiceConnector.WFDataReference.IWorkFlowDataService.GetUserDetails(GetUserDetailsRequest getUserDetails1)
at ServiceConnector.WFDataReference.WorkFlowDataServiceClient.GetUserDetails(GetUserDetailsRequest getUserDetails1)
at ServiceConnector.UMDataManager.SendHeartBeat(Object sender, ElapsedEventArgs e) userid~p ipaddress~

6

Hi,

I am assuming that you are taking certain data as input from excel loop. TO isolate your issue first run process with single data without excel loop and see if process is executed successfully

Regards,
Amit