How to track Oracle Adapter Error?

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › How to track Oracle Adapter Error?

Viewing 1 reply thread
  • Author
    Posts
    • November 20, 2008 at 11:32 PM #21238
      community-content

        Hi,

        I got the following warning (NOT error, it is the yellow one)

        Event Type: Warning
        Event Source: BizTalk Server 2006
        Event Category: BizTalk Server 2006
        Event ID: 5740
        Date:  11/7/2008
        Time:  2:39:13 PM
        User:  N/A
        Computer: BIZTALKT01
        Description:
        The adapter “WCF-Custom” raised an error message. Details “Microsoft.ServiceModel.Channels.Common.TargetSystemException: ORA-00936: missing expression —> Oracle.DataAccess.Client.OracleException ORA-00936: missing expression    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()
           at Microsoft.Adapters.OracleDB.OracleDBInboundContract.ExecuteThread()
           — End of inner exception stack trace —
           at Microsoft.ServiceModel.Channels.Common.Design.AdapterAsyncResult.End()
           at Microsoft.ServiceModel.Channels.Common.Channels.AdapterReplyChannel.EndTryReceiveRequest(IAsyncResult result, RequestContext& requestContext)
           at System.ServiceModel.Dispatcher.ReplyChannelBinder.EndTryReceive(IAsyncResult result, RequestContext& requestContext)
           at System.ServiceModel.Dispatcher.ErrorHandlingReceiver.EndTryReceive(IAsyncResult result, RequestContext& requestContext)”.

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

        Can I suspend it? It keep retrying and not go to the exception. I use a catch system.exception in the orchestration.

        Thx.

        Wayne.

      • February 23, 2010 at 4:11 AM #24273
        community-content

          I know this might be a bit too late for you :-). But as a service to others with the same problem:

          Add a reference to Microsoft.ServiceModel.Channels and System.ServiceModel in your project.

          Now you can catch the Microsoft.ServiceModel.Channels.Common.TargetSystemException and suspend the instance with a nice message.

          • February 23, 2010 at 6:33 AM #24275
            community-content

              Oops. Seems it is an exception of type Microsoft.XLANGs.Core.XlangSoapException.

              Add this in your ODX, in the catch shape (for some reason it can’t be selected the usual way):

              <om:Property Name=”ExceptionType” Value=”Microsoft.XLANGs.Core.XlangSoapException” />

        • Author
          Posts
        Viewing 1 reply thread
        • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.