none
ORA 3135 Exception thrown by the Oracle LOB Adapter RRS feed

  • Question

  • Hi,

    I get the following exception when the oracle adapter first tries to make a connection with oracle database. The BizTalk Application executes successfully. But I see this error in the Application log every time it runs.

    It seems like the adapter tries to use a connection from the connection pool that is no longer alive.

    There is a firewall between the BizTalk server and oracle database.

    Does anybody know why this happens and if there is a way to fix it?

    Thanks,
    Nandita

    Description:
    The adapter failed to transmit message going to send port "IdentMgmt.ECommerce.AvailableReports.sndOracleUserExists" with URL "oracledb://ecom/". It will be retransmitted after the retry interval specified for this Send Port. Details:"Microsoft.ServiceModel.Channels.Common.TargetSystemException: ORA-03135: connection lost contact ---> Oracle.DataAccess.Client.OracleException ORA-03135: connection lost contact    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.ExecuteNonQuery()
       at Microsoft.Adapters.OracleDB.OracleDBXmlParser.ExecuteSingleCommand(OracleCommand command, Boolean recordPresent, Boolean accumateRowAffected)
       at Microsoft.Adapters.OracleDB.OracleDBXmlParser.ExecutePackProcFunc(AdapterDataTable parsedMessage)
       --- 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)".

     

    Monday, August 24, 2009 2:20 PM

Answers

  • What are the connection pool settings that you are using? As there is a firewall, MAYBE it is not possible to "pool" connections, though I'm not sure of that.
    You can try disabling ConnectionPooling. If that works, you should enable connection pool, and set connection pool size to 1 to confirm this theory.

    It does seem that there is some problem of connectivity between your BizTalk machine and the Oracle instance. You can try running a small ODP.NET sample code on the same machine as BizTalk server, and that should give you enough information to get support from your DB admin or Oracle Support.

    Thanks,
    Manas
    Monday, August 24, 2009 2:45 PM

All replies

  • What are the connection pool settings that you are using? As there is a firewall, MAYBE it is not possible to "pool" connections, though I'm not sure of that.
    You can try disabling ConnectionPooling. If that works, you should enable connection pool, and set connection pool size to 1 to confirm this theory.

    It does seem that there is some problem of connectivity between your BizTalk machine and the Oracle instance. You can try running a small ODP.NET sample code on the same machine as BizTalk server, and that should give you enough information to get support from your DB admin or Oracle Support.

    Thanks,
    Manas
    Monday, August 24, 2009 2:45 PM
  • did you get a solution to this problem ?? I'm having a similar issue

    Wednesday, September 23, 2009 5:39 PM