Re: Calls table not functioning, Calls online not functioning

Dale Reed ( )
Wed, 24 Jun 1998 01:55:46 -0700

James B. Hrdy wrote:
> Here is the debug info from a different install of RadiusNT, but with a
> similar problem. The calls online isnt working.
> ODBC Error:23000:-1605:
> [Microsoft][ODBC Microsoft Access 97 Driver] The changes you requested to the table
> were not successful because they would create duplicate values in the index, primary key,
> or relationship. Change the data in the field or fields that contain duplicate data, remove
> the index, or redefine the index to permit duplicate entries and try again.

This error usually means that RadiusNT already received the accounting
request. I have had reports of upgrading the OS of a USR and it
resetting the Acct-Session-ID counter, which caused all the duplicates
for a long time. If you are seeing this, you can update all the
Acct-Session-ID fields in your DB like:

Update Calls
Set AcctSessionID = '99' + AcctSessionID

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