[Spce-user] Error in rate-o-mate
Raul Alonso
raul.alonso at tpartner.net
Tue Nov 26 04:42:45 EST 2013
hello,
I have a problem with the rate-o-mate, when I start it returns the following
error, and I can not see the problem:
rate-o-mat.log
Nov 26 10:16:05 sipproxy01 rate-o-mat[3604]: rate cdr #7102
Nov 26 10:16:05 sipproxy01 rate-o-mat[3604]: Error executing update cdr
statement: Out of range value for column 'source_carrier_cost' at row 1
Nov 26 10:16:05 sipproxy01 rate-o-mat[3604]: Caught DBI:err 1264
Nov 26 10:16:05 sipproxy01 rate-o-mat[3604]: Error rating CDR batch:
mysql> select * from cdr where id='7102'\G
*************************** 1. row ***************************
id: 7102
update_time: 2013-11-16 20:32:21
source_user_id: 0ec7435f-1548-43eb-8721-XXXXXXXX
source_provider_id: 1
source_external_subscriber_id: user
source_external_contract_id: user
source_account_id: 18
source_user: user
source_domain: user.domain.net
source_cli: 349XXXXXXX
source_clir: 0
source_ip: 188.XX.XX.XX
destination_user_id: 0
destination_provider_id: 4
destination_external_subscriber_id:
destination_external_contract_id:
destination_account_id: 0
destination_user: 686XXXXX
destination_domain: 21.XX.XX.XX
destination_user_dialed: 686XXXXXX
destination_user_in: 686XXXXXX
destination_domain_in: user.domain.net
peer_auth_user:
peer_auth_realm:
call_type: call
call_status: ok
call_code: 200
init_time: 1384630010.184
start_time: 1384630019.870
duration: 314.940
call_id: 28eff98d-55b72c95 at 192.168.2.10
source_carrier_cost: 0.00
source_reseller_cost: 0.00
source_customer_cost: 0.00
source_carrier_free_time: NULL
source_reseller_free_time: NULL
source_customer_free_time: NULL
source_carrier_billing_fee_id: NULL
source_reseller_billing_fee_id: NULL
source_customer_billing_fee_id: NULL
source_carrier_billing_zone_id: NULL
source_reseller_billing_zone_id: NULL
source_customer_billing_zone_id: NULL
destination_carrier_cost: 0.00
destination_reseller_cost: 0.00
destination_customer_cost: 0.00
destination_carrier_free_time: NULL
destination_reseller_free_time: NULL
destination_customer_free_time: NULL
destination_carrier_billing_fee_id: NULL
destination_reseller_billing_fee_id: NULL
destination_customer_billing_fee_id: NULL
destination_carrier_billing_zone_id: NULL
destination_reseller_billing_zone_id: NULL
destination_customer_billing_zone_id: NULL
frag_carrier_onpeak: NULL
frag_reseller_onpeak: NULL
frag_customer_onpeak: NULL
is_fragmented: NULL
split: 0
rated_at: NULL
rating_status: unrated
exported_at: NULL
export_status: unexported
1 row in set (0.00 sec)
Regrads,
Raúl Alonso
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20131126/693b80a9/attachment.html>
More information about the Spce-user
mailing list