Post reply

root transaction wanted to commit, but transaction aborted

  • August 10, 2005 at 4:48 am

    #168266

    Hi,

     

    Is there anybody encountered problem when connecting the BizTalk server to MSSQL server? Because I’m currently suffered from this problem, we have a BizTalk server with IP address of 172.x.x.x and MSSQL with IP address of 170.x.x.x. Here are the details of the problem:

     

    Biztalk can “select” in the MSSQL database, but when the transaction wanted to commit, we encountered problem, Please see the event logs

     

    An error occurred in BizTalk Server.

     

     Details:

     ------------------------------

     [0x8004e002] the root transaction wanted to commit, but transaction aborted.

     

    But when we tried to change the IP Address of BizTalk to 170.x.x.x, the transactions are successfully committed, is this network/IP address problem or MSSQL problem?

     

    Thank you.

     

    Regards,

    Arnold

  • August 10, 2005 at 5:59 am

    #580963

    This link might be relevant:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;275847&sd=tech

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply