Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2003
    Location
    Brussel
    Posts
    52

    Unanswered: Cannot ROLLBACK in a distributed transaction!

    What to do about it? It happens while running a procedure we wrote. We've got a couple of tables with data in. It's possible to copy data from that table and duplicate it (except for his primary key offcourse, thats a new number we get from a sequence).

    Any help is welcome ...
    A good programmer is a LAZY programmer!

  2. #2
    Join Date
    Oct 2003
    Location
    Switzerland
    Posts
    140
    By the very definition of the word "transaction" you should be able to either commit or rollback them, regardless of the fact that you are working in a heterogenous environment. What exactly is the problem, error message, platforms, etc...

  3. #3
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    Hi,

    This is because the operation may not have rolled back all effects of the operation. Since some sites may be inconsistent with others, the transaction must roll back to a savepoint or roll back entirely.
    SATHISH .

  4. #4
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    HI,

    You either Roll back to a savepoint or roll back the entire transaction and resubmit the rolled-back statements.
    SATHISH .

  5. #5
    Join Date
    Sep 2003
    Location
    Brussel
    Posts
    52
    ODBC Error Code = S1000 (General error)

    [Oracle][ODBC][Ora]ORA-02074: cannot ROLLBACK in a distributed transaction ORA-06512: at "***.COPY_CURS_TOT_TO_NEW", line 460 ORA-00911: invalid character ORA-06512: at line 1

    The error occurred while processing an element with a general identifier of (CFSTOREDPROC), occupying document position (287:2) to (287:76).

    That's the error ... I just don't see it ... this is the error message of the coldfusion server I'm working with, the procedure doesn't give errors itself. I putted it in SQL*Plus and all I had was 'Procedure is aangemaakt' -> Dutch for 'Procedure created'

    In Oracle DBA Studio the status of the procedure is 'VALID', so ... dunno.

    Any help is welcome!
    A good programmer is a LAZY programmer!

  6. #6
    Join Date
    Oct 2003
    Location
    Switzerland
    Posts
    140
    Well, sounds no good

    ORA-02074 cannot string in a distributed transaction
    ------------------------------------------------------------
    Cause: A commit or rollback was attempted from session other than the parent of a distributed transaction.

    Action: Only commit or roll back from the parent session.


    I will see if I can get my hands on some more info about the workings of Two-Phase commit. Maybe you can check the Oracle web-site for more details.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •