Re: streams insert - update - commit error handler
Date: Tue, 16 Sep 2008 10:46:19 -0400
Message-ID: <55f303590809160746w780de49bh742786927bbd58a1@mail.gmail.com>
Try to enable ALL and see if all values from where clause will be available
in the trace.
--romas
On Mon, Sep 15, 2008 at 11:40 PM, Ujang Jaenudin <ujang.jaenudin_at_gmail.com>wrote:
> hi roman,
>
> I have enabled PK and UI supplement log for this replication.
>
> --
> thanks and regards
> ujang | oracle dba
> jakarta | http://ora62.wordpress.com
>
> On Mon, Sep 15, 2008 at 9:12 PM, Roman Podshivalov
> <roman.podshivalov_at_gmail.com> wrote:
> > Hi,
> >
> > What kind of supplemental logging you have turned on for DIALCODES table
> ?
> > As you can see in the trace some values are reported as "no available
> value"
> > for where clause of your update:
> >
> > knipdmpargs: dump new argument list:
> > column: "DCID"
> > no available value
> > column: "DCIDPARENT"
> > no available value
> > column: "DCTEXT"
> > no available value
> > column: "DCTYPE"
> > (dty, kncdty, acl, csf, csi, ind)=(1,0,3,1,31,0)
> > value = XXX
> > column: "DCVALIDFROM"
> > no available value
> > column: "DCVALIDTO"
> > no available value
> > column: "DCVALUE"
> > no available value
> >
> > As of creating the band aid solution with an error handler - I personally
> > think you gotta just configure streams correctly and do not reinvent the
> > bicycle 8-)
> >
> > --romas
> >
> > On Mon, Sep 15, 2008 at 9:18 AM, Ujang Jaenudin <
> ujang.jaenudin_at_gmail.com>
> > wrote:
> >>
> >> lists,
> >>
> >> I have tested streams on very simple configuration, which consist of
> >> source and destination database.
> >> for all simple transactions there are no serious conflict/error, but
> >> with this kind of transaction, the apply process become stuck :)
> >
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 16 2008 - 09:46:19 CDT