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.

suggestion for improvement

2 posts in Replication Last posting was on 2007-04-13 21:24:24.0Z
Paul Man Posted on 2007-04-13 12:26:03.0Z
From: "Paul Man" <paulman@datasoft.ie>
Newsgroups: advantage.Replication
Subject: suggestion for improvement
Date: Fri, 13 Apr 2007 13:26:03 +0100
Lines: 10
Organization: DSoft
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 82.141.233.142
Message-ID: <461f7610@solutions.advantagedatabase.com>
X-Trace: 13 Apr 2007 06:22:40 -0700, 82.141.233.142
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!82.141.233.142
Xref: solutions.advantagedatabase.com Advantage.Replication:196
Article PK: 1134054

Can I suggest an area for improvment. In my replication scenario I am
regularly getting primary key violations. while in theory this should not
happen it can for various reasons. To help the issue it would be great if
ADS logged the primary key values being sent and what was on the other end.
At the moment it dumps out the SQL text which means I have to count through
the fields to clearly identify them and then remotely log into the other
site to do the same and examine the mis-match to determine the cause.


Mark Wilkins Posted on 2007-04-13 21:24:24.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: advantage.Replication
References: <461f7610@solutions.advantagedatabase.com>
Subject: Re: suggestion for improvement
Date: Fri, 13 Apr 2007 15:24:24 -0600
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 10.24.38.228
Message-ID: <461ff3f5@solutions.advantagedatabase.com>
X-Trace: 13 Apr 2007 15:19:49 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.Replication:197
Article PK: 1134055

I added this to investigate the possibility.

Mark Wilkins
Advantage R&D

"Paul Man" <paulman@datasoft.ie> wrote in message
news:461f7610@solutions.advantagedatabase.com...
> Can I suggest an area for improvment. In my replication scenario I am
> regularly getting primary key violations. while in theory this should not
> happen it can for various reasons. To help the issue it would be great if
> ADS logged the primary key values being sent and what was on the other
> end. At the moment it dumps out the SQL text which means I have to count
> through the fields to clearly identify them and then remotely log into the
> other site to do the same and examine the mis-match to determine the
> cause.
>
>
>