Re: [RadiusNT] SQL Error (Violation of PRIMARY KEY)

Rudy Komsic ( (no email) )
Tue, 15 Dec 1998 15:47:48 -0500

Dale,

I still receive these too... I basically get about a 5% of PRIMARY KEY
Failures.

-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: radiusnt@iea-software.com <radiusnt@iea-software.com>
Date: December 15, 1998 5:33 AM
Subject: Re: [RadiusNT] SQL Error (Violation of PRIMARY KEY)

>"Kenneth D. Lenox" wrote:
>>
>> I think this error message may have been explained before, but I'm not
sure
>> when. Can someone tell me how to fix this
>>
>> Resp Time: 813 Auth: 2/0 -> 2 Acct: 0/5/0 -> 5
>> [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
>> const
>> nt 'pk_Calls': Attempt to insert duplicate key in object 'Calls'. [INSERT
>
>This means that RadiusNT has already seen this accounting record. If
>the
>problem continues, look at your accounting timeouts on your NAs and make
>sure it atleast 5. Otherwise, double-check your secrets and see if your
>NAS has a log as to why its not receiving the ack.
>
>Is the machine you are running RadiusNT on multi-homed?
>
>
>--
>Dale E. Reed Jr. (daler@iea-software.com)
>_________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com
>
>For more information about this list, including removal, please
>see this URL: http://www.iea-software.com/maillist.html

For more information about this list, including removal, please
see this URL: http://www.iea-software.com/maillist.html