Its back again (SQL error 2627)

David Moore ( (no email) )
Sat, 17 Jan 1998 09:39:53 +1100

This is a multi-part message in MIME format.

------=_NextPart_000_0009_01BD232B.DD5939A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I Turned off the USR TC again and now the errors are back I can't get =
any calls on line and users are not having there on-line information =
logged so they can't be billed. I need to be able to turn off and on the =
USR from time to time and still be able to work normally without having =
to go through days of fiddling to try and get the USR to work, can any =
body suggest a solution.

SQL Statement: INSERT INTO Calls =
(CallDate,AcctSessionId,UserName,NASIdentifier
,NASPort,AcctStatusType,NASPortType,UserService,FramedProtocol,FramedAddr=
ess,Acc
tDelayTime) VALUES =
(GetDate(),'0001000B','test','xxx.xxx.xxx.xxx',2,1,0,2,1,'xxx.xxx.xxx.xxx=
',0)

ODBC: SQLExecDirect Error 2627:
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY =
constraint 'pk_Calls': Attempt to insert duplicate key in object =
'Calls'.Sending Accounting Ack of id 33 to cb230605 (ROMUSR)
Resp Time: 20 Auth: 1/0 -> 1 Acct: 0/0/2 -> 2

David Moore
moored@romtech.com.au

------=_NextPart_000_0009_01BD232B.DD5939A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">

I Turned off the USR TC again and =now the errors=20are back I can't get any calls on line and users are not having there =on-line=20information logged so they can't be billed. I need to be able to turn =off and on=20the USR from time to time and still be able to work normally without =having to=20go through days of fiddling to try and get the USR to work, can any body =suggest=20a solution.
 
 SQL Statement: INSERT INTO =Calls=20(CallDate,AcctSessionId,UserName,NASIdentifier
,NASPort,AcctStatusType=,NASPortType,UserService,FramedProtocol,FramedAddress,Acc
tDelayTime) =VALUES=20(GetDate(),'0001000B','test','xxx.xxx.xxx.xxx',2,1,0,2,1,'xxx.xxx.xxx.xxx=',0) 
 
ODBC: SQLExecDirect Error 2627:
=20[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY=20constraint 'pk_Calls': Attempt to insert duplicate key in object ='Calls'.Sending=20Accounting Ack of id 33 to cb230605 (ROMUSR) 
Resp Time: 20    =Auth: 1/0 ->=201  Acct: 0/0/2 -> 2
 
David Moore
moored@romtech.com.au
 
------=_NextPart_000_0009_01BD232B.DD5939A0--