none
WCF-Oracle Adapter ORA-01003 RRS feed

  • Question

  • Hi,

    Can any one suggest what can i do to fix this kind of error.

    It was processing normally and after processing 30 Transactions it started giving the following error and orchestration got suspended and are in resumable state.

    I have the default setting on the WCF-Oracle port.

    EnableTypeSafing= True
    Enable BizTalkCompatabilityMode = True are the only modified.


    Event Type: Error
    Event Source: BizTalk Server 2006
    Event Category: BizTalk Server 2006
    Event ID: 5754
    Date:  9/12/2009
    Time:  10:20:10 PM
    User:  N/A
    Computer: XXXXXXX
    Description:
    A message sent to adapter "WCF-Custom" on send port "WCF_ORACLE_SP" with URI "oracledb://ABCIT/" is suspended.
     Error details: Microsoft.ServiceModel.Channels.Common.MetadataException: Metadata resolution failed for OperationId: "http://Microsoft.LobServices.OracleDB/2007/03/ABC/Package/ABC-TEST/GETORDERS". ---> Oracle.DataAccess.Client.OracleException ORA-01003: no statement parsed    at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
       at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src)
       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)
     MessageId:  {6B31221B-A632-4456-ADED-7095183F8D2E}
     InstanceID: {9AC45D23-E3DA-4810-B80A-AA0E1C051E05}

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    Friday, September 18, 2009 5:59 PM

All replies

  • It might be a DTS issue.
    Kerrey [BizTalk Consultant]
    Friday, September 18, 2009 7:38 PM
  • Thanks Kerry...

    Do i need to configure any addiitonal properties other than..

    EnableTypeSafing= True
    Enable BizTalkCompatabilityMode = True

    like time outs or connection pool...

    Thanks,
    Friday, September 18, 2009 8:25 PM
  • It looks like an issue on the oracle server. It might help to bing for the error message you're getting in the error message.
    Tuesday, September 22, 2009 4:29 AM
  • Hi,BizUser22

    ->"It was processing normally and after processing 30 Transactions it started giving the following error and orchestration got suspended and are in resumable state."

    This error occur after processing 30 Transactions every time or Just at the first time .
    Microsoft Online Community Support
    Thursday, September 24, 2009 3:02 AM
    Moderator