[RADIATOR] Reducing the size of a variable

Gilbert T. Gutierrez, Jr. Gilbert.G at phoenixinternet.net
Tue Feb 10 11:41:18 CST 2009


I am getting the following errorTue Feb 10 10:02:48 2009: ERR: do failed for
'insert into Calls
(AcctDelayTime,AcctSessionId,AcctStatusType,CallDate,NASIdentifier,NASPort,U
serName) values (50,'1/0/0/1.69_0000040B',1,'Feb 10, 2009
10:02','x.x.x.x',268501061,'familyinn')': [Microsoft][ODBC SQL Server
Driver][SQL Server]String or binary data would be truncated. (SQL-22001)
[state was 22001 now 01000]


The system is having problems with the AcctSessionID field.  The MSSQL
database only allows for a string of 10 characters.  How can I truncate the
string before Radiator pushes it to the database?  Below is my Realm
Definition.

<Realm DEFAULT>
        <AuthBy EMERALD>
                DBSource        dbi:ODBC:Platypus
                DBUsername      xxxx
                DBAuth          xxxx
                AddATDefaults

		AccountingTable	Calls
		AcctColumnDef	UserName,User-Name
		AcctColumnDef	CallDate,Timestamp,integer-date
		AcctColumnDef	AcctStatusType,Acct-Status-Type,integer
		AcctColumnDef	AcctDelayTime,Acct-Delay-Time,integer
		AcctColumnDef	AcctInputOctets,Acct-Input-Octets,integer
		AcctColumnDef	AcctOutputOctets,Acct-Output-Octets,integer
		AcctColumnDef	AcctSessionId,Acct-Session-Id
		AcctColumnDef	AcctSessionTime,Acct-Session-Time,integer
		AcctColumnDef
AcctTerminateCause,Acct-Terminate-Cause,integer
		AcctColumnDef	NASIdentifier,NAS-Identifier
		AcctColumnDef	NASIdentifier,NAS-IP-Address
		AcctColumnDef	NASPort,NAS-Port,integer
		AcctColumnDef	CallerID,Calling-Station-ID
        </AuthBy>
        <Log EMERALD>
                DBSource        dbi:ODBC:Platypus
                DBUsername      platypus
                DBAuth          big0mess
	</Log>
</Realm>


Thank you,
Gilbert T. Gutierrez, Jr.



More information about the radiator mailing list