Replicate rows problem. (TXH CDR:45 Error: Could not read from received stream)

[Vadim Yezhakov]

Hi.
I have replicate source-tables to target-tables. Some records not
replicates.
In ATS file i see such error:
TXH Source ID:21 / Name:g_whrhouse / CommitTime:03-10-16 02:45:35
TXH Target ID:8 / Name:g_almwhr / ReceiveTime:03-10-16 02:44:44
TXH Number of rows processed when transaction was aborted:2
TXH One or more rows in a transaction defined with tx scope were
rejected
TXH CDR:45 (Error: Could not read from received stream.) / SQL:0 /
ISAM:0
----------
RRH Row:1 / Replicate Id: 1376265 / Table: [email]wharehouse@nat.docl[/email]ist /
DbOp:Insert
RRD 2257575|4354|R300No00CY200000000000000|is-efno2257575|0||<4353,
TEXT, PB>|<180, TEXT, PB>||2003-10-16 12:00:00|2003-10-16
13:34:26|d620.00.2
----------
RRH Row:2 / Replicate Id: 1376262 / Table:
[email]wharehouse@nat.doca[/email]ttributes / DbOp:Insert
RRD is-efno2257575|||302616102003000198||{E45CCE83-FF46-11D7-8964-005022924513}|?

What is it mean? May be it's occured because of there are locks on
sourse-server?

[Hari Gupta]

Not 100% sure but I have seen such error before and in my case, I found that
there was an update on a record on primary which was not there on
secondary.

Hari
"Vadim Yezhakov" <yezhakov@mail.ru> wrote in message
news:2d8b1865.0310160023.703bbc80@posting.google.c om...

> Hi.
> I have replicate source-tables to target-tables. Some records not
> replicates.
> In ATS file i see such error:
> TXH Source ID:21 / Name:g_whrhouse / CommitTime:03-10-16 02:45:35
> TXH Target ID:8 / Name:g_almwhr / ReceiveTime:03-10-16 02:44:44
> TXH Number of rows processed when transaction was aborted:2
> TXH One or more rows in a transaction defined with tx scope were
> rejected
> TXH CDR:45 (Error: Could not read from received stream.) / SQL:0 /
> ISAM:0
> ----------
> RRH Row:1 / Replicate Id: 1376265 / Table: [email]wharehouse@nat.docl[/email]ist /
> DbOp:Insert
> RRD 2257575|4354|R300No00CY200000000000000|is-efno2257575|0||<4353,
> TEXT, PB>|<180, TEXT, PB>||2003-10-16 12:00:00|2003-10-16
> 13:34:26|d620.00.2
> ----------
> RRH Row:2 / Replicate Id: 1376262 / Table:
> [email]wharehouse@nat.doca[/email]ttributes / DbOp:Insert
> RRD

is-efno2257575|||302616102003000198||{E45CCE83-FF46-11D7-8964-005022924513}|
?

>
> What is it mean? May be it's occured because of there are locks on
> sourse-server?

[Madison Pruet]

Probably a result of your other problem.

Check "cdr error -a" to see if the replicate definitions on one of the
servers failed.

M.P.

"Vadim Yezhakov" <yezhakov@mail.ru> wrote in message
news:2d8b1865.0310160023.703bbc80@posting.google.c om...

> Hi.
> I have replicate source-tables to target-tables. Some records not
> replicates.
> In ATS file i see such error:
> TXH Source ID:21 / Name:g_whrhouse / CommitTime:03-10-16 02:45:35
> TXH Target ID:8 / Name:g_almwhr / ReceiveTime:03-10-16 02:44:44
> TXH Number of rows processed when transaction was aborted:2
> TXH One or more rows in a transaction defined with tx scope were
> rejected
> TXH CDR:45 (Error: Could not read from received stream.) / SQL:0 /
> ISAM:0
> ----------
> RRH Row:1 / Replicate Id: 1376265 / Table: [email]wharehouse@nat.docl[/email]ist /
> DbOp:Insert
> RRD 2257575|4354|R300No00CY200000000000000|is-efno2257575|0||<4353,
> TEXT, PB>|<180, TEXT, PB>||2003-10-16 12:00:00|2003-10-16
> 13:34:26|d620.00.2
> ----------
> RRH Row:2 / Replicate Id: 1376262 / Table:
> [email]wharehouse@nat.doca[/email]ttributes / DbOp:Insert
> RRD

is-efno2257575|||302616102003000198||{E45CCE83-FF46-11D7-8964-005022924513}|
?

>
> What is it mean? May be it's occured because of there are locks on
> sourse-server?