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.

Problem with data using replication

9 posts in Replication Last posting was on 2007-09-24 05:43:12.0Z
D.W. Huisman Posted on 2007-08-03 04:22:23.0Z
From: "D.W. Huisman" <dwhuisman@kliksafe.nl>
Newsgroups: advantage.Replication
Subject: Problem with data using replication
Date: Fri, 3 Aug 2007 06:22:23 +0200
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 213.239.187.199
Message-ID: <46b2ac5a@solutions.advantagedatabase.com>
X-Trace: 2 Aug 2007 22:17:30 -0700, 213.239.187.199
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!213.239.187.199
Xref: solutions.advantagedatabase.com Advantage.Replication:237
Article PK: 1134092

Hello,

Today I noticed the following:

Some fields of a replicated table on de Replication ADS (8.1.0.15) contains
buggy data.
For example a field on the Master table contains a barcode like
?871711234567890123?.
The same record on the replicaton server contains ?8,"711234567890123?.

How can this occur?

(after chaning the data on the master, de data in de replication table
became correct.)

Dirk-Willem Huisman


Peter Funk (ADS) Posted on 2007-08-03 19:31:30.0Z
Date: Fri, 3 Aug 2007 19:31:30 +0000 (UTC)
Message-ID: <864d0bcbe50e8c9a3e9bca280e5@devzone.advantagedatabase.com>
From: Peter Funk (ADS) <pfunk@nospam.com>
Subject: Re: Problem with data using replication
Newsgroups: Advantage.Replication
References: <46b2ac5a@solutions.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Pro 1098.1
NNTP-Posting-Host: 10.24.38.185
X-Trace: 3 Aug 2007 13:26:33 -0700, 10.24.38.185
Lines: 13
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.185
Xref: solutions.advantagedatabase.com Advantage.Replication:239
Article PK: 1134094

Hello D.W.,
I think the only way this can happen is if the table structure changed while
replication updates were in the subscription queue. This is something we're
working to fix BTW.

Is this something you can re-create? Does it happen regularly? If you can,
I'd be happy to look into it.

Regards,
Peter Funk
Advantage R&D


D.W. Huisman Posted on 2007-08-06 11:38:44.0Z
From: "D.W. Huisman" <dwhuisman@kliksafe.nl>
Newsgroups: Advantage.Replication
References: <46b2ac5a@solutions.advantagedatabase.com> <864d0bcbe50e8c9a3e9bca280e5@devzone.advantagedatabase.com>
Subject: Re: Problem with data using replication
Date: Mon, 6 Aug 2007 13:38:44 +0200
Lines: 17091
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: 80.127.200.202
Message-ID: <46b70736@solutions.advantagedatabase.com>
X-Trace: 6 Aug 2007 05:34:14 -0700, 80.127.200.202
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!80.127.200.202
Xref: solutions.advantagedatabase.com Advantage.Replication:240
Article PK: 1134099

Peter,

We did not made changes to any of the tables, so that cannot be the reason.
Friday I copy the entire database from the master to our replication server
and build up the replication by creating a new publication and subscription.
Today the replication stops again after working a few days normally.
In the ADS error table the following error is mentioned:

==============================================
Error 7200: AQE Error: State = 42000;
NativeError = 2115;
[Extended Systems][Advantage SQL Engine]Expected lexical element not found:
SET You are missing the keyword SET after the table name in the UPDATE
statement. -- Location of error in the SQL statement is: 23

EntryID=130329, Subscription=MASTERSUB, Table=ordset, Record=2546093,
SQL=UPDATE "ordset" SET "Opdrachtgever" = ?, "Batchcode" = ?,
"Verkoopkantoor" = ?, "Klantcode" = ?, "Aflevercode" = ?, "Vervoerder" = ?,
"Landcode" = ?, "Sortering" = ?, "Type" = ?, "BOrderVolgnummer" = ?,
"BSubVolgnummer" = ?, "SetNr" = ?, "PickingTicketID" = ?, "Aantal" = ?,
"TotaalSets" = ?, "TotaalAantal" = ?, "VervoerderCode" = ?, "HoldCode" = ?,
"KlantReferentie" = ?, "ExtVervoerNummer" = ?, "Status" = ?,
"VerzendScanDatum" = ?, "VerzendScanTijd" = ?, "ChaufRegNummer" = ?,
"GewichtKG" = ?, "SETID" = ?, "DoosType" = ?, "DistributieGroep" = ?,
"LandVolgorde" = ?, "Volgorde" = ?, "Divisie" = ?, "Seizoen" = ? WHERE
"SETID" = ?, Values=(1,HT71 ,1 ,GER06534S0002 ,1
,DHL Germany ,GERMA,NULL,D,1012,1,1,910045956
,6,1,6,DHLGER ,NULL,NULL,387172026227607240
,1,2007-08-06,10:25:32.000,16805,NULL,3472774,0,GERGEY ,00,0,NULL,NULL),
IdentValues=(3472774)
==============================================

I?ve attached the ADS error tables.

Regards,
Dirk-Willem Huisman
DNA Services B.V.

"Peter Funk (ADS)" <pfunk@nospam.com> schreef in bericht
news:864d0bcbe50e8c9a3e9bca280e5@devzone.advantagedatabase.com...

> Hello D.W.,
> I think the only way this can happen is if the table structure changed
> while
> replication updates were in the subscription queue. This is something
> we're
> working to fix BTW.
>
> Is this something you can re-create? Does it happen regularly? If you
> can,
> I'd be happy to look into it.
>
> Regards,
> Peter Funk
> Advantage R&D
>
>