Re: Calls table not functioning, Calls online not functioning
Dale Reed ( daler@iea-software.com )
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. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com