replication problem
This is a multi-part message in MIME format.
------=_NextPart_000_000F_01C007AC.DFE3EE00
Content-Type: text/plain;
charset="iso-8859-9"
Content-Transfer-Encoding: quoted-printable
Hi,
We are trying to run primary-target replication between two informix =
servers by using CLU.
Primary;IDS 7.31 UC6=20
Target;IDS 7.31 UC2
both on the same platform Sun Solaris 7 and both have same databases.
We have 7 tables in the database to replicate and after defining and =
starting replicates, 6 of them run correctly but nothing changes in one =
of the tables in target server.We tried with following sql in primary;
UPDATE tez SET tezkod=3D55 WHERE tezkod=3D20001
and record updated successfully on primary server with no error.
But no change in the same record on target server.
We have the following error message in online.log of the target server;
CDRDS:Transaction aborted ( Error return from SQL for the commit =
command)
Any idea?
Thanks,
------=_NextPart_000_000F_01C007AC.DFE3EE00
Content-Type: text/html;
charset="iso-8859-9"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-9" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2614.3401" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>We are trying to run primary-target =
replication=20
between two informix servers by using CLU.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Primary;IDS 7.31 UC6 </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Target;IDS 7.31 UC2</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>both on the same platform Sun Solaris 7 =
and both=20
have same databases.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>We have 7 tables in the database to =
replicate and=20
after defining and starting replicates, 6 of them run correctly but =
nothing=20
changes in one of the tables in target server.We tried with following =
sql in=20
primary;</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>UPDATE tez SET tezkod=3D55 WHERE=20
tezkod=3D20001</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>and record updated successfully on =
primary server=20
with no error.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>But no change in the same record on =
target=20
server.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>We have the following error message in =
online.log=20
of the target server;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>CDRDS:Transaction aborted ( Error =
return from SQL=20
for the commit command)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Any idea?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV></BODY></HTML>
------=_NextPart_000_000F_01C007AC.DFE3EE00--