RE: [Emerald] Problem with Primary Key Constraint

Robert H. Clugston ( (no email) )
Tue, 1 Dec 1998 14:17:26 -0800

Sounds like the user is showing up already connected to the Internet. Make
sure you clear out all the calls in the calls table using Emerald or some
script.
Also, make sure you are on Radius 2.5 and that you've updated your database
with the include scripts.

-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com] On Behalf Of Waldemar Born
Sent: Tuesday, December 01, 1998 12:55 PM
To: Emerald@Iea-Software. Com
Subject: [Emerald] Problem with Primary Key Constraint

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?

Waldemar Born