Re: replication problem
Posted in 2000
G'khan:
Do you have ATS and RIS enabled? If so, check on the target instance for
the logs.
Post the logs along with "cdr list repl <replicate name, ...>, and we can
help you.
Steve Romankiw
----- Original Message -----
From: G'khan Fidan
To: informix-list@iiug.org
Sent: Wednesday, August 16, 2000 11:07 AM
Subject: replication problem
Hi,
We are trying to run primary-target replication between two informix servers
by using CLU.
Primary;IDS 7.31 UC6
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=55 WHERE tezkod=20001
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,