none
Biztalk-server 2006 R2 RRS feed

  • Question

  • Hi

    I have a scenario where I have to insert five different records into five different Staging tables using Wcf-oracle DB adapter

    Each File can have many records. It is a batch insert into all five different tables.Im not using stored procedure

    I get the incoming message , perform necessary transformations and send to all different tables.

    The message type is different, so im using 5 different send ports

    Im using all the send ports inside an atomic shape. If any one one the messages fails ie. if any record insert fails in any of the  five tables, I have to roll back the whole transaction.

    In Wcf-oracle db Adapter, there is a property called UseAmbient transaction which I have set to true. When this is set to true,Im getting an error as Ambient transaction is present or tns ORA is more than 39 characters in length.

    I have tried setting the Ambient transaction to true.That works well and all the records are inserted into the 5 tables.

    There are five different unique keys for all the 5 staging tables.So if i insert duplicate values, it gives an error but for eg. if the value for the first record is "1" in a column, the second value is "2" and again the third value is "1", the first two records are getting inserted and its not rolled back.

    Kindly plz help me regarding this on how to roll-back the inserted records using wcf-oracle db adapter

    Thursday, September 22, 2011 2:43 PM

Answers

  • Check this msdn article for some known issues troubleshooting
    Regards,
    Bali
    MCTS: BizTalk Server 2010,BizTalk Server 2006 and WCF
    Blog: http://dpsbali-biztalkweblog.blogspot.com
    -----------------------------------------------------
    Mark As Answer or Vote As Helpful if this helps.
    • Marked as answer by Srirams05 Wednesday, September 28, 2011 5:45 AM
    Thursday, September 22, 2011 3:35 PM

All replies

  • There is a small correction when i set ambient transaction to false it works, if i set to true im getting errors
    Thursday, September 22, 2011 2:45 PM
  • Check this msdn article for some known issues troubleshooting
    Regards,
    Bali
    MCTS: BizTalk Server 2010,BizTalk Server 2006 and WCF
    Blog: http://dpsbali-biztalkweblog.blogspot.com
    -----------------------------------------------------
    Mark As Answer or Vote As Helpful if this helps.
    • Marked as answer by Srirams05 Wednesday, September 28, 2011 5:45 AM
    Thursday, September 22, 2011 3:35 PM
  • Hi,

    See this thread on forum, I think you may need to implement a composite operation.

    HTH

    Regards,

    Steef-Jan Wiggers
    MVP & MCTS BizTalk Server 2010
    http://soa-thoughts.blogspot.com/
    If this answers your question please mark it accordingly

     


    BizTalk
    Thursday, September 22, 2011 5:16 PM
    Moderator