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 stops with 7057 Error.

3 posts in Replication Last posting was on 2010-10-08 07:41:37.0Z
Kiron Joseph Posted on 2010-10-06 11:23:23.0Z
From: Kiron Joseph <kiron@datadevices.com>
Newsgroups: Advantage.Replication
Subject: Replication stops with 7057 Error.
Date: Wed, 06 Oct 2010 16:53:23 +0530
Organization: Data Devices Pvt. Ltd.
Reply-To: kiron@datadevices.com
Message-ID: <olmoa69ipg53ll71jdj6ct7op1s7r8atbs@4ax.com>
X-Newsreader: Forte Agent 3.2/32.830
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 122.172.118.49
X-Trace: 6 Oct 2010 05:20:02 -0700, 122.172.118.49
Lines: 53
Path: solutions.advantagedatabase.com!122.172.118.49
Xref: solutions.advantagedatabase.com Advantage.Replication:427
Article PK: 1134280

Dear All,

We have a client who has 10 Branches and the Corporate Office.

Presently all these locations are using Windows 2008 servers and
client are Windows XP or Windows 7 workstations

We have implemented one way ADS-Replication from their Branches to the
Corporate Office.

Now the problem is replication stops sometimes

When we check the ADS_ERR.ADT we can find ?7057 error?

Error 7200: AQE Error: State = HY000; NativeError = 7057;
[iAnywhere Solutions][Advantage SQL][ASA] Error 7057: The record
update failed. The key value produced from this record was not
unique, and an index for the current table has the UNIQUE property.
The key value supplied for RIGHTSY0:UUID is not unique.

This error is raised only by the Replication Process. Our applications
never raised this error.

And when checking the Queue Tables, we have found out the following

The record which is pending in the Queue Table for Replication already
exists in the Target Table. But the pending record?s ?UpdateType? in
the Queue Table shows as ?I?

The UUID field is the Primary Key. Its default value set as
NewIDString("D"). And we are not updating this field. Means the value
for UUID is generated by ADS only.

At the Corporate Office is ADS 9.10.0.9 (32 bit) running on Windows
2008 Server (64 bit) Standard Edition. The Corporate Office has a
Static IP and the replication is done to that IP.

All the Branches has (ADS 9.10.0.9 (32 Bit) running on Windows 2008
Server (64 Bit) Standard Edition

The Replication from one Branch is over the LAN since it is in the
same premises as the Corporate Office. The Replication from 2 Branches
are over the Leased Line with static IPs. The Replication from other 6
branches are over Broadband through the VPN named LogMeIn Hamachi from
www.hamachi.cc .

Anybody experienced this before ?

What could be the reason ?


Regards
Kiron


Kiron Joseph Posted on 2010-10-08 07:13:07.0Z
From: Kiron Joseph <kiron@datadevices.com>
Newsgroups: Advantage.Replication
Subject: Re: Replication stops with 7057 Error.
Date: Fri, 08 Oct 2010 12:43:07 +0530
Organization: Data Devices Pvt. Ltd.
Reply-To: kiron@datadevices.com
Message-ID: <p2hta6h474pk5q7o866hn02oka4q60uoil@4ax.com>
References: <olmoa69ipg53ll71jdj6ct7op1s7r8atbs@4ax.com>
X-Newsreader: Forte Agent 3.2/32.830
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 61.17.224.151
X-Trace: 8 Oct 2010 01:09:42 -0700, 61.17.224.151
Lines: 62
Path: solutions.advantagedatabase.com!61.17.224.151
Xref: solutions.advantagedatabase.com Advantage.Replication:430
Article PK: 1134282

No Answers ?

Shall we conclude it as bus with ADS ?

Regards
Kiron
On Wed, 06 Oct 2010 16:53:23 +0530, Kiron Joseph

<kiron@datadevices.com> wrote:

>Dear All,
>
>We have a client who has 10 Branches and the Corporate Office.
>
>Presently all these locations are using Windows 2008 servers and
>client are Windows XP or Windows 7 workstations
>
>We have implemented one way ADS-Replication from their Branches to the
>Corporate Office.
>
>Now the problem is replication stops sometimes
>
>When we check the ADS_ERR.ADT we can find ?7057 error?
>
>Error 7200: AQE Error: State = HY000; NativeError = 7057;
>[iAnywhere Solutions][Advantage SQL][ASA] Error 7057: The record
> update failed. The key value produced from this record was not
> unique, and an index for the current table has the UNIQUE property.
> The key value supplied for RIGHTSY0:UUID is not unique.
>
>This error is raised only by the Replication Process. Our applications
>never raised this error.
>
>And when checking the Queue Tables, we have found out the following
>
>The record which is pending in the Queue Table for Replication already
>exists in the Target Table. But the pending record?s ?UpdateType? in
>the Queue Table shows as ?I?
>
>The UUID field is the Primary Key. Its default value set as
>NewIDString("D"). And we are not updating this field. Means the value
>for UUID is generated by ADS only.
>
>At the Corporate Office is ADS 9.10.0.9 (32 bit) running on Windows
>2008 Server (64 bit) Standard Edition. The Corporate Office has a
>Static IP and the replication is done to that IP.
>
>All the Branches has (ADS 9.10.0.9 (32 Bit) running on Windows 2008
>Server (64 Bit) Standard Edition
>
>The Replication from one Branch is over the LAN since it is in the
>same premises as the Corporate Office. The Replication from 2 Branches
>are over the Leased Line with static IPs. The Replication from other 6
>branches are over Broadband through the VPN named LogMeIn Hamachi from
>www.hamachi.cc .
>
>Anybody experienced this before ?
>
>What could be the reason ?
>
>
>Regards
>Kiron


Joachim Duerr (ADS) Posted on 2010-10-08 07:41:37.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Replication stops with 7057 Error.
Newsgroups: Advantage.Replication
References: <olmoa69ipg53ll71jdj6ct7op1s7r8atbs@4ax.com> <p2hta6h474pk5q7o866hn02oka4q60uoil@4ax.com>
Date: Fri, 8 Oct 2010 09:41:37 +0200
User-Agent: XanaNews/1.19.1.269
X-Face: u2p+</,mb|Ah!x!/qxX5q0t:O~.<1&JzwNHYhSqcviY{~&|iDc"U.Je1A.ZeHR`d;;y#R
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 10.56.66.155
Message-ID: <4caeca48@solutions.advantagedatabase.com>
X-Trace: 8 Oct 2010 01:37:44 -0700, 10.56.66.155
Lines: 13
Path: solutions.advantagedatabase.com!10.56.66.155
Xref: solutions.advantagedatabase.com Advantage.Replication:431
Article PK: 1134283


Kiron Joseph wrote:

>No Answers ?
>
>Shall we conclude it as bus with ADS ?

as far as I know you've an issue open with support regarding exactly
the same issue.

--
Joachim Duerr
Advantage Presales
check out my new ADS book on http://www.jd-engineering.de/adsbuch