Hmmm ok well I have the same problem then I think I will tell you how to fix it this afternoon.
I thought my problem was horsepower related. I will open a support call to microsoft and tell you an answer to your problems
Michael Saunders
-----Original Message-----
From: Michael Hobach [SMTP:mhobach@cyberlynk.net]
Sent: Thursday, 10 June 1999 11:07
To: radiusnt@iea-software.com
Subject: RE: [RadiusNT] SQL 7.0 problems...
Mike,
It's a brand new machine 450Mhz, 256Mb Ram, etc...
Horsepower is not an issue - the Access machine was a 200Mhz box.
The problem I am having is definitely SQL 7.0 related, and since we don't
have too much experience with the MS SQL server itself we are caught in a
learning curve. Also, I suspect that if we would have started with SQL 6.5
we wouldn't have to deal with some of the changes that Microsoft made to
7.0 - which is where I think the problem is. There are two of us here that
can program in SQL - it is just the 'physical' server things we are in need of
understanding...
Mike
----------------
Email from: Michael Saunders <radiusnt@iea-software.com>
On 10 Jun 99, at 22:13, Michael Saunders wrote
> SQL 7.0 is a great platform. The only problem is your machine will have to be upgraded as SQL is a lot more intensive than access
>
>
> Michael Saunders
>
> -----Original Message-----
> From: Michael Hobach [SMTP:mhobach@cyberlynk.net]
> Sent: Thursday, 10 June 1999 9:40
> To: radiusnt@iea-software.com
> Cc: Network Operation Center
> Subject: Re: [RadiusNT] SQL 7.0 problems...
>
> Dale,
>
> We checked the time-out in all of our TNT's/MAX's - we have a TNT and 5
> MAX 4000/6000 - they are all set to 10 seconds. We are still getting the
> "'pk_Calls'. Cannot insert duplicate key in object 'Calls'" error.
>
> Checked on triggers on the calls table - looked under the 'triggers' for the
> calls table and found nothing! Where should we find them, and what
> triggers should be there?
>
> We created an Index as suggested by Mike Miller in a post on 3/17/99 as
>
> CREATE INDEX index_AcctSessionId ON Calls(AcctSessionId)
>
> This was done earlier - we have had several 100% CPU incidences since!
>
> We have been using the Access DB version of RadiusNT since you first
> introduced it - we have had to do absolutely no maintenance on the system -
> since we introduced MS SQL we have had to spend a lot of time learning
> the internal problems and specifics of SQL - I'll be glad to get this to settle
> down again!!! I'm thinking that maybe MS SQL was not the best choice -
> maybe we should have considered ORACLE?
>
> Any thoughts?
>
>
> ----------------
> Email from: Dale E. Reed Jr. <radiusnt@iea-software.com>
>
> On 8 Jun 99, at 10:43, Dale E. Reed Jr. wrote
>
> > Michael Hobach wrote:
> > >
> > > Any thoughts on this previous post?
> > > This 100% thing is driving us crazy...
> >
> > > > First, with ODBC logging turned on, we keep getting errors logged like
> > > >
> > > > 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'.
> >
> > This just means RadiusNT already has the accounting record. Its normal,
> > but you shouldn't see it a lot. If you do, then check your timeouts and
> > the response times of RadiusNT.
> >
> > > > ODBC Error:37000:170:
> > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
> > > > near 's'.
> >
> > This is typically someone putting a ' in a username or such.
> >
> > > > Second, about once a week the SQL server goes to 100% processor
> > > > utilization. Stopping RadiusNT and Cold Fusion does nothing. It appears
> > > > that the RadLogs table may be the problem - deleting the RadLogs table
> > > > brings the server back down to realistic CPU utilization.
> >
> > Someone reported this a while back on SQL7. It has to do with the
> > trigger. There was a posted workaround for it, but I don't remember
> > the exact problem. I think it had to do with aliasing (or lack thereof)
> > the update table vs. using the table name. What does your trigger
> > on your calls table look like?
> >
> >
> > --
> >
> > Dale E. Reed Jr. Emerald and RadiusNT
> > __________________________________________
> > IEA Software, Inc. www.iea-software.com
>
>
> --------------------------------
> Michael Hobach <mhobach@cyberlynk.net>
> CyberLynk Network, Inc.
> 6214 Washington Ave Suite C16
> Racine, WI 53406
> (414) 884-1088 Fax (414) 884-1053
> http://www.cyberlynk.net
>
--------------------------------
Michael Hobach <mhobach@cyberlynk.net>
CyberLynk Network, Inc.
6214 Washington Ave Suite C16
Racine, WI 53406
(414) 884-1088 Fax (414) 884-1053
http://www.cyberlynk.net
------ =_NextPart_000_01BEB3DC.C9CBB460
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+IgcVAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYA0AEAAAEAAAAQAAAAAwAAMAIAAAAL
AA8OAAAAAAIB/w8BAAAAUQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAHJhZGl1c250QGllYS1z
b2Z0d2FyZS5jb20AU01UUAByYWRpdXNudEBpZWEtc29mdHdhcmUuY29tAAAAAB4AAjABAAAABQAA
AFNNVFAAAAAAHgADMAEAAAAaAAAAcmFkaXVzbnRAaWVhLXNvZnR3YXJlLmNvbQAAAAMAFQwBAAAA
AwD+DwYAAAAeAAEwAQAAABwAAAAncmFkaXVzbnRAaWVhLXNvZnR3YXJlLmNvbScAAgELMAEAAAAf
AAAAU01UUDpSQURJVVNOVEBJRUEtU09GVFdBUkUuQ09NAAADAAA5AAAAAAsAQDoBAAAAHgD2XwEA
AAAaAAAAcmFkaXVzbnRAaWVhLXNvZnR3YXJlLmNvbQAAAAIB918BAAAAUQAAAAAAAACBKx+kvqMQ
GZ1uAN0BD1QCAAAAAHJhZGl1c250QGllYS1zb2Z0d2FyZS5jb20AU01UUAByYWRpdXNudEBpZWEt
c29mdHdhcmUuY29tAAAAAAMA/V8BAAAAAwD/XwAAAAACAfYPAQAAAAQAAAAAAAACuWgBBIABACMA
AABSRTogW1JhZGl1c05UXSBTUUwgNy4wIHByb2JsZW1zLi4uAIYKAQWAAwAOAAAAzwcGAAsABwAi
AAYABQAbAQEggAMADgAAAM8HBgALAAcAIAAuAAUAQQEBCYABACEAAABCRDhBNTM3RjgxMUZEMzEx
ODA0NzAwMTBBNEYyMTEwMgDiBgEDkAYAzBIAACEAAAALAAIAAQAAAAsAIwAAAAAAAwAmAAAAAAAL
ACkAAAAAAAMALgAAAAAAAwA2AAAAAABAADkAoMt394izvgEeAHAAAQAAACMAAABSRTogW1JhZGl1
c05UXSBTUUwgNy4wIHByb2JsZW1zLi4uAAACAXEAAQAAABYAAAABvrOI919/U4q+H4ER04BHABCk
8hECAAAeAB4MAQAAAAUAAABTTVRQAAAAAB4AHwwBAAAADAAAAG1pY2tAdHNuLmNjAAMABhAvSIDL
AwAHEMINAAAeAAgQAQAAAGUAAABITU1NT0tXRUxMSUhBVkVUSEVTQU1FUFJPQkxFTVRIRU5JVEhJ
TktJV0lMTFRFTExZT1VIT1dUT0ZJWElUVEhJU0FGVEVSTk9PTklUSE9VR0hUTVlQUk9CTEVNV0FT
SE9SU0VQAAAAAAIBCRABAAAArQ8AAKkPAAA8JQAATFpGdYspOjUDAAoAcmNwZzEyNXIyDGBjMQMw
AQcLYG6RDhAwMzMPFmZlD5JPAfcCpANjAgBjaArAc4RldALRcHJxMgAAkioKoW5vElAgMAHQhQHQ
Ng+gMDUwNBQh8wHQFBA0fQdtAoMAUAPU+xH/EwtiE+EUUBOyGPQU0K8HEwKAApEI5jsJbzAa3/pl
DjA1HAodIRzfHekb9P8eEhx/IE8gDR+PHb8cDxBg/DI4Jdom8SavJ7kb9CfivyZPKh8p3SlfJ48r
VDkOUB8upDABKCMwAAKCc3R56mwHkGgJ4HQAABNQA/BQZGN0bAqxXDJYYZhkanUxcAUQZ2gFQq8W
MgwBD1IUEDgAUGMJwMMyYAMwc25leBcwB7AXBbAAwAJzcwBQc2IySxRQMWBhE/BcawngcL8LkDI/
MqMIYDKQC4BlMaD+djnwAUAzmwwwNGQoADTnNzfQBKALgGcn8TV2YmH9FxBkAiA2MDXWMdAzkDyx
/CAxMTMOUDcvOD85TwBR/zqMAKA0bz0fPi4xJA/AP69/QL9Bzw5QOn9EL0U/PkwzewKCExBjNvBN
4TOQPtB0Emk6ICBEARBhdWwVBUBQCsBhCcBhcGgcIEYCITa0JUBmaS11D5A4TEFpUnNIvzKjYj0L
IHIJUFSSFqBUknc0+yVBFwBwAdBPsjO/TE9NX29SEFDQBRACMC1RcANhOgggVG9agFN1YmoFBZB0
WoBEYXRlOv02tDZSP1NPVF9Vb1Z5McD/PsMOIU3hO0YOUFevWL9ZxuZSOhEXASBIPrEEkDa0/jdc
P11PXl9fbTmfYI8PkMts0AjQYgqwdDhLrg+QP0fAYx9kJm1gZTALUHkv71GAX4ALEWWlcza0KABm
n/9nr2i/X39Wj2KPbz9wTlqie1pEW3k5cx8zPwMwbRM5D3b/eA9kF36QRG9jdf8HgAIwBdBRQBoB
fMJ8IHxg+3SxAYBuWwAAYAnwT+CBgHcCATZwYSJlAPCBgDGAcEkegFx2CJB3awuAZP9uoIUiBPAH
QBBhAUAOAHSC9z6ihoUCEG8FQhchEvJbkAZtC1FbkCBDOlxc9VnQb1EhbVFwAxAHkIkwJk0N4ANg
c28BgCBP1wEgDeCEcFyK5kUAwAMQ+i5NsHSCUBcQfGA1sWrSjngBQD6iBJB5NzB78GeHoo21COFz
eI3ig4Fu7zHQGvCMhFB0YwMgEvMAgPkFkGx2QsFIgA5wNnCRAv8BkAAgkZKFcYHBAcGRARbgnw9w
AABIgAzQAZAgLhoS/5D4DlCRslCwfLCSL5M/lE+/D8BIgAWBle+W/5gPbG6g3UiAbJWvmm+bdSmU
fCVAx5lPni+bZGIgKAKRn0//kUNcIJz/ob+iz6PfkXBmcP+lIpH/po+nn5R8KAClL6qv/6u/rM+R
cHvwqa+vP7BPsVQ/CvkDMHwffS9+vzVle0iCbbqwIG9rIHdrAFUDIEk+kGFQMXQx0CDrSAAHgCAX
cG8CYIiQu9L/A6C7cLvgC4C7ALtwA/C7QXtbkLtBeQhgPpC3ALvQb3IgcjB4IFAAvVIEIGHnAYAE
kYewbi4KhQqFvULzCGC40m15vGdw8AQgvsBtFwFwtwAEkCAa8IjCZDouvbZvhOADoJvAc3V2cMNQ
ACAghhG+Eb8Qbf+KVwBwNbC+NwORAHHDcr8B976BBcC8dXPAnAqFthS233u37wVAe4pBFuBrAAYB
df+zwRcAya/Ks2rQtBLLD8wfHwAAD1c1czYwEvJia21ya7MjIF+CAAMQW3Fh9H0t1LJPuLELgAdA
BdDzB5BIAGdl1LPKG7Z2Zl3/coDP33QfdS9qn2uvbL9tz7+6RNIvWkMMggXQzUVIvJADANBRYFtT
TVRQOoZtvsDi0kBjeWIEkMtwkL2QLjXwdF3WX9dk/3Ib2J/Zr9q/dh+5P+AlDDA/0j4GYAIw4dQC
kdI+VGjBCHBzZGF5LD8QNjA+Ss3QE4Av8PEAPxAxOvwwN8oW7M/volqw7l/SxS9RAD7Q6rACMEAI
kGEt04qScPFlLgWgbfGf7VonWvXzj9LFUkVagFtSEfUTTlRdBgBRTCDsNy42MMi2LvxA5O+2sv/P
n9Cv6u+5zM6v/e/+/8zlpUhQLMCddCe/0SDowL/GwjXwvuCL8BbQ3DEg6dAwME1oevBQDjA2Tduw
sPqgbfBQFyBj/EgB1f/isMMnv8ETUMaiCyHFIBOA81ogu+JBY4sgFpAHh8LCz5vA31AIMgbgb3jA
je/Q/7xYu3CJobuRPuK/wZAx/YB/UADigMIg+0bDtfBQBxJz3/2AiyC7EREQTcAnh9AB1f+7lMBQ
wgCVkFFgNgCE4EtQnxtwE1JQAFFgu+JNU/sznRgwcmVRv2FNkGxmE3L/9iHFkcHD/YGbwAHVMaAC
EH88osWQ7/DcgMQgDICO8G//8FC7cMUg6iBbIbvRW4C/YPUX03fb8Gw1sLuTsyMmAPMWBPtCNi5Z
sAHVHCYT0v8UhRER1WEWE4qQvEGKoLvT/81RYXCKABuUikiL8LPQvvL3AdX7glogd71w4vG/wSQg
/4+xvTe74rx2C9AacQ9xGDH/GCL2AL8QIPH/sD6RJxIbsv8B1YYQ/ZC8cYmD/YH7Qlogr79xv8H/
orvTJ1FQeRMg7YYRJxcGvWJnJJEYBP2B/zXwHVEg8QHVzdTTwIOQPLH/CX8FUsk/MRnUszI5AdWL
42e/IFpTzT4gPPUP9hY+/86fAt8D78zUNz84TzlfzOP2T/2Q8HQg8RASwYfQYmDYOjEz8FA0b3eK
cFuQ78CcNxD7Rr/CIH/gRrCH0P+IsoPyxCAPchPAEaEl2MhU/w0HvfIfhuQgJ6CHQDWBHVHXwtH7
QkKTbIfBbYQALRL/W5CzEFAiG6HE4QyjQYdKL/8/r0q/MiTVD9YZNxDhn+KvP+O/5MdB8e4X79/w
5Dk6fDQwQYfzVjWP9h03EENaY1BkTogQHFByuwBP+xWBe1BpE8CJAIHBwCBBiP/4amUw+n/7j0pO
e0DcYAWW/UqZVyFC+JAFcMbhu/Fa0H28QC3b8RjDxIIX0MhyVMNdkAagL01BWAahJAH/8NC7k5vA
Y/HGsx43S7FkYPMIAN4hLzbeIQwkwiAYIn/FsnjAv4G/EPBxjJETwGS/JmJhkRgi/8C98tXgdFrQ
Fxnxu+JBhyIrMGtfQ9nFsXMnxCBsIG4LYv2A+xcRh9BkxTDcIIYQiOEFcL/CIP2BvJD4gisgbCQi
CTD6copwchpxYH+JAGHVWvH//9LV4DVBcbIhMmwyu9BQkP/cYAwhSEC68B1RzdMq5HHm/yvAg/Fq
/HLqBxKHoM3RC1L9LGIhaZEkw4QwHGMTgRFB/2IjCREHEiQgKFg3EHHnePX3RsG74RJQP3AfYYNC
8kdS/70hs8G/UMLRC/ByEf/AHVH+YsIgBVJQsbtACwLE4sNQ0yrBWvEzL9ewL/ERwtBHfP+JAPpQ
QVRFu2BOTERFZsCzsnhfDJF0l+4ATvBa4UkckE9ObJH1bEEohNspgo47Lzw/BG3/VsG/ssLCE7Hw
0Bmh3CDDgb9kuN2xFwEXQU6h3hElg5D0UFUYwWOJMBXCe9ETMv4hh7+Iz4nfiuVhCruTfGCPvRH/
sGrGDJVEQiAXQf+FQiDiXTYTFb6C5nAukUF4/0jRxlBtgEngHJC/cYy8H9L3IzBQkMZwbNwAEZIL
YAeB70jTx8ATUXJ1cytgHUC60P9PiBMYmMkWpZnNG0HG0Ugk/yDyYpEZiHrYu/FI0sAwTqH/yLYS
1BtRG/AkQHJRF9Ap5OxJJ7tBfGFn/WCaY2qBv7+UoIJqkXNxQYcTsHfE4fpntqEhqUAagKXgvNK9
gf9qxHqhB5BSoZ9HwtELYrvi93xgKsEHsG8kQAwSQYeqtH8X8Xj1u5NpMStwzfEdUU9gUkFDTEV8
74eQQfZuwiDBlXOwH01OMo9B4b8zqmAiM5DEIFzgHVFKb9H/NX82j7J6PjHesD6Z8HBWIH8/gbYf
QMq4yUu4UUVAwzr/vWm9S7EscmQQ8ciw3HBa4PsnsYFiP8Asi1OOEyxTEOOP/+AQoyexIlBhenle
2l/AHVABl+LwUB2DT5XAQ/9IMXIQasNUwNxAcZLIYW4C/wrAandvk6RQySIdUdwgMFeXx5XHLcjT
RW+iOjIBEGPeIM7gNjI3v1yd4Vt5IjddW8jTXdLuABczRM/FUW+Q0UDRuF1WWuAScZGWNVBSSWRQ
UlnHLfhLRVmu8//Qm9IrIWwP/20fbi/XE8Z/w8gqoyDAC6DvpFCWp2NAQvFksWBGQCHC/xgBSdB3
oWqzElBYwOjQGnH/BoALQkOgY0AFlpAvkT+ST/2HkGJi4ZeSe/QT0hegLRH/C4FIMt9SF9CXkhOw
8FCcsf/9kGHDRRRigmLRpFPgP+FP/+Jf42ecshJQpLCvEWJkpTPPXTbaT82vzrIzN88SggBfuxDP
r9C/0c/S2kwH0jF/XQB+8N8R3vHk8VLwHRB4f8ctUzAxIQag2j/bSqdCed5wK4IRoSCii/JwYuBq
s/8NwCvAGNP/sKOCIMIxoAvw/wewb+ruv/NgaTISwQ5QYuFvE8ATUQ3AF/BlJXQW2Wf+byGyaMKO
MaPhSeJ1kMcts2LgakBpelrDb+FTIyDecPoAGfHcuHmxQ5sQHJD+RpSxWvETsCGxd/XfUxjwfwTQ
GaGCeL/UG6Ocsl0xTP8pUHMmqrF8VQ+nKiB0UBmQ92q3CdvHLWI6QCyCnLMXJH9RYVpgqKMjIULx
6WBqIWP/jlMDyv1P/pT6lexwgWAdM/+nIwARJUBzcQ+zWvFd0SPA/weT3cOakx2Dawt7RyZ3q4L/
gUQdUlpBMSB3o3WCmXBVIL/j8iUQi+EfUexwIMBtUrH/F6ucwX8gUXBDIUSEtnAlFr+ZcZpIFyMQ
oYJgokIodZH/pnDnMXyT8oCHGKL0RvBU8PvYwXNEdiZhlLhzRPxSaYL/epIGw+dkcfS9aVrxRSNy
6v9zwswjsgi9S71pTfAp3720/7t/LdMzoI3CfqKZUF02vWneXzAvMT8xtb1pSYPAE3GvWFRVIPWB
LcN3NNAuV///vO+zPzg/tFzo7+n/6w9QzX48Uh9TIs1GOj87TzxfQ31SokxS8Vn2NDQ2p89gMb40
YYCCYMTCprCBIEFlIcdcEJlwVaBDMTY2p10wt47AUzBVIFcboGXgM1YwKUcoKDRFgCm6IDg07i1V
QEnAb/BG9mBJW0iAgzankvB0cDovLzTS/1KbNq5OLDi/ON8/4z1vPn//P4lDb0R7RW9GfxyQR88/
xR9Jb0p/P8VMHz9FfXt7wFwqXGJrbXFwebFcX021cSzQ9lB9P8Z9BgBgcWCwAAAAAwAQEAAAAAAD
ABEQAAAAAAMAgBD/////QAAHMGAg3seIs74BQAAIMGAg3seIs74BCwAAgAggBgAAAAAAwAAAAAAA
AEYAAAAAA4UAAAAAAAADAAKACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMABYAIIAYAAAAA
AMAAAAAAAABGAAAAAFKFAAC3DQAAHgAlgAggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAA
OC4wAAMAJoAIIAYAAAAAAMAAAAAAAABGAAAAAAGFAAAAAAAACwAvgAggBgAAAAAAwAAAAAAAAEYA
AAAADoUAAAAAAAADADCACCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAAAAMAMoAIIAYAAAAAAMAA
AAAAAABGAAAAABiFAAAAAAAAHgBBgAggBgAAAAAAwAAAAAAAAEYAAAAANoUAAAEAAAABAAAAAAAA
AB4AQoAIIAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAAAQAAAAAAAAAeAEOACCAGAAAAAADAAAAA
AAAARgAAAAA4hQAAAQAAAAEAAAAAAAAAHgA9AAEAAAAFAAAAUkU6IAAAAAADAA00/TcAANx1
------ =_NextPart_000_01BEB3DC.C9CBB460--