Re: streams insert - update - commit error handler

  • From: "Roman Podshivalov" <roman.podshivalov@xxxxxxxxx>
  • To: ujang.jaenudin@xxxxxxxxx
  • Date: Mon, 15 Sep 2008 10:12:09 -0400

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: