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