Post reply

not able to find why/where this error is comming.

  • July 3, 2016 at 1:16 am

    #311461

    hi,

    i am getting this error"The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction "

    please tel me some key words , show that i will search in my stored prcedure to find where loging is going on, some body said when u send email then also it comes , so it not only "write to the log".

    yours sincerley

  • July 3, 2016 at 10:42 pm

    #1888240

    Have you tried searching for "The current transaction cannot be committed and cannot support operations that write to the log file".

    Also, any triggers on the tables?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • July 4, 2016 at 5:58 pm

    #1888362

    rajemessage 14195 (7/3/2016)

    please tel me some key words , show that i will search in my stored prcedure

    TRY -- CATCH ?

    _____________
    Code for TallyGenerator

  • July 4, 2016 at 8:10 pm

    #1888367

    Sergiy (7/4/2016)

    rajemessage 14195 (7/3/2016)

    please tel me some key words , show that i will search in my stored prcedure

    TRY -- CATCH ?

    Or just BEGIN TRANSACTION?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • July 4, 2016 at 11:56 pm

    #1888375

    Jeff Moden (7/4/2016)

    Sergiy (7/4/2016)

    rajemessage 14195 (7/3/2016)

    please tel me some key words , show that i will search in my stored prcedure

    TRY -- CATCH ?

    Or just BEGIN TRANSACTION?

    Most likely - both.

    First BEGIN TRANSACTION

    followed by TRY -- CATCH

    _____________
    Code for TallyGenerator

  • July 5, 2016 at 9:31 am

    #1888489

    i known begin tran and try cache , what i am asking is, which stmt might be the reason of generating this error.

    your sincerley

  • July 5, 2016 at 1:07 pm

    #1888543

    which stmt might be the reason of generating this error

    Well, we would need to see the statements, at least...

  • July 5, 2016 at 1:29 pm

    #1888554

    Are you using Try-Catch for handling the errors?

    Remember the 'TRY' will immediately jump to the CATCH when there is an error.

    Then, when you're in the CATCH, and if you are using the XACT_STATE to decide whether you can commit, make sure to

    check the XACT_STATE before a COMMIT, not before a rollback.

    Once you check the XACT_STATE and Rollback, then do the stuff needed like, sending DB email etc. Other wise you are going to see the error - 'can not write to log file'

  • July 5, 2016 at 2:02 pm

    #1888562

    rajemessage 14195 (7/5/2016)

    i known begin tran and try cache , what i am asking is, which stmt might be the reason of generating this error.

    your sincerley

    BEGIN TRAN and TRY/CATCH are things to check for in code that may be a cause of this problem.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 9 posts - 1 through 8 (of 8 total)

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