Re: streams insert - update - commit error handler
- From: "Roman Podshivalov" <roman.podshivalov@xxxxxxxxx>
- To: "Ujang Jaenudin" <ujang.jaenudin@xxxxxxxxx>
- Date: Tue, 16 Sep 2008 10:46:19 -0400
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@xxxxxxxxx>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@xxxxxxxxx> 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@xxxxxxxxx>
> > 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 :)
> >
>
Other related posts:
