[RadiusNT] pk_calls and ODBC errors.

Eric ( ejensen@accnorwalk.com )
Tue, 17 Oct 2000 14:51:00 -0400

--=====================_273615==_
Content-Type: text/plain; charset="us-ascii" format=flowed

hello all,
I know this topic has been talked of many times before, but I have tried
everything I could think of and still cannot fix the problem. We are
getting too many entries in our logfile with the following error:
>Tue Oct 17 12:19:03 2000: ODBC Error:23000:2627:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
> constraint 'PK_Calls'. Cannot insert duplicate key in object 'Calls'.

In a matter of 20 minutes there are over 70 of these errors in the logfile.
We are running RadiusNT 2.5.267 on NT.0 as a service. The box is an HP LH2
266mhz with 128mb ram. We are running SQL 7.0 on the same box.
We have 16 terminal servers (almost all are PM3's).

Here is what I have tried, what I remember anyways ;o) ...
-Cleared out the calls table completely.
-checked to make sure the following order of pk_calls index:
AcctSessionID
NasIdentifier
NasPort
UserName
AcctStatusType
-Also tried several combinations of the above mentioned index properties
(i.e. removed AcctStatusType or NasPort, etc.)
-I checked to make sure all terminal servers have the secret set and is set
same in Emerald/RadiusNT
-Check and bumped up memory for SQL.
-Checked "Manual calls update" in RadAdmin.
-Ran CheckDB on Emerald.
-probably a couple other things I can't remember at the moment.

Attached is a 20 minute cut of our logfile, and a copy of radius -x15 debug
output.

Does anyone have any more ideas or suggestions?
I need to get this fixed, it's causing too many problems.

Thanks,
Eric Jensen

--=====================_273615==_
Content-Type: application/zip; name="radprob101700.ZIP"
x-mac-type="705A4950" x-mac-creator="705A4950"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="radprob101700.ZIP"

UEsDBBQAAgAIAGtkUSlCYVqNgwEAAIw2AAARAAAAbG9nZmlsZTEwMTcwMC50eHTt2U9rwjAUAPC7
4Hd4N28j/9pqbpt6GCo6lYGISFfryCyNpHGwb786NnfZZVBo+3inlkcK+ZG8JH1ZX1KYJx54BFxo
PtBMgmCMaZiPHoYwds46LeQ1IkIR6W4HtjOTOFvYo99tvxqtnqawSt176mDkTPnYbX9Du2djs9gb
m4M9wmL5OLtfbmAy3kBi88K72OQeeovJfhhnWdG7g2Gc59aDyYvUeThczplJYp/CKf0og2Bf3tKy
v73v5t1Ot7NGaQjIQAYykKFhhpAMZKjAIFj79+mrQSEwDOownE/7ZXyY2td/KG4f/OngEokDyXgI
gcHBtejjcCgkjoC1fc0lQ2MMAYackLp8aflYhAjOgzgMMiQDGaow9HXQ9nyQCP5TydAcgyIDGciA
x8ARrEs4DCjqf6VDYKj/SVlTblftUAhygwzNMIRkaIihnjuWag2CkaF+Q6QZR2CQZCADGX4MAoFB
RhjO330tMDgU00y0fE4pBDVYLAZFBjKQ4WYIyEAGMrTY8AlQSwMEFAACAAgAjmhRKU5BZZF+FQAA
bb4AABIAAAByYWRkZWJ1Zy1zaG9ydC50eHTtXe1T20jS//ykKv/DXL4YboV3XvVCHfsU2GSPXSAs
kN3nbrXPlrBF8GFsVrKT5er++OsZvVuyEbKkBGKqUrFmRtK8dP+mu6e79foV3kaHk4H3cD87c3z/
09Qb+rsIv35FttHRh8nUc3uO7+4i9voV3Ubn7h/7g8Fsfz67UY3YNjqZDqGavn7Ft9G7+9loOoH7
df31K7GN+u7V/MMuMl6/0qGyf9DrOzPHn869Adxy7gxHc//08vUrA1pCRX/kuYPZ1HvYRYNd21PV
9utX5jaS7yysdaACmljb6L3vev7b0RgerH7CAHBQOnHuoDC4AUphXNFAd9Ff1R+Uwth607t7Z/Jw
qppDEYzteDRwJ35wCcO79EZ3QTXMBoHx7Y/H008nzvh66t258DgCxTDSM2/650MwiTC04+mHoF9w
GY4lXWQFRYuzA9ONg5pkDFBGgrJkBFAGfT862x8OPdeHqYc+QRl0/uL05Ex1gsquu/5MPv4KFvPC
HfjqRjkCWMmzqTeDvutcQJkeviAqg4V8/erM8Zy73WA50bH70R1DHbQ+moxmI2c8+vdo8gH9Mpr4
08Ftt9t9/UqOBqWH04lWu6PqT5xbeYtq1ptOJrCyQDhB1QW6+OkYXbjeR9dT1AX06VyN3WFjjw2X
eYhODs5hZgTGWI46uGHmzNw7dwKzceGO4YFIUoAmqXd/NvNGV/OZe9TX0OXDfVD6szsZTj1ZFF/I
OoTeetO7zG0+Qu+8IfTm4CF3Y+rZqH940ZP9Wdojz+kGnfI+Jj9+dsbz4Ffm2elr1a+oW6q9D/Xa
Qic9B6FfblzPDe9Nd21PvnuhDDmT4cJr43ZxQa6R6ku2mSqKZ6h4IEXzhFB/pBbekWCBglvkuiKU
DGuXcgZ1atBAzKaBVkxwQDVawmYaFA08dxbMXlDtqwcQC/XGI7jZB8Z3hpK8ECWSp6bzyUxSZ286
nt9NkmpoIH/KqrlELkWuCrl2A3BKfqtLGjRDY3X/X9QDDicz17v3Rr6Lrl1nNoc+Ijcg765sELEJ
ol3RpYShrcM713PGQznYydDxhoAhETPDPd1uQHCAmoC6H3cl8MNEzdC1HO/NFH4NroUxHGIdDYCX
9oiGRsM9nWto7E4+zG72LI7kn+z6jqRJWNs3sJvcOW/kAqEYg2W5zTj5j810bFNBbUz56XR7z2ZC
tymmP9iMYijUbYy5TQ0WPuB0/2LnaAgTPboeAYXsIYqNrml0KSVdPWkigQwqJbali3ZCetv3HyaD
oEp1VS4loAHUvAXIc4c7sjSoDwsA3GfTwXQMTc7OzoKqEGt2jibXUzkgbgKEoOP9s5Nvf+b04Oji
jZrK3x1AW9njARDY7xKltrbRUqIDnHP7o+vrrZPRBChWQ9+7EsLdrW1N1QEpbvWdBw1t3Tndwz9n
AGFA89/AxTugxv7c/YZAyzvn8M972DrlHdvhnaWe6qcfSuR19kFQHxK15MbkKgBCuI5WWF3Ajjea
qF8XN+54nJQdj+5GM9nN7oEzdiYDV/2WI1A1AYOdOD7Qd/gCHxoA/82v4ms/RqjoqXsdRWsd4PjT
vnxgb+7PpkDyR/09P32lcEh1fjb66P7tO6wK7lIFxcgLDAUTB+t+PfrgI2pZbFW7/cuoZQdopiMb
XgAqSZbfH9yi6TUwD9I5mk0Tttq6v+M7IN9sozWI89z179HlSAoPhon+BwWCG/kWo53vEEFqqwcZ
4VsclOBHeH5I6PCaYx7wPFc8T2jC9MSyVG/lY6G3vqQdYFLJEuwtxvrBW/wmxWwRLvgw53P/9uHG
dcazm+X8bXU5oBfnXZ7jb0of5e+gU7A0cz+qvZhN79OVYY/lhKkXYpKq3Y+YF6rO9/tH7y+WML9g
jC0wf/yQo8n9fLbzbjBzgW73EOEWoyxV/24+yzTQTWLyxbH1T48u5Jt0aghOePj8njMew6QG082J
pVMidGGm337penejCRDnTs+BTQQaqnUIFzpoeHyYatZ3Z85IUtMb2TCmiB1JXUg2k0Vv1sbPsCrc
XLNrDTJoagR9d+w8xAtEgOC4VcR3R6cXh+eX8N/lOzUxPtqS/0nw0uSDwqUG6JIdVEITTG9Cb/JK
znX0v0I1daMioOQyeI7skBYSgqQDVafWOlhJdR2sbVgQPlcupRasHPRFtoonXy2R6l44qVowTdEE
hpeRRKJ0JDk7si/b6Of94/eHF2grgfdOxIIdrZPlOChIM1dHo1TDGtUkA2idHD13tIBstYA4tU5I
h/CYhOygETyBZJ4MSwnPDhZtuxgv35/19y8PEaDWBUhX/n030n72cn2GyuyC7FFN3hGt815qZ5N/
UJWZsb1c11C0EHuZgaAMwewl85iR/pASCuVPua6+HAL65e+H53Iw3aBCCcJ+ciH3Jr8bC5V72VUI
tqb7rnzcHqUo2Mu2ok0aBNDpBDZXvENTm/g2+m4PRTOA3p2j8C8uAuQ4fX98vJ3dg2LhNNmOANfl
fhRD/hbM/879HdnO7CowRUu3FRJtK+RJomSwregi2VUIXrqrWBgLdli4q6SlzdqFxcLNxPFmVfYL
Hf4K9otG8JSB9C+W4Sn+XEiaRs46AS+kDgCmQByUaJSse0fjAnBOQtziEnQWsEtNW0fDT0et8MV5
sCJVwSrsSwJWkp/zIBWNvQGQSk1hBqS4WA5SpBGQ0kWxzJzFKI6XYhSNMIo+JvpiOnApZml1l+MU
RtG8vjuYun6RukuJ1Gx1+EGFTXX5j9mY8IFhM4NCKbcZAWWYka1/7y5HMLML+wSlepflEIzgVtVd
Hqu7p+9OD98sEVc5Z8TgbIm4yrlBqUE3mnLbmrKk0rYUZYJNvLaiDOwsBZOIIbeAJa6VZFKTppyg
BQ2x4cloESLSdRotKLcS6xgrsI49FKLFlo0Z/ifgBbGZLv5iUwHIwDkUiD4gCUAGo1DD1D9qqIoS
Ug8ReR3aaBU0CtTkDee3ayN7aI/zTZPztTkfWCi131/L/Z6QhoxkLOB0tibv85D3zURUEHyZOoP7
ILTxQ6tInRlOr1yvGmNb9dvGCGW4iq7D84bxZbYxqlNrhWXMwJnqvGnraDh2VXen89WmLdkQhQ0b
1L2E6HJjqSmLmhYxzWdpymrWahXxBChvigWySpzUhCxlrJIUCZrcIoGBJgd0pElq0XhWq1MLIo1d
auqfrtqF3anPDhV26BHNLp6QJjU7mNeMame1bX4CxFwC9UvtT4uIzSLEZk/S7QLE5iQBbGouA2xC
MDEPem+LADul/dWuvNVpfqpXeasfPeOZ0r9sw1WhRb9GIIxoDQBQqWwSyBIq6mgEh8as7IJKq3yw
doF9Plyq2MKVmt5KBq6gL3XYtzI9ydri404vgmE8KQ2AYWpyM1iozNGtmrk4WaLxLti5yFIs5BEW
8irSq0gZurC1Wnp9e1BojH9YBYZraqV1ouGSw9uGBMKMEP2ibfERcUhb/EOIXhkpjhohfOWPGxel
NoarmeIf6kKqTE9KiWsw8DbFNWq0DVGAEaXktRUYJSKMEuUwykxb1whNBDZL5K1r/r0zcG8LrfE6
thllNmW6zXRiY2rYDAubCnL+yYZJtpmgUGtIyxr8D7+FtLqREnhm5uCsVT80apobP7TPa2ML6K4t
KxujdH37OrBSipVNycqiTiMbETEE8FAoWRMCIk80mjqPI8vElJ48GeWGWeiJlkaJuhm7RjGliLEb
ElOIRSMXiZcvpUS0IV2kAsbNyClQHnoM5BYgK6WoSaskpESvrU1MCbvyiJQSD7xJKcXMCimtewsA
QBQD2wI8GUvxSY/wSS+HT4O0iCLYSu/4G8fzRr5eJKJgecTH9KPg8I8R/1Q5CChJxTD++qNNlbuA
9CpgZVyeCM0bndo9/EscbkKj00YsaVUsCYmtNQd5bIm15RLBUtw7kNxr1imWJMf+IpRB1uT6QCoR
vIwjI6GAvzouPPnLAkP9fN2ML2PKmNyQVEIs/rXIJRF5gDgScW7WgEI7GjFyzoyB/XdRMIF5qySa
xG+uVTZRvXlEOomH36gNhS6YeVu3oQheDHBLT7wWgcqIgMqoFMiTcrk2Vwfy9HCh+jT2r64rhe9w
Vr+Lgq7X6IxdGLwjsGWsjN1hhFcM3dGxaeBnH7rD2BcH0M8yaAfYDfBeclcuVIcz5f2g64Ve7IpE
NUWIuTAdRWKFYTqMVdofgv7VG5Yju7IYlhN2vDAsR85Ui2E5Moa87bAcUSosx1i6SZjRJmFWCcvR
kz1CN1eH5RS7RVy5g9tKUTl6A15sopIXG9V5aS82YTFGV2wSlFNqsGcN9DIgxXhZQN8wpofsAUgs
uSEXlqQHDm1COrTlaK2jKZLSAsLJwbdajErwHXSlRvgOu1IqUKkZD45lgUp626gN+3KJOCWDLgVt
KwJtqxxoX2X8N6iRoLbBltogTFgJYRbaIK5H/o3rfXIeylghSN4KIZoAb6MCdhNeHrtNyvkK6Cbc
tKxnjNxK+2bWBrmfYIcJWQQgO+aIBUsMkVJ3COAG3MFz+C3JSlPEs4De4YJUQu9Ud2qD8Lg/j5ln
ollp1DxDFswzonWXZGqkUPxKorix2sNlEcVJnGmF4CoRZCLl42LkT5CO54PbB8pEsZcLsRnR//mD
jamwMTP+Tzm9MIxlEBmUYiI9XnQb7rcpJ9Wc9dr1bikQwzfHSK0eI0UU19Y5kiWEtX4UmSDNRpEl
J0l6eG60NgBEjrhpDxf2iCNur0iQW8CI2vm7TieXJWp2U7644ivzxe2B5BIzcM4fN3J0yeufOXfc
aoEDyavrdckVZV1ye6265Ir2PXJpKY/clNaZg6skhU/JHD4sK6+IlT65t1fOMI5pTUsr0hnXuAB5
xVBZIRkRNmNMSS7UYA8nNuMGSDT8JxkBXyYhJNsEu3/tokpAbK2FuzPDrEFQSae3YYqDm5FTjPDY
eG3GD4+SS/nhHmDMRb8wd1cGGWpn7GcaL8RZ1/hqHHFD4gC5JGTcjIDCyscLyVmrJJ9E7601ddfj
9vB45E0KJ6yFcKEniwt4ZXqc0UdnUiAqzO3/lym0bmyGuY0ZAckBg+SgS1GBkv+VebZ2jEpAYrZq
yyD6xpbxeQUESWCt+cOaZG3pADcqG8g430g6MEN/gQLpgD7mrlDcycyrKOPLX0XTr9oIIl+8IEIs
zEB524gjK8WRcJbUPqm+VnLoeVNvF/YujHepTo1dmL5fT0YDb+pPr2e//aoapT5g0vcAbLzffk2K
fvt5NB078rMXkvXOzo9O9s//gX48/Afww8Sfec5oMgM4+fF3NfWdLizBZDKdodEEpmmGhvP7sdpl
0K37AIVoevUvuad0wuaPOyaV4HRGVjM6UYzOKjA6LZOgIFxFUsToKfGibjGhTpNogZjQIJd/PekJ
ItIAvlZywCJ7m6E1dHH+89xdMTlB8NZadY0SyQniYbeobJitG0JLIFPaCpqDJhZDE6+g1rCVZ7aD
yZUzucVkSWaCP5jNqLR1ku9HWOo3tzYV7BQKiTKLUk60atIJaVO9ETjvVr9Rb9pN8xsSWmsWUAvT
8joOOpj7owkgxxJlhzWr7CQhNVboZled+RfSkqSsGnqe/aFPN3fXH4o/imVEvL/3wx82wxR+6n8c
BYl+mUxUAuDA6U92pXwFxNwAwFcFACGptZbqm1HjCfx/evwYBAArNZqWJKWckNhJozoMZIOAU6F1
Bl0ZBCze8iL95BPoaePpJ1IxCriJFMAW4Q0HT4Auh02x6vtYjGBDPHMfXPoFqllfsg9uyCWgo0VM
URAMHSYFtmTgW4EPS0hZmqKfAjdcWlGNS3pUqxcuLaHLxfPSapB064mBM2fiS4OkU+pcAZjzGMxF
BVsTL+ODF2rWtDAzcFbnq11xq9HgVCS3NWhw0r8yexOVyXwjxSxnUiaB0Sm3BnmjU7VcU8mba7U7
6WXNTrTVM27SetbeMnanVKBuAVCJGKj0SgnxWO4DVcsT4hXGfWX109o1zOeJVHJHtr6ylHgy5CnS
IBdz4hGzFFCpaasEVPGLa808Y5XNime1mRWPmO2nxWMl0uJRJlYhlR4jlVEOqaxsYENKqDKWZsnq
4+UZxuVCTsr4Alu1AdUq7ZgTvca8noXRqTAZqz6QIxim2HzmurGpb1Tj8lgd8QcgdMAOWai2Qqim
GlBnYQ5TRVNaQDkFWrFZTc6M+lKrSmw+LmbG09EkfFvl4buhsNRM2jBLwrf+ZEHTiOHbrJRgIP15
M311ggGjMC5t4Iw/Ol7F9AINZA8jsO03DOCUYLEqf5hBrUyGwy/+E2dBvLjYIPZTEwoYMhQv5IB8
OoEgw5ckyOK805KMNEUsC184C9ejmm0g6k3N2QREyWwCRq/VbAKs/WQCZplkAqlkjwWobcaobVU5
lEpyeRnWI4lp9wtF7iFwxRMOpJ6o7R9PgQgLwWpfvngknRrlgWSIfPKUM9Xm0h1P3Fm67u9yIjId
oy0fvCzgUhpHSueA3ZfCnRx/waGHzBylSO9oMpje3Y9doEgnoT4gjqk37AZ9fzcZjyYuki6g8/sh
vGOIHrO862Us73SlmmhFFEtxFYo1SokZwUQZa5reC45RWQNpjJSzdG3WrkI5AzN9lZxBMdeN1Yqi
YjjQFH13tZyh2iHVruEzU8w2YsaT80cbS48bJHywIG0REGSxKU+SkRYQCwBN7sQUs9oPIdY5McWs
bFppo9UTU9Z63iJhlMFtvsr9heIYt8kGtze43QRuy+8w0yDcfIPenwW9wxV4SVFJ5bBPPAZ9VEEf
rQJ9iWXMFJ9NyVoFZPhrVb8WOb5udYwCQzarkJlliJvgVdRNYupmG+puiboDnKUvh8bDAb2ojcNc
e+OQrMUUa/ENa7XEWlwYJg+g7GWwVjigr4+19MdYiyvWEpW8TUQJy3d4evx2Hd6yNobv9Q3f0UIU
s4qVtnuXIQWeCc41VyYdOnA//lIYm6dzFYaHGVMZCrH8OrgMxxNE5iX85sxmsoToV3+zGWanJUil
4KNY7aYo5HiTgejzRuhJamstPM8SotbwPJZGdS5RnTYUoivTDwWpCQv2A70hXSubi3Gpl00qa1JB
N2m6m0/etnAZI2oAlj2yZu7nvJNktGXUaUMVvNL3l7iJSzvZMCb0VfGDgunPy4JqbT7Y8WSPyB5Z
murakqZRZTmVxKh1crTV0SQJaZJQCuymllV77us1Dr0sq6RPZI+06RNJcdtHXrgMVqdjBPNYzWKs
NjZYvcHqmrFaWcww3SD2Z0HscPZfklGlFOLpjwGeUIBnVgA8UsJa2bRFZXPKVbuZ8lHbS+OHXGR9
tYvHlG1tKLu9Ey5MXwx9v8ANg6y9YUi20mUZiyxOvePD/dP3Z7C4MKB3358fXsBs0+0u/Mn6/wJQ
SwECFAAUAAIACABrZFEpQmFajYMBAACMNgAAEQAAAAAAAAABACAAtoEAAAAAbG9nZmlsZTEwMTcw
MC50eHRQSwECFAAUAAIACACOaFEpTkFlkX4VAABtvgAAEgAAAAAAAAABACAAtoGyAQAAcmFkZGVi
dWctc2hvcnQudHh0UEsFBgAAAAACAAIAfwAAAGAXAAAAAA==
--=====================_273615==_--