Re: Calls table not functioning, Calls online not functioning

James B. Hrdy ( (no email) )
Wed, 24 Jun 1998 15:32:14 +0000

Is this possible with an Access database?

> 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 Softwar

James B. Hrdy
email: jhrdy@greensoft.com
web: http://www.greensoft.com/billing
GreenSoft Solutions, Inc.
Voice: 785.843.8683 ext 203
2317 Ponderosa Drive
Fax: 785.840.0055
Lawrence, Ks.
United States of America