Message-ID: <003a01c07c2a$d2419d40$17f4b7ca@jad00> From: "sci" <sci.news@eudoramail.com> Subject: Re: [RadiusNT] RadiusNT and SQL Server Replication Date: Fri, 12 Jan 2001 05:01:21 +0500
RAD2.5/SQL6.5SP5/NT4.0SP6
i just tried the same for my calls table which already has 2.7M records.
but i'm still getting the duplicate key error.
my PK:
AcctSessionID
NASIdentifier
AcctStatusType
NASPort
CallDate
Brian, how are u going with this? did u got this error again?
- sci
----- Original Message -----
From: "Brian Dooley" <support@cserv.net>
To: "sci" <sci.news@eudoramail.com>
Sent: Friday, December 01, 2000 6:32 AM
Subject: RE: [RadiusNT] RadiusNT and SQL Server Replication
> That's the one!
>
> My PK in Calls is
> AcctSessionID
> NASIdentifier
> AcctStatusType
> NASPort
> CallDate
>
> CallDate is the one I included to correct the problem.
>
> Verbatim > -----Original Message-----
> Verbatim > From: sci [mailto:sci.news@eudoramail.com]
> Verbatim > Sent: Wednesday, November 29, 2000 10:23 PM
> Verbatim > To: Brian Dooley
> Verbatim > Subject: Re: [RadiusNT] RadiusNT and SQL Server Replication
> Verbatim >
> Verbatim >
> Verbatim > that must be happend to Call Table.
> Verbatim > i had the same problem w/ CISCO AS5300, was probably
> Verbatim > repeating session IDs.
> Verbatim > i did the same, altered the primary ket, but still,
> Verbatim > sometimes, i get the
> Verbatim > duplicate key Error.
> Verbatim >
> Verbatim > i was just thinking about to include CallDate field to
> Verbatim > Composite PK so that
> Verbatim > it may never repeat.
> Verbatim >
> Verbatim > can i ask u what fields do u have in Calls PK?
> Verbatim >
> Verbatim > - sci
> Verbatim >
> Verbatim > ----- Original Message -----
> Verbatim > From: "Brian Dooley" <support@cserv.net>
> Verbatim > To: <radiusnt@iea-software.com>
> Verbatim > Sent: Thursday, November 30, 2000 7:59 AM
> Verbatim > Subject: RE: [RadiusNT] RadiusNT and SQL Server Replication
> Verbatim >
> Verbatim >
> Verbatim > > I am not using multiple SQL servers, but did
> Verbatim > experience a problem with
> Verbatim > DUPE
> Verbatim > > index key violations.
> Verbatim > > Based on a previous post elsewhere herein, I altered
> Verbatim > the Primary key to
> Verbatim > > include something that would make it unique and not
> Verbatim > likely to be able to
> Verbatim > > duplicate as easily.
> Verbatim > >
> Verbatim > > Verbatim > -----Original Message-----
> Verbatim > > Verbatim > From: radiusnt-request@iea-software.com
> Verbatim > > Verbatim >
> [mailto:radiusnt-request@iea-software.com]On Behalf Of
> > Verbatim > Chris Stone
> > Verbatim > Sent: Wednesday, November 29, 2000 7:15 PM
> > Verbatim > To: 'radiusnt@iea-software.com'
> > Verbatim > Subject: [RadiusNT] RadiusNT and SQL Server Replication
> > Verbatim >
> > Verbatim >
> > Verbatim > Anyone have this setup and running - RadiusNT 3 and SQL
> > Verbatim > Server 7.0. Have 2
> > Verbatim > radius and 2 SQL servers - a pair of each at 2 separate
> > Verbatim > locations. Each
> > Verbatim > Radius server uses it's local SQL server for the primary
> database
> > Verbatim > connection. In setting up SQL merge replication, the
> > Verbatim > initial snapshot goes
> > Verbatim > fine and the replication will work quite nicely for a
> > Verbatim > few days and then we
> > Verbatim > start getting replication failures - primarily due to
> > Verbatim > violations of index
> > Verbatim > keys.
> > Verbatim >
> > Verbatim > Anyone have this type of configuration running
> > Verbatim > successfully that might be
> > Verbatim > able to provide a bit of insight into how to resolve
> > Verbatim > these issues?
> > Verbatim >
> > Verbatim > Chris Stone, MCSE
> > Verbatim > WebConnects, Inc.
> > Verbatim > email: cstone@wcox.com
> > Verbatim > web: http://www.wcox.com
> > Verbatim >
> > Verbatim >
> > Verbatim > ------------
> > Verbatim >
> > Verbatim > This is a user supported list. If you require assistance
> > Verbatim > from IEA Software's
> > Verbatim > Support Engineers, please check out our Support resources at
> > Verbatim > http://www.iea-software.com/support.
> > Verbatim >
> > Verbatim > For more information about this list (including removal) go
to:
> > Verbatim > http://www.iea-software.com/support/maillists/liststart
> >
> > ------------
> >
> > This is a user supported list. If you require assistance from IEA
> Software's
> > Support Engineers, please check out our Support resources at
> > http://www.iea-software.com/support.
> >
> > For more information about this list (including removal) go to:
> > http://www.iea-software.com/support/maillists/liststart
> >
>
>
>
.