Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Rep Agent will not resume to replicating mode.

2 posts in Replication Agent Last posting was on 2004-12-02 18:20:06.0Z
Scott Heffron Posted on 2004-10-28 16:31:40.0Z
From: "Scott Heffron" <sheffron@nutracorp.com>
Newsgroups: sybase.public.rep-agent
Subject: Rep Agent will not resume to replicating mode.
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 63.79.231.50
X-Original-NNTP-Posting-Host: 63.79.231.50
Message-ID: <41811eec$1@forums-1-dub>
Date: 28 Oct 2004 09:31:40 -0700
X-Trace: forums-1-dub 1098981100 63.79.231.50 (28 Oct 2004 09:31:40 -0700)
X-Original-Trace: 28 Oct 2004 09:31:40 -0700, 63.79.231.50
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:729
Article PK: 862370

I am new to replication server and am encountering this error in the log.
Any advise or recommendations would be greatly appreciated.

Rep. Server 12.6
Windows: 2000 Server

I. 2004/10/28 09:51:39. Replication Agent for BAAN.OEI_TRANSFERS connected
in language mode.
E. 2004/10/28 09:51:47. ERROR #32058 REP AGENT(Baan.oei_transfers) -
\nrm\nrm.c(3574)
The value given for 'rs_in0x0100006500000161.t_oabc' cannot be translated
from datatype 'binary' to the required datatype 'varchar'. Value length is
'1'; Maximum target length is '2'; The value is '[02]'.
E. 2004/10/28 09:51:47. ERROR #32058 REP AGENT(Baan.oei_transfers) -
\nrm\nrm.c(3574)
The value given for 'rs_in0x0100006500000161.t_oabc' cannot be translated
from datatype 'binary' to the required datatype 'varchar'. Value length is
'1'; Maximum target length is '2'; The value is '[02]'.

TIA,
Scott Heffron


Greg Carter Posted on 2004-12-02 18:20:06.0Z
Message-ID: <41AF5CD2.10509@workmail.com>
From: Greg Carter <greg.carter@workmail.com>
Reply-To: greg.carter@nospam-workmail.com
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: sybase.public.rep-agent
To: Scott Heffron <sheffron@nutracorp.com>
Subject: Re: Rep Agent will not resume to replicating mode.
References: <41811eec$1@forums-1-dub>
In-Reply-To: <41811eec$1@forums-1-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: gcarter-pc.sybase.com
X-Original-Trace: 2 Dec 2004 10:20:03 -0800, gcarter-pc.sybase.com
Lines: 51
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 2 Dec 2004 10:20:04 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 2 Dec 2004 10:20:06 -0800
X-Trace: forums-1-dub 1102011606 10.22.108.75 (2 Dec 2004 10:20:06 -0800)
X-Original-Trace: 2 Dec 2004 10:20:06 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:735
Article PK: 862375

Scott,

I think "rs_in0x0100006500000161" is an "internal" repdef. Anyway, you
apparently have a primary table with a column named "t_oabc" and it
seems to be declared as datatype binary(1) or something similar, while
the repdef has it declared as varchar(1) (I think the message says the
target length is 2 allowing 1 byte for the string termination
character). You may be able to find the "base" repdef for this internal
repdef using "select * from rs_objects where objid = 0x0100006500000161"
in the RSSD. From there, you can determine if the column is properly
declared in the repdef.

In the end, the repdef should declare column in essentially the same
fashion they are declared in the primary table or risk seeing messages
such as this.

--
Thanks,
G.Carter
Sybase Replication Server Engineering
mailto:greg.carter@workmail.com

Scott Heffron wrote:

>I am new to replication server and am encountering this error in the log.
>Any advise or recommendations would be greatly appreciated.
>
>Rep. Server 12.6
>Windows: 2000 Server
>
>I. 2004/10/28 09:51:39. Replication Agent for BAAN.OEI_TRANSFERS connected
>in language mode.
>E. 2004/10/28 09:51:47. ERROR #32058 REP AGENT(Baan.oei_transfers) -
>\nrm\nrm.c(3574)
> The value given for 'rs_in0x0100006500000161.t_oabc' cannot be translated
>from datatype 'binary' to the required datatype 'varchar'. Value length is
>'1'; Maximum target length is '2'; The value is '[02]'.
>E. 2004/10/28 09:51:47. ERROR #32058 REP AGENT(Baan.oei_transfers) -
>\nrm\nrm.c(3574)
> The value given for 'rs_in0x0100006500000161.t_oabc' cannot be translated
>from datatype 'binary' to the required datatype 'varchar'. Value length is
>'1'; Maximum target length is '2'; The value is '[02]'.
>
>TIA,
>Scott Heffron
>
>
>
>