none
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)".

     

    Thursday, March 10, 2011 7:53 PM

Answers

  • 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.
    Monday, March 14, 2011 4:22 AM

All replies

  • 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.
    Monday, March 14, 2011 4:22 AM
  • Manas

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

    thanks

    Friday, January 06, 2012 5:14 PM