Client.OracleException ORA-01013: user requested cancel of current operation

Question

Hi,

I am using Oracle WCF Adapter that calls a database View. Everything works fine when View returns rows quickly. However, soon as View takes long time like 2 min. or more to return rows, I get below error. I have already tried increasing 'Receive Timeout' property in the binding but that did not resolve the issue. Any help resolving this issue is appreciated.

Thanks,

IW

Details:"Microsoft.ServiceModel.Channels.Common.TargetSystemException: ORA-01013: user requested cancel of current operation ---> Oracle.DataAccess.Client.OracleException ORA-01013: user requested cancel of current operation at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)

at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)

at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)

at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(CommandBehavior behavior)

at Microsoft.Adapters.OracleCommon.OracleCommonUtils.ExecuteReader(OracleCommonConnectionWrapper connection, String commandText, IEnumerable`1 parameters, CommandBehavior commandBehavior, IOracleAdapterCommonBindingProperties properties, OracleCommonExecutionHelper executionHelper)

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

Server stack trace:

at System.ServiceModel.AsyncResult.End[TAsyncResult](IAsyncResult result)

at System.ServiceModel.Channels.ServiceChannel.SendAsyncResult.End(SendAsyncResult result)

at System.ServiceModel.Channels.ServiceChannel.EndCall(String action, Object[] outs, IAsyncResult result)

at System.ServiceModel.Channels.ServiceChannel.EndRequest(IAsyncResult result)

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 System.ServiceModel.Channels.IRequestChannel.EndRequest(IAsyncResult result)

at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfClient`2.RequestCallback(IAsyncResult result)".

 

Answer 1

Looks like your transaction timeout is set to 2 minutes. Also if this is a outbound operation, you should set your Send Timeout.

---

-- Please mark as answered if this answers your question.

Answer 2

Manas

Which WCF server or client settings do you need to change to resolve this?

thanks