Re: I got the following message when I tried to update a record to through

Home -> Community -> Usenet -> c.d.o.misc -> Re: I got the following message when I tried to update a record to through

From: Albert Dupond <ad_at_ad.com>
Date: Wed, 04 Aug 2004 14:16:06 +0200
Message-ID: <4110d386$0$31060$626a14ce@news.free.fr>

Peter wrote:
> I got the following message when I tried to update a record to through
> a transparent gateway:
>
> ORA-01591: C
Full message is :

01591, 00000, "lock held by in-doubt distributed transaction %s" // *Cause: Trying to access resource that is locked by a dead two-phase commit
// transaction that is in prepared state. // *Action: DBA should query the pending_trans$ and related tables, and attempt

//          to repair network connection(s) to coordinator and commit point.
//          If timely repair is not possible, DBA should contact DBA at 
commit
//          point if known or end user for correct outcome, or use heuristic
//          default if given to issue a heuristic commit or abort command to
//          finalize the local portion of the distributed transaction.

AD Received on Wed Aug 04 2004 - 07:16:06 CDT