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.

Replication Error 5005

5 posts in Replication Last posting was on 2006-03-09 09:15:41.0Z
Benoit claeys Posted on 2006-03-08 18:01:44.0Z
Reply-To: "Benoit claeys" <benoit.claeys@brainstorming.be>
From: "Benoit claeys" <benoit.claeys@brainstorming.be>
Newsgroups: advantage.Replication
Subject: Replication Error 5005
Date: Wed, 8 Mar 2006 19:01:44 +0100
Lines: 31
Organization: Silicon Brain
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 213.177.73.42
Message-ID: <440f19e6@solutions.advantagedatabase.com>
X-Trace: 8 Mar 2006 10:52:38 -0700, 213.177.73.42
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!213.177.73.42
Xref: solutions.advantagedatabase.com Advantage.Replication:92
Article PK: 1133950

Testing replication on two dictionnaries on the same server

no replication occurs

many error in ADS_ERR.ADT table, allways sames serie of 4 messages

1) Err_class : 7600, Error code : 5005, Ads_source : REPLICATION.C,
Src_line : 1443,
File Name : Error 5005: The supplied buffer was insufficient for
the information returned. The data may have been truncated.
2) Err_class : 7600, Error code : 5005, Ads_source : REPLICATION.C,
Src_line : 2127
File Name : [QueueTable]
3) Err_class : 7600, Error code : 5005, Ads_source : REPLICATION.C,
Src_line : 2356
4) Err_class : 7600, Error code : 5005, Ads_source : LOGIN.C, Src_line :
970

my config :
ADS server V? 8.00.0.4

I need help
regards
Benoit CLAEYS


Joachim Duerr (ADS Support) Posted on 2006-03-09 07:57:07.0Z
From: "Joachim Duerr (ADS Support)" <jojo.duerr@gmx.de>
Subject: Re: Replication Error 5005
Newsgroups: Advantage.Replication
References: <440f19e6@solutions.advantagedatabase.com>
Organization: iAnywhere
User-Agent: XanaNews/1.17.6.5
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 195.2.185.25
Message-ID: <440fdfd3@solutions.advantagedatabase.com>
Date: 9 Mar 2006 00:57:07 -0700
X-Trace: 9 Mar 2006 00:57:07 -0700, 195.2.185.25
Lines: 24
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!195.2.185.25
Xref: solutions.advantagedatabase.com Advantage.Replication:93
Article PK: 1133951


Benoit claeys wrote in <440f19e6@solutions.advantagedatabase.com>:

> Testing replication on two dictionnaries on the same server
>
> no replication occurs
>
> many error in ADS_ERR.ADT table, allways sames serie of 4 messages
>
> 1) Err_class : 7600, Error code : 5005, Ads_source : REPLICATION.C,
> Src_line : 1443, File Name : Error 5005: The supplied buffer
> was insufficient for the information returned. The data may have
> been truncated. 2) Err_class : 7600, Error code : 5005, Ads_source :
> REPLICATION.C, Src_line : 2127 File Name : [QueueTable] 3)
> Err_class : 7600, Error code : 5005, Ads_source : REPLICATION.C,
> Src_line : 2356 4) Err_class : 7600, Error code : 5005, Ads_source :
> LOGIN.C, Src_line : 970

Do your dictionaries have the exact same structure, at least the tables?

--
Joachim Duerr
Senior Product Support Analyst (Advantage Database Server)
iAnywhere Solutions / Extended Systems
advantage[AT]extendsys.de


Benoit claeys Posted on 2006-03-09 08:53:20.0Z
Reply-To: "Benoit claeys" <benoit.claeys@brainstorming.be>
From: "Benoit claeys" <benoit.claeys@brainstorming.be>
Newsgroups: Advantage.Replication
References: <440f19e6@solutions.advantagedatabase.com> <440fdfd3@solutions.advantagedatabase.com>
Subject: Re: Replication Error 5005
Date: Thu, 9 Mar 2006 09:53:20 +0100
Lines: 72
Organization: Silicon Brain
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 213.177.74.243
Message-ID: <440feae2@solutions.advantagedatabase.com>
X-Trace: 9 Mar 2006 01:44:18 -0700, 213.177.74.243
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!213.177.74.243
Xref: solutions.advantagedatabase.com Advantage.Replication:94
Article PK: 1133952

Yes, I start my configuration with two identical databases (structure and
content)
- I create two dictionnaries after copying twice the same list of
tables.
- For optimisation purpose, primary index name have been specified in
table property automaticaly (with a selft made small utility which detect
the first unique index)
- I proceed the configuration as specified in 'advantage.hlp' file. No
error occurs.
Dico A with full table publication based on primary key
Status success for all tables. (467 tables)
Dico B with full table publication based on primary key
Status success for all tables. (467 tables)
Dico A with Subscription on dico B
ADSSYS user name and password specified
Queue table Named 'ToDicB' without specific path
(table visible in table with name '__ToDicB')
Target connection type : Remote server
Using defalut config : (no check box checked for
: Ignore replication failure, log data, Forward replication)
Dico B with Subscription on dico A
ADSSYS user name and password specified
Queue table Named 'ToDicA' without specific path
(table visible in table with name '__ToDicA')
Target connection type : Remote server
Using defalut config : (no check box checked for
: Ignore replication failure, log data, Forward replication)

- For testing purpose, record content was modifed only in one table (DicA
and DicB) with Data architect 8.0.
Tested :
- Field modification
- Record delete
- Record insert
- In one Dico
- On Both Dico
Errors described before occur on each test.

Problems seems to be internal

Best regards
Benoit CLAEYS


"Joachim Duerr (ADS Support)" <jojo.duerr@gmx.de> a ?crit dans le message de
news: 440fdfd3@solutions.advantagedatabase.com...

> Benoit claeys wrote in <440f19e6@solutions.advantagedatabase.com>:
>
>> Testing replication on two dictionnaries on the same server
>>
>> no replication occurs
>>
>> many error in ADS_ERR.ADT table, allways sames serie of 4 messages
>>
>> 1) Err_class : 7600, Error code : 5005, Ads_source : REPLICATION.C,
>> Src_line : 1443, File Name : Error 5005: The supplied buffer
>> was insufficient for the information returned. The data may have
>> been truncated. 2) Err_class : 7600, Error code : 5005, Ads_source :
>> REPLICATION.C, Src_line : 2127 File Name : [QueueTable] 3)
>> Err_class : 7600, Error code : 5005, Ads_source : REPLICATION.C,
>> Src_line : 2356 4) Err_class : 7600, Error code : 5005, Ads_source :
>> LOGIN.C, Src_line : 970
>
> Do your dictionaries have the exact same structure, at least the tables?
>
> --
> Joachim Duerr
> Senior Product Support Analyst (Advantage Database Server)
> iAnywhere Solutions / Extended Systems
> advantage[AT]extendsys.de


Joachim Duerr (ADS Support) Posted on 2006-03-09 08:53:53.0Z
From: "Joachim Duerr (ADS Support)" <jojo.duerr@gmx.de>
Subject: Re: Replication Error 5005
Newsgroups: Advantage.Replication
References: <440f19e6@solutions.advantagedatabase.com> <440fdfd3@solutions.advantagedatabase.com> <440feae2@solutions.advantagedatabase.com>
Organization: iAnywhere
User-Agent: XanaNews/1.17.6.5
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 195.2.185.25
Message-ID: <440fed21@solutions.advantagedatabase.com>
Date: 9 Mar 2006 01:53:53 -0700
X-Trace: 9 Mar 2006 01:53:53 -0700, 195.2.185.25
Lines: 15
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!195.2.185.25
Xref: solutions.advantagedatabase.com Advantage.Replication:95
Article PK: 1133953


Benoit claeys wrote in <440feae2@solutions.advantagedatabase.com>:

> Yes, I start my configuration with two identical databases (structure
> and content) - I create two dictionnaries after copying twice the
> same list of tables.

could yopu please send me in both databases (including the tables)?
Advantage@extendsys.de
Don't forget a short description so that we can associate the files to
an issue.
--
Joachim Duerr
Senior Product Support Analyst (Advantage Database Server)
iAnywhere Solutions / Extended Systems
advantage[AT]extendsys.de


Benoit claeys Posted on 2006-03-09 09:15:41.0Z
Reply-To: "Benoit claeys" <benoit.claeys@brainstorming.be>
From: "Benoit claeys" <benoit.claeys@brainstorming.be>
Newsgroups: Advantage.Replication
References: <440f19e6@solutions.advantagedatabase.com> <440fdfd3@solutions.advantagedatabase.com>
Subject: Re: Replication Error 5005
Date: Thu, 9 Mar 2006 10:15:41 +0100
Lines: 36
Organization: Silicon Brain
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 213.177.74.243
Message-ID: <440ff01b@solutions.advantagedatabase.com>
X-Trace: 9 Mar 2006 02:06:35 -0700, 213.177.74.243
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!213.177.74.243
Xref: solutions.advantagedatabase.com Advantage.Replication:96
Article PK: 1133956

I reconfigure from zero my test
Replication works properly ! (tested on one table)
Why...? the difference is that I restart my computer....

Best Regards
Benoit CLAEYS


"Joachim Duerr (ADS Support)" <jojo.duerr@gmx.de> a ?crit dans le message de
news: 440fdfd3@solutions.advantagedatabase.com...

> Benoit claeys wrote in <440f19e6@solutions.advantagedatabase.com>:
>
>> Testing replication on two dictionnaries on the same server
>>
>> no replication occurs
>>
>> many error in ADS_ERR.ADT table, allways sames serie of 4 messages
>>
>> 1) Err_class : 7600, Error code : 5005, Ads_source : REPLICATION.C,
>> Src_line : 1443, File Name : Error 5005: The supplied buffer
>> was insufficient for the information returned. The data may have
>> been truncated. 2) Err_class : 7600, Error code : 5005, Ads_source :
>> REPLICATION.C, Src_line : 2127 File Name : [QueueTable] 3)
>> Err_class : 7600, Error code : 5005, Ads_source : REPLICATION.C,
>> Src_line : 2356 4) Err_class : 7600, Error code : 5005, Ads_source :
>> LOGIN.C, Src_line : 970
>
> Do your dictionaries have the exact same structure, at least the tables?
>
> --
> Joachim Duerr
> Senior Product Support Analyst (Advantage Database Server)
> iAnywhere Solutions / Extended Systems
> advantage[AT]extendsys.de