(RADIATOR) Execute MS SQL Procedure and getting error for Account Start Record.

[Nayeem (Zajil Com)]

Dear All,

I'm facing one problem while execute procedure for Start Record for
Accounting because in start record accounting there is no Acct-Input-Octets,
Acct-Output-Octets & Acct-Session-Time and while passing parameter to
procedure it is empty and got error. 

For example : For Live Accounting.

In Config File.

AcctSQLStatement exec AliveUsageDSl '%n','%{Acct-Status-Type}',
%{Acct-Input-Octets},\
		%{Acct-Output-Octets},'%{Acct-Session-Id}',
%{Acct-Session-Time}, \
		'%m/%d/%Y %H:%M:%S','%{Calling-Station-Id}',
'%{Framed-IP-Address}', '%{Acct-Terminate-Cause}'



On Logs I got this error.

Mon May  1 18:36:18 2006: DEBUG: do query is: 'exec AliveUsageDSl
'username at 256.zajil.net','Start', ,,'0032C580', , '05/01/2006
18:36:18','ula_02200700074', '', ''': 
Mon May  1 18:36:18 2006: ERR: do failed for 'exec AliveUsageDSl
'username at 256.zajil.net','Start', ,,'0032C580', , '05/01/2006
18:36:18','ula_02200700074', '', ''': [Microsoft][ODBC SQL Server
Driver][SQL Server]Line 1: Incorrect syntax near ','. (SQL-42000)(DBD:
Execute immediate failed err=-1)
Mon May  1 18:36:18 2006: ERR: do failed for 'exec AliveUsageDSl
'username at 256.zajil.net','Start', ,,'0032C580', , '05/01/2006
18:36:18','ula_02200700074', '', ''': [Microsoft][ODBC SQL Server
Driver][SQL Server]Line 1: Incorrect syntax near ','. (SQL-42000)(DBD:
Execute immediate failed err=-1)


So, any one can help to solve this problem.

Thanks.

Regards,
Nayeem.
 

--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.