Re: [RadiusNT] Fw: ODBC ERROR

rdudek ( (no email) )
Sun, 20 Jun 1999 13:06:24 -0400

how can I do this?
-----Original Message-----
From: Dale E. Reed Jr. <>
To: <>
Date: Saturday, June 19, 1999 2:09 PM
Subject: Re: [RadiusNT] Fw: ODBC ERROR

>> rdudek wrote:
>> I have a problem with Emerald on SQL 7.0 it does not clear
>> the on line users with the following error.
>> SQL Statement: INSERT INTO Calls
>> ODBC Error:23000:2627:
>> *[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY
>> KEY constra
>> int 'pk_Calls'. Cannot insert duplicate key in object 'Calls'.
>> Sending Accounting Ack of id 118 to d1700f03 (
>> Resp Time: 20 Auth: 33/0 -> 33 Acct: 47/0/12 -> 59
>This really isn't an SQL 7 issue, its a more generic problem that
>occurs with all falvors of databases used with RadiusNT. The problem
>is that RadisuNT has already received this accounting packet, and it
>will only store each accounting packet once. Now if this is not
>a duplicate accounting record, then you may need to look at why it
>matches another record. I know that some USR models are notorious
>for re-using the AcctSessionID for different sessions, which can
>cause this problem as well.
>One thing you might be able to do is add the username into the
>primary key to give a larger key to try and cut down on the
>Dale E. Reed Jr. Emerald and RadiusNT
>IEA Software, Inc.