Re: SQL Error .. help

Dale E. Reed Jr. ( (no email) )
Sun, 15 Jun 1997 16:06:26 -0700

Michael Miller wrote:
> Is there anyone who can tell me what this error means and how to correct
> it? It seems to really be a problem and sometimes even causes *extreme*
> counting delays in excess of 100,000 seconds.
> SQL Statement: INSERT INTO Calls (CallDate,UserName,NASIdentifier,NAS
> Port,AcctStatusType,AcctDelayTime,AcctSessionId,AcctSessionTime,AcctIn
> putOctets,AcctOutputOctets,FramedProtocol,FramedAddress) VALUES (GetDa
> te(),'dgass','',20203,2,5,'235018032',171,4660,7251,1,'
> ODBC: SQLExecDirect Error:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY K
> EY constraint 'pk_Calls': Attempt to insert duplicate key in object 'Calls'.
> Sending Accounting Ack of id 1 to ce9bc7d7 (MAX4002)
> Response Time: 401

Most likely you need to check the Require Secret in the RadiusNT
admin. On an Ascend box if you do not have that enabled, it
will keep resending Accounting packets, and RadiusNT will report the
above error for all additional copies of accounting packets it already

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |