Post reply

uncommittable transaction is detected at the end of batch. the transaction is rolled back

  • May 6, 2009 at 2:00 am

    #133847

    Application is working fine in one server, but after moving all user databases to another server, we got following error:

    "uncommittable transaction is detected at the end of batch. the transaction is rolled back"

    Please help me to resolve problem.

    Thanks

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • May 6, 2009 at 3:28 am

    #989390

    More info is needed. Can you post the batch code?

    Maybe a trace can pinpoint the problem?

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • May 6, 2009 at 5:32 am

    #989435

    What you seem to have is a problem where the record is acceptable in one database but not theother. Suggest you look at the differnces between the two database structures (yes I know they are supposed to be the same, but clearly they are not). Suspect you will either find a collation difference, a data type differnce, or a data length differnce between the two. YOu might also have a table where the identity definition is missing and thus it can't insert becasue it is a required field and the value is missing. Tools like SQl Compare are easy to use to find differences

    [font="Comic Sans MS"]+++BLADE+++[/font]:cool:

  • May 6, 2009 at 8:13 am

    #989564

    we have compare two databases both are same on both servers.

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • May 6, 2009 at 2:12 pm

    #989926

    Are you able to break down the batch into seperate commands? If you run each part seprately, you can see wich part of the batch is causing the failure.

    This is a long shot, but are the rights sufficient?

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 5 posts - 1 through 4 (of 4 total)

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