IDS Forum

Re: ER:cdr sync stops whith 528: Maximum output ro

Posted By: GERARDO PADIERNA
Date: Monday, 10 October 2011, at 10:51 a.m.

In Response To: Re: ER:cdr sync stops whith 528: Maximum output ro (Richard Snoke)

Hi Richard,
here the exact error I get:
(...)
Oct 10 2011 14:37:52 ------ Table scan for templ_oc_pks_g_secu_3_586_informes start --------

Node Rows Extra Missing Mismatch Processed
---------------- --------- --------- --------- --------- ---------
g_prim 2497 0 0 0 0
g_secu 0 0 2497 0 0

WARNING: replicate is not in sync
Oct 10 2011 14:38:02 ------ Table scan for templ_oc_pks_g_secu_3_586_informes end ---------

Oct 10 2011 14:38:02 ------ Table scan for templ_oc_pks_g_secu_3_554_uhd_contacto start --------

Error returned from createStatement: prepare verbose_1932 from Select cont_uhd_key, ctma_turno, epi_key, ctma_tipo_contacto, prof_key, usu_key, motivo_contacto, anamnesis, explo_fisicas, explo_compl, ucont_evolucionplan, is_historico, ucont_en_hc, ucont_contacto_1_2, maac_key_tipocontacto, ucont_fecha_paso_hc, ucont_valoracion_ant, ucont_evoluciones_ant, ucont_estamento, informe_key, ucont_fecha_introd, cont_key, ucont_modificable, ifx_checksum(explo_compl_text, NULL)::lvarchar as explo_compl_text from orion_clinic@g_prim:"orion_dba".uhd_contacto where cont_uhd_key = ?

Error Details:

528: Maximum output rowsize (32767) exceeded.

Current Connection:conn5, Database:orion_clinic@g_prim
command failed -- SQL failure (195)

- here the table definition:

{ TABLE "orion_dba".uhd_contacto row size = 32761 number of columns = 24 index size = 63 }
create table "orion_dba".uhd_contacto
(

cont_uhd_key serial not null ,

ctma_turno nvarchar(10) not null ,

epi_key integer not null ,

ctma_tipo_contacto nvarchar(10) not null ,

prof_key integer not null ,

usu_key integer not null ,

motivo_contacto lvarchar(1990),

anamnesis lvarchar,

explo_fisicas lvarchar,

explo_compl lvarchar(2000),

ucont_evolucionplan lvarchar(5350),

is_historico integer

default 0,

ucont_en_hc smallint,

ucont_contacto_1_2 smallint,

maac_key_tipocontacto integer,

ucont_fecha_paso_hc datetime year to fraction(5),

ucont_valoracion_ant lvarchar(3000),

ucont_evoluciones_ant lvarchar(16150),

ucont_estamento nvarchar(15),

informe_key integer,

ucont_fecha_introd datetime year to fraction(5),

cont_key integer,

ucont_modificable smallint,

explo_compl_text text,

primary key (cont_uhd_key) constraint "informix".u1139_3484
) extent size 16 next size 16 lock mode row;

revoke all on "orion_dba".uhd_contacto from "public" as "orion_dba";

alter table "orion_dba".uhd_contacto add constraint (foreign

key (prof_key) references "orion_dba".profesionales constraint

"informix".fk_contacto_uhd_profesional);
alter table "orion_dba".uhd_contacto add constraint (foreign

key (epi_key) references "orion_dba".episodios constraint

"informix".fk_contacto_uhd_episodios);
alter table "orion_dba".uhd_contacto add constraint (foreign

key (usu_key) references "orion_dba".usuarios constraint

"informix".fk_contacto_uhd_usuario);
alter table "orion_dba".uhd_contacto add constraint (foreign

key (maac_key_tipocontacto) references "orion_dba".maestro_actos

constraint "informix".fk_uhd_contacto2maac);
alter table "orion_dba".uhd_contacto add constraint (foreign

key (informe_key) references "orion_dba".informes constraint

"informix".fk_uhd_contacto2informe);
alter table "orion_dba".uhd_contacto add constraint (foreign

key (cont_key) references "orion_dba".contactos constraint

"informix".fk_contacto_uhd_2_contactos);

- template definition detail (peformed not directly, but defined through a template definition):

cdr list repl brief templ_oc_pks_g_secu_3_554_uhd_contacto

REPLICATE TABLE SELECT
----------------------------------------------------------------------------
templ_oc_pks_g_secu_3_554_uhd_contacto orion_clinic@g_prim:orion_dba.uhd_contacto select t.cont_uhd_key, t.ctma_turno, t.epi_key, t.ctma_tipo_contacto, t.prof_key, t.usu_key, t.motivo_contacto, t.anamnesis, t.explo_fisicas, t.explo_compl, t.ucont_evolucionplan, t.is_historico, t.ucont_en_hc, t.ucont_contacto_1_2, t.maac_key_tipocontacto, t.ucont_fecha_paso_hc, t.ucont_valoracion_ant, t.ucont_evoluciones_ant, t.ucont_estamento, t.informe_key, t.ucont_fecha_introd, t.cont_key, t.ucont_modificable, t.explo_compl_text from 'orion_dba'.uhd_contacto t
templ_oc_pks_g_secu_3_554_uhd_contacto orion_clinic@g_secu:orion_dba.uhd_contacto select t.cont_uhd_key, t.ctma_turno, t.epi_key, t.ctma_tipo_contacto, t.prof_key, t.usu_key, t.motivo_contacto, t.anamnesis, t.explo_fisicas, t.explo_compl, t.ucont_evolucionplan, t.is_historico, t.ucont_en_hc, t.ucont_contacto_1_2, t.maac_key_tipocontacto, t.ucont_fecha_paso_hc, t.ucont_valoracion_ant, t.ucont_evoluciones_ant, t.ucont_estamento, t.informe_key, t.ucont_fecha_introd, t.cont_key, t.ucont_modificable, t.explo_compl_text from 'orion_dba'.uhd_contacto t

Curiously enough, the row size in the table definition is already 32761.

Thanks.

Messages In This Thread

• ER:cdr sync stops whith 528: Maximum output rowsiz
  GERARDO PADIERNA -- Monday, 10 October 2011, at 8:58 a.m.
  • Re: ER:cdr sync stops whith 528: Maximum output ro
    Richard Snoke -- Monday, 10 October 2011, at 10:13 a.m.
    • Re: ER:cdr sync stops whith 528: Maximum output ro
      GERARDO PADIERNA -- Monday, 10 October 2011, at 10:51 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.