Re: [Emerald] Problem with Primary Key Constraint

Dale E. Reed Jr. ( (no email) )
Tue, 01 Dec 1998 14:09:46 -0800

Waldemar Born wrote:
> Hi there,
> after updating to Emerald 2.5 i receive in Radius -x15 this error:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
> con
> straint 'pk_Calls': Attempt to insert duplicate key in object 'Calls'.
> [INS
> ERT INTO Calls
> (CallDate,AcctStatusType,AcctSessionId,UserName,NASPort,NASI
> dentifier) VALUES('Dec 01 13:51:51
> 1998',1,'65538','PSGGATE',0,'RASSERV')]r
> adrecv: Request from host c0a80064 code=1, id=15, length=71
> radrecv: Request from host c0a80064 code=1, id=15, length=71
> Any hints what to do?

Wait and see if it goes away. It could have just been a backlog from
the upgrade. If you continue to see the error a lot, you'll probably
want to look at whats causing the accounting packet not to get

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