ER replication failures from 9.30.FC5 to 10.00.FC3
DL Redden reported ER errors, 'transaction aborted ... tx scope rejected', replicating from 9.30.FC5 to 10.00.FC3, working on some tables only; a PMR was open with IBM. Madison Pruet said this usually means conflict resolution kicked in and asked for the ATS/RIS file. John Carlson asked about the ER definition, primary keys and updates to missing target rows. try_and_err also asked for the RIS files. No resolution given.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
First off I know 9.30.FC5 is out of service, so save your breath. Regardless we still have it production on a few servers and are trying to migrate onto 10.00.FC3. Topology is: P=9.30 T=10.00 Getting the following errors sometimes in the online log: CDR CDRDS: transaction aborted (One or more rows in a transaction defined with tx scope were rejected) with sql error 0 isam error 0. Case opened with IBM (PMR 46038) today so no info from them yet but I know Madison is watching so I thought I'd through this out to see if he'd bite. Funny thing is that replication seems to work on some tables flawlessly and on others not so well. Any ideas or personal experiences, anyone? sending to informix-list
DL Redden schrieb: > First off I know 9.30.FC5 is out of service, so save > your breath. Regardless we still have it production on > a few servers and are trying to migrate onto > 10.00.FC3. An older version means: Fewer features, fewer bugs... > Topology is: > > P=9.30 > T=10.00 > > Getting the following errors sometimes in the online > log: > > CDR CDRDS: transaction aborted (One or more rows in a > transaction defined with tx scope were rejected) with > sql error 0 isam error 0. > > Case opened with IBM (PMR 46038) today so no info from > them yet but I know Madison is watching so I thought > I'd through this out to see if he'd bite. > > Funny thing is that replication seems to work on some > tables flawlessly and on others not so well. > > Any ideas or personal experiences, anyone? What say the RIS-files ? Regards, try_and_err
Usually this means that conflict resolution kicked in. What's in the ATS/RIS file? "DL Redden" <redden96@yahoo.com> wrote in message news:1126293293.5b66ccd2131f488d57b1a3a5cd269b61@teranews... > > First off I know 9.30.FC5 is out of service, so save > your breath. Regardless we still have it production on > a few servers and are trying to migrate onto > 10.00.FC3. > > Topology is: > > P=9.30 > T=10.00 > > Getting the following errors sometimes in the online > log: > > CDR CDRDS: transaction aborted (One or more rows in a > transaction defined with tx scope were rejected) with > sql error 0 isam error 0. > > Case opened with IBM (PMR 46038) today so no info from > them yet but I know Madison is watching so I thought > I'd through this out to see if he'd bite. > > Funny thing is that replication seems to work on some > tables flawlessly and on others not so well. > > Any ideas or personal experiences, anyone? > sending to informix-list
On Fri, 9 Sep 2005 09:39:46 -0700 (PDT), DL Redden <redden96@yahoo.com> wrote: > >First off I know 9.30.FC5 is out of service, so save >your breath. Regardless we still have it production on >a few servers and are trying to migrate onto >10.00.FC3. > >Topology is: > >P=9.30 >T=10.00 > >Getting the following errors sometimes in the online >log: > >CDR CDRDS: transaction aborted (One or more rows in a >transaction defined with tx scope were rejected) with >sql error 0 isam error 0. > What's the ER definition? No active primary key on table? An update to a row on target that doesn't exist? JWC >Case opened with IBM (PMR 46038) today so no info from >them yet but I know Madison is watching so I thought >I'd through this out to see if he'd bite. > >Funny thing is that replication seems to work on some >tables flawlessly and on others not so well. > >Any ideas or personal experiences, anyone? >sending to informix-list