Re: streams insert - update - commit error handler

From: Roman Podshivalov <>
Date: Mon, 15 Sep 2008 10:12:09 -0400
Message-ID: <>


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-)


On Mon, Sep 15, 2008 at 9:18 AM, Ujang Jaenudin <>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 :)

Received on Mon Sep 15 2008 - 09:12:09 CDT

Original text of this message