none
WCF ORACLE EBS adapter Polling RRS feed

  • General discussion

  • Hi,

    I am trying to Poll oracle tables using EBS adapter.

    I have installed oracle client and all the required stuff. I am getting the folowing error. It says Invalid sql statement. However i  executed the same sql query on ORacledB and it works fine. its a simple select query.for ex select * from [tablename]. I dont know where i am going wrong.

    I am using Biztalk server 2006 R2 with sql server 2005 and oracle 11 g installed.

    Kindly help me on this issue. Thanks

    Error:Event Type: Warning
    Event Source: BizTalk Server 2006
    Event Category: BizTalk Server 2006
    Event ID: 5740
    Date:  8/5/2010
    Time:  4:15:22 PM
    User:  N/A
    Computer: 

    Description:
    The adapter "WCF-OracleEBS" raised an error message. Details "Microsoft.ServiceModel.Channels.Common.TargetSystemException: ORA-00900: invalid SQL statement ---> Oracle.DataAccess.Client.OracleException ORA-00900: invalid SQL statement    at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheckForOra1000Error)
       at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheckForOra1000Error)
       at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
       at Microsoft.Adapters.OracleCommon.OracleCommonUtils.ExecuteNonQuery(OracleCommand command, OracleCommonExecutionHelper executionHelper)
       --- End of inner exception stack trace ---
       at Microsoft.Adapters.OracleCommon.OracleCommonUtils.ExecuteNonQuery(OracleCommand command, OracleCommonExecutionHelper executionHelper)
       at Microsoft.Adapters.OracleCommon.SelectResponseBodyWriter.OnWriteBodyContents(XmlDictionaryWriter writer)
       at System.ServiceModel.Channels.BodyWriter.WriteBodyContents(XmlDictionaryWriter writer)
       at System.ServiceModel.Channels.BodyWriterMessage.OnWriteBodyContents(XmlDictionaryWriter writer)
       at System.ServiceModel.Channels.Message.WriteBodyContents(XmlDictionaryWriter writer)
       at Microsoft.Adapters.AdapterUtilities.AdapterMessage.OnWriteBodyContents(XmlDictionaryWriter writer)
       at System.ServiceModel.Channels.Message.WriteBodyContents(XmlDictionaryWriter writer)
       at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfMarshaller.CreateBizTalkMessageStream(Message wcfMessage, IAdapterConfigInboundMessageMarshalling config)
       at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfMarshaller.CreateBizTalkMessage(IBaseMessageFactory messageFactory, IAdapterConfigInboundMessageMarshalling marshallingConfig, Message wcfMessage)
       at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfMarshaller.CreateBizTalkSubmitMessage(IBaseMessageFactory factory, String inboundTransportLocation, String inboundTransportType, RLConfig config, Message wcfMessage, String ssoToken)
       at Microsoft.BizTalk.Adapter.Wcf.Runtime.BizTalkSubmitBase..ctor(Message message, BizTalkEndpointContext endpointContext, ControlledTermination control, AsyncCallback realCallback, String ssoToken)
       at Microsoft.BizTalk.Adapter.Wcf.Runtime.BizTalkSubmitTxn..ctor(Message message, AsyncCallback callback, Object state, Transaction transaction, BizTalkEndpointContext endpointContext, String ssoToken, ControlledTermination control)
       at Microsoft.BizTalk.Adapter.Wcf.Runtime.BizTalkOperation.Create(Message message, AsyncCallback callback, Object state, String ssoToken, Boolean bizTalkOneWay, BizTalkEndpointContext endpointContext, ControlledTermination control)
       at Microsoft.BizTalk.Adapter.Wcf.Runtime.BizTalkServiceInstance.BeginOperation(Message message, AsyncCallback callback, Object state, Boolean bizTalkOneWay)".

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

     

    Also suggest me some other workaround for following scenario.. i need to get data from Oracle DB table to BizTalk using EBS adapter whenever there is new entry in table.

    Thursday, August 5, 2010 11:09 AM

All replies

  • hiii,

    i did some modifications to the select query

    for ex: select * from [Table name] FOR UPDATE

    and i landed on to the following error:

    Event Type: Information
    Event Source: Oracle.orcl
    Event Category: None
    Event ID: 5
    Date:  8/5/2010
    Time:  6:53:47 PM
    User:  N/A
    Computer: 01HW166917
    Description:
    The description for Event ID ( 5 ) in Source ( Oracle.orcl ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: CJQ0, orcl.
    -----------------------------

    Event Type: Warning
    Event Source: BizTalk Server 2006
    Event Category: BizTalk Server 2006
    Event ID: 5740
    Date:  8/5/2010
    Time:  7:02:50 PM
    User:  N/A
    Computer: 01HW166917
    Description:
    The adapter "WCF-OracleEBS" raised an error message. 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 bCheckForOra1000Error)
       at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheckForOra1000Error)
       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 ---
       at Microsoft.Adapters.OracleCommon.OracleCommonUtils.ExecuteReader(OracleCommonConnectionWrapper connection, String commandText, IEnumerable`1 parameters, CommandBehavior commandBehavior, IOracleAdapterCommonBindingProperties properties, OracleCommonExecutionHelper executionHelper)
       at Microsoft.Adapters.OracleEBS.OracleEBSInboundHandler.Polling_TryReceive_TableView(OracleCommonExecutionHelper executionHelper, Message& wcfMessage)
       at Microsoft.Adapters.OracleEBS.OracleEBSInboundHandler.TryReceive(TimeSpan timeout, Message& message, IInboundReply& reply)
       at Microsoft.ServiceModel.Channels.Common.Channels.AdapterInputChannel.TryReceive(TimeSpan timeout, Message& message)
       at System.ServiceModel.Dispatcher.InputChannelBinder.TryReceive(TimeSpan timeout, RequestContext& requestContext)
       at System.ServiceModel.Dispatcher.ErrorHandlingReceiver.TryReceive(TimeSpan timeout, RequestContext& requestContext)".

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

    I tried to google it but dint get ne help.

    Kindly help me with this.

     

    Thursday, August 5, 2010 1:37 PM
  • The second error is a timeout error. Can you increase your receive timeout setting and check?
    Monday, August 9, 2010 10:38 AM