Hi Lincoln,
I figured out the problem. The ACCTOUTPUTOCTETS data was too big =>
2636644608. The maximum number for data type 'int' on the SQL 7.0 is
2,147,483,647.
Thank you for time!
Janet
Lincoln Broomhall wrote:
>
> Is your integer field 32-bit unsigned ? That is what NAS's are typically.
>
> -----Original Message-----
> From: Janet N del Mundo [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 25 January 2001 12:24 PM
> To: [EMAIL PROTECTED]
> Subject: (RADIATOR) Arithmetic overflow error...
>
> Hi,
>
> I recently installed iPass on our network and I noticed that some Stop
> records are not being inserted in the accounting table. In the logs, it
> has the error:
>
> ---------------------------------------------------------------------------
> [OpenLink][ODBC][SQL Server]Arithmetic overflow error converting numeric
> to data type int
> ---------------------------------------------------------------------------
>
> I've looked at my radius.cfg and I compared all the integer fields to
> the data that's trying to be inserted into those fields. The only
> integer field that has no data being inserted is the Acct-Delay-Time.
>
> I don't know why these Stop records are not being recorded. Anybody
> have a clue?
>
> cfg file
> --------------------------------------------------------------------
> AccountingTable ACCOUNTING
>
> AcctColumnDef IDENTIFIER,User-Name
> AcctColumnDef TIME_STAMP,Timestamp,formatted-date,'%m-%d-%Y
> %H:%M:%S'
> -> AcctColumnDef DURATION,Acct-Session-Time,integer
> AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
> -> AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer
> -> AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer
> -> AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
> AcctColumnDef ACCTSESSIONID,Acct-Session-Id
> AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause
> AcctColumnDef NASIDENTIFIER,NAS-IP-Address
> -> AcctColumnDef NASPORT,NAS-Port,integer
> AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
> AcctColumnDef CONNECTSPEED,Connect-Info
> AcctColumnDef CONNECTSPEED,USR-Connect-Speed
> AcctColumnDef CALLERID,Calling-Station-Id
> AcctColumnDef POPID,Called-Station-Id
>
> logfile
> --------------------------------------------------------------------
> Wed Jan 24 20:19:09 2001: ERR: do failed for 'insert into ACCOUNTING
> (IDENTIFIER, TIME_STAMP, DURATION, ACCTSTATUSTYPE,
> ACCTINPUTOCTETS, ACCTOUTPUTOCTETS, ACCTSESSIONID, NASIDENTIFIER,
> NASPORT, FRAMEDIPADDRESS, POPID)
> values
> ('lcf', '01-24-2001 20:19:08', 153, 'Stop', 471793664,
> 2636644608, '327172759', '210.253.96.17', 21606, '210.253.98.190', '')':
> [OpenLink][ODBC][SQL Server]Arithmetic overflow error converting numeric
> to data type int. (SQL-S1000)(DBD: st_execute/SQLExecute err=-1)
>
> I'd appreciate any help or hints!!!
> Thank you,
> Janet
>
> _____________________________________________________
> Janet del Mundo
> Internet Administrator, Startec Global Communications
> 135 Chalan Santo Papa Agana, Guam 96910
> Email: [EMAIL PROTECTED]
>
> ===
> Archive at http://www.starport.net/~radiator/
> Announcements on [EMAIL PROTECTED]
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.