Sign in
 
HomeLibraryLearnDownloadsSupportForums
Resources for IT Professionals > Forums Home > BizTalk Server Forums > BizTalk Server Adapters and Adapter Pack > WCF-ORACLE ADAPTOR
Ask a questionAsk a question
Search Forums:
 

AnswerWCF-ORACLE ADAPTOR

  • Wednesday, August 26, 2009 1:46 AMBizUser22 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Hi All,

    Can Some one sugest how to increase the polltime or keep the oracle connection alive.

    1. When ran the procedure through SQlPLUS it results output but time is too long but returned the result.
    2. When testing with BizTalk we are not getting any results its getting timedout.

    Can some one suggest which binding properties need to be changed.

    Thanks
     

Answers

All Replies

  • Wednesday, August 26, 2009 5:28 AMMurali Narumanchi[MSFT] Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Sign In to Vote
    0
    Sign In to Vote

    If you are using polling, pls refer to ReceiveTimeout binding property.

    Pls refer to the following documentation link for all the Binding Properties:
    http://msdn.microsoft.com/en-us/library/dd788467(BTS.10).aspx 

    Thanks,
    --Murali

    This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm
     
  • Saturday, August 29, 2009 5:39 AMBizUser22 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    Thanks Murali...

    Adapter is working okay but I am getting following error can you suggest things i need to consider.


    Uncaught exception (see the 'inner exception' below) has suspended an instance of service XXXXXX.Orchestrations.AAAA(80610e00-a9b4-776b-afe0-fc9b15c29573)'.
    The service instance will remain suspended until administratively resumed or terminated.
    If resumed the instance will continue from its last persisted state and may re-throw the same unexpected exception.
    InstanceId: 284dcd3a-69b0-4fa3-a81d-6d8d854159d8
    Shape name:
    ShapeId:
    Exception thrown from: segment -1, progress -1
    Inner exception: An error occurred while processing the message, refer to the details section for more information
    Message ID: {AF0EF706-578D-433E-BFD6-08B0164E500C}
    Instance ID: {6F1EA10B-5614-4F54-BED3-B1848305A5F9}
    Error Description: System.Transactions.TransactionException: The operation is not valid for the state of the transaction.
       at System.Transactions.TransactionState.EnlistVolatile(InternalTransaction tx, IEnlistmentNotification enlistmentNotification, EnlistmentOptions enlistmentOptions, Tran


    System.Transactions.TransactionException: The operation is not valid for the state of the transaction.
       at System.Transactions.TransactionState.EnlistVolatile(InternalTransaction tx, IEnlistmentNotification enlistmentNotification, EnlistmentOptions enlistmentOptions, Transaction atomicTransaction)
       at System.Transactions.Transaction.EnlistVolatile(IEnlistmentNotification enlistmentNotification, EnlistmentOptions enlistmentOptions)
       at Microsoft.BizTalk.Adapter.Wcf.Runtime.TxnBatch2..ctor(IBTTransportProxy transportProxy, ControlledTermination control, Transaction transaction, ManualResetEvent orderedEvent, Boolean makeSuccessCall)
       at Microsoft.BizTalk.Adapter.Wcf.Runtime.BizTalkDeleteTxn.Execute(BizTalkExecutionContext executionContext)


    This service instance exists to help debug routing failures for instance "{ED283442-76CA-4319-B649-6E436E6E8E0F}". The context of the message associated with this instance contains all the promoted properties at the time of the routing failure.

     
  • Monday, August 31, 2009 11:38 AMJeevitha - MSFT Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    Have you configured MSDTC and added MSDTC to the firewall exception list. This article will be of help to you.

    Thanks,
    Jeevitha

     
  • Tuesday, September 01, 2009 12:19 AMBizUser22 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Yes,

    Configured MSDTC and added MSDTC to the firewall exceptionslist...
    But the above exception occurs when the execute query is taking more than 4 mins then i am runninginto exceptions....

    Thanks
     
  • Tuesday, September 01, 2009 7:44 AMManas Garg - MSFT Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    I'm guessing that your transaction timeout is expiring. Can you correct that?
     
  • Thursday, September 03, 2009 5:33 PMBizUser22 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Hi Manas,
    Can you suggest which binding property do i need to configure...

    Thanks