Oninit cdi / Archive
Talk to an expert →

Error Replication

Posted in 2009

Topics: High Availability & Replication, Stored Procedures & SPL, Server Administration, Platform-Specific Issues, Versions, Editions & End-of-Life

KURT VAN GOMPEL — — source: IIUG Forums & Mailing Lists

Hello, We are using IDS 7.31 on Solaris 8 and Windows NT4. The solaris server is defined as a root server for Enterprise Replication. The servers NT4 are defined as leaf servers (12 servers). We changed the structure of a table (changed 1 zone from char(30) into char(100) and added a new field char(7)). This table is replicated (primary target) from the leaf servers to the root server. Since the modifications, we sometimes get the following replication error: TXH CDR:23 (Error: Internal error (buffer too small for stored procedure arguments)) / SQL:0 / ISAM:0 ---------- RRH Row:1 / Collection Id: 45810467 / Replicate Id: 45810467 / Table: hziv@dbahziv.r_fichmed / DbOp:Delete RRD ????Unable to format row data RRD 0x00000000: 36313530 30373833 32393336 00003184 615007832936..1 0x00000010: 0001000a 6500009c 3800009c 3cfff56a ....e..8..<ÿõj Has anyone any idea? Thanks.

↪ replying to KURT VAN GOMPEL
Nilesh Ozarkar — — source: IIUG Forums & Mailing Lists

You need to redefine the replicate to include table schema changes. In = IDS version 11.50 you can alter the replicated table while replication is active and don't have to redefine replicate to include schema changes. Regards, Nilesh ids-bounces@iiug.org wrote on 08/07/2009 07:00:52 AM: > [image removed] > > Error Replication [16623] > > KURT VAN GOMPEL > > to: > > ids > > 08/10/2009 11:58 AM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > Hello, > > We are using IDS 7.31 on Solaris 8 and Windows NT4. > The solaris server is defined as a root server for Enterprise > Replication. The > servers NT4 are defined as leaf servers (12 servers). > We changed the structure of a table (changed 1 zone from char(30) int= o > char(100) and added a new field char(7)). This table is replicated (primary > target) from the leaf servers to the root server. > Since the modifications, we sometimes get the following replication error: > > TXH CDR:23 (Error: Internal error (buffer too small for stored proced= ure > arguments)) / SQL:0 / ISAM:0 > ---------- > RRH Row:1 / Collection Id: 45810467 / Replicate Id: 45810467 / Table:= > hziv@dbahziv.r_fichmed / DbOp:Delete > RRD ????Unable to format row data > RRD 0x00000000: 36313530 30373833 32393336 00003184 615007832936..1 > > 0x00000010: 0001000a 6500009c 3800009c 3cfff56a ....e..8..<=FF=F5j > > Has anyone any idea? > Thanks. > > > ***********************************************************************= ******** > Forum Note: Use "Reply" to post a response in the discussion forum.= >=

↪ replying to Nilesh Ozarkar
KURT VAN GOMPEL — — source: IIUG Forums & Mailing Lists

We did redefine the replicates because, as you said yourself, in version 7.31 you can't alter a table that is replicated.

Glossary