Re: [RadiusNT] Acct batch error

Peter Deacon ( peterd@iea-software.com )
Wed, 10 Jul 2002 10:13:18 -0700 (Pacific Daylight Time)

On Wed, 10 Jul 2002, Serkan SUBASI wrote:

> RadiusNT v4.0.21 with MS SQL Server 2000

> Acct batch error will try executing current batch 1 more times. [23000]
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value
> NULL into column 'AcctSessionID', table 'turknet.dbo.Calls'; column does
> not allow nulls. INSERT fails. [INSERT INTO
> Calls(CallDate,AcctStatusType,AcctDelayTime,UserName,NASIdentifier)VALUE
> S('20020708 13:13:5',9,0,'','213.xxx.yyy.zzz') ]

> Q. 1. what is AcctStatusType = 9 ?

It's Tunnel-Start.
There's more details on these at http://www.ietf.org/rfc/rfc2868.txt

> Q. 2. if an acct batch fails because of one of the queries, what will
> happen to other queries without problem ?

They are still uploaded.

take care,
Peter

------------

This is a user supported list. If you require assistance from IEA Software's
Support Engineers, please check out our Support resources at
http://www.iea-software.com/support.

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