Re: [Emerald] ODBC error

Dale E. Reed Jr. ( (no email) )
Sat, 17 Jul 1999 09:13:03 -0700

"Michael Vincent K. Pozon - CompE" wrote:
>
> guys ,
> i found out why some users are not listed in the online windows
> becoz of this error :
>
> ODBC Error:23000:2627:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY K
> int 'pk_RadLogs': Attempt to insert duplicate key in object 'RadLogs'.
>
> Question :
> how do i fix this error ?

What kind of terminal server are you using? This means that
RadiusNT things it already received the accounting record. However,
some terminals servers (notably USR) reuse Acct-Session-IDs to
quickly, which can cause the above problem.

The only way to help prevent this is to add the username to the
Primary Key in the Calls table.

-- 



Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart