<div dir="ltr">Hello<div><br></div><div>I removed the CDR but more still coming up with the same error.</div><div><br></div><div>For example:</div><div><br></div><div><div>root@spce:/var/log/ngcp# /etc/init.d/ngcp-rate-o-mat restart</div>
<div>Restarting rate-o-mat: rate-o-mat.</div><div>root@spce:/var/log/ngcp# Error rating CDR batch: No contract balance for CDR 15247 found</div><div><br></div></div><div><div>mysql> select source_account_id from cdr where id = 15247;</div>
<div>+-------------------+</div><div>| source_account_id |</div><div>+-------------------+</div><div>| 13 |</div><div>+-------------------+</div><div>1 row in set (0.00 sec)</div></div><div><br></div><div><div>
mysql> select * from contract_balances where contract_id=6;</div><div>+----+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+</div>
<div>| id | contract_id | cash_balance | cash_balance_interval | free_time_balance | free_time_balance_interval | start | end | invoice_id |</div><div>+----+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+</div>
<div>| 5 | 6 | 0 | 1089.03 | 0 | 0 | 2013-07-01 00:00:00 | 2013-07-31 23:59:59 | NULL |</div><div>| 18 | 6 | 0 | 3402 | 0 | 0 | 2013-08-01 00:00:00 | 2013-08-31 23:59:59 | NULL |</div>
<div>| 44 | 6 | 0 | 84 | 0 | 0 | 2013-09-01 00:00:00 | 2013-09-30 23:59:59 | NULL |</div><div>+----+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+</div>
<div>3 rows in set (0.00 sec)</div><div><br></div></div><div><br></div><div>Any ideas?</div><div><br></div><div>Thanks!</div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra">
<br><br><div class="gmail_quote">On Wed, Oct 2, 2013 at 9:49 PM, Abel Alejandro <span dir="ltr"><<a href="mailto:aalejandro@alliedtechnologygrouppr.com" target="_blank">aalejandro@alliedtechnologygrouppr.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I am getting this error:<br>
<br>
root@spce:/var/log/ngcp# /etc/init.d/ngcp-rate-o-mat restart<br>
Restarting rate-o-mat: rate-o-mat.<br>
root@spce:/var/log/ngcp# Use of uninitialized value in addition (+) at<br>
/usr/sbin/rate-o-mat line 933.<br>
Use of uninitialized value in addition (+) at /usr/sbin/rate-o-mat line 933.<br>
Error rating CDR batch: No contract balance for CDR 14750 found<br>
<br>
However I havent setup any limits for the account, so I am confused by it.<br>
<br>
The cdr is as follow:<br>
<br>
mysql> select * from cdr where id=14750\G<br>
*************************** 1. row ***************************<br>
id: 14750<br>
update_time: 2013-09-03 07:58:17<br>
source_user_id: 66ec170b-dfad-4d7e-96b7-941b557bd334<br>
source_provider_id: 1<br>
source_external_subscriber_id:<br>
source_external_contract_id: Dr Jaime Ortiz<br>
source_account_id: 13<br>
source_user: 802<br>
source_domain: <a href="http://sip.alliedtechpr.com" target="_blank">sip.alliedtechpr.com</a><br>
source_cli: <a href="tel:17877058924" value="+17877058924">17877058924</a><br>
source_clir: 0<br>
source_ip: 192.254.110.8<br>
destination_user_id: 0<br>
destination_provider_id: 2<br>
destination_external_subscriber_id:<br>
destination_external_contract_id:<br>
destination_account_id: 0<br>
destination_user: 178772753XX<br>
destination_domain: 196.12.170.XXX<br>
destination_user_dialed: 78772753XX<br>
destination_user_in: 178772753XX<br>
destination_domain_in: <a href="http://sip.alliedtechpr.com" target="_blank">sip.alliedtechpr.com</a><br>
peer_auth_user:<br>
peer_auth_realm:<br>
call_type: call<br>
call_status: ok<br>
call_code: 200<br>
init_time: 1378209427.219<br>
start_time: 1378209432.490<br>
duration: 55.640<br>
call_id:<br>
<a href="mailto:4f007f934e211aeb179ebf5246ee9e0b@sip.alliedtechpr.com">4f007f934e211aeb179ebf5246ee9e0b@sip.alliedtechpr.com</a><br>
source_carrier_cost: 0.00<br>
source_reseller_cost: 0.00<br>
source_customer_cost: 0.00<br>
source_carrier_free_time: NULL<br>
source_reseller_free_time: NULL<br>
source_customer_free_time: NULL<br>
source_carrier_billing_fee_id: NULL<br>
source_reseller_billing_fee_id: NULL<br>
source_customer_billing_fee_id: NULL<br>
source_carrier_billing_zone_id: NULL<br>
source_reseller_billing_zone_id: NULL<br>
source_customer_billing_zone_id: NULL<br>
destination_carrier_cost: 0.00<br>
destination_reseller_cost: 0.00<br>
destination_customer_cost: 0.00<br>
destination_carrier_free_time: NULL<br>
destination_reseller_free_time: NULL<br>
destination_customer_free_time: NULL<br>
destination_carrier_billing_fee_id: NULL<br>
destination_reseller_billing_fee_id: NULL<br>
destination_customer_billing_fee_id: NULL<br>
destination_carrier_billing_zone_id: NULL<br>
destination_reseller_billing_zone_id: NULL<br>
destination_customer_billing_zone_id: NULL<br>
frag_carrier_onpeak: NULL<br>
frag_reseller_onpeak: NULL<br>
frag_customer_onpeak: NULL<br>
is_fragmented: NULL<br>
split: 0<br>
rated_at: NULL<br>
rating_status: unrated<br>
exported_at: NULL<br>
export_status: unexported<br>
1 row in set (0.00 sec)<br>
<br>
mysql><br>
<span class="HOEnZb"><font color="#888888"><br>
<br>
<br>
--<br>
Abel Alejandro<br>
</font></span></blockquote></div><br><br clear="all"><div><br></div>-- <br><span style="font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255);color:rgb(102,102,102)"><i><font size="4" face="'trebuchet ms', sans-serif">Abel Alejandro</font></i></span><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<blockquote style="margin:0px 0px 0px 40px;border-style:none;padding:0px"></blockquote><span style="color:rgb(51,51,51);font-family:'trebuchet ms',sans-serif">787 586 8313 </span><span style="font-family:'trebuchet ms',sans-serif"><font color="#ff6600">|</font></span><span style="color:rgb(51,51,51);font-family:'trebuchet ms',sans-serif"> 787 705 0555</span><div>
<a href="mailto:joquendo@alliedtechnologygrouppr.com" style="color:rgb(17,85,204)" target="_blank"></a><div><span style="color:rgb(102,102,102);font-family:'trebuchet ms',sans-serif"><img src="http://www.google.com/a/cpanel/alliedtechnologygrouppr.com/images/logo.gif?service=jotspot"><br>
</span></div><div><span style="color:rgb(102,102,102);font-family:'trebuchet ms',sans-serif"><br></span></div><div><span style="color:rgb(102,102,102);font-family:'trebuchet ms',sans-serif">400 Calle Calaf 477</span></div>
<div><div style="text-align:left"><span style="color:rgb(102,102,102);font-family:'trebuchet ms',sans-serif">San Juan, PR 00918</span></div></div></div></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255);text-align:left">
<a href="mailto:aalejandro@alliedtechnologygrouppr.com" target="_blank">aalejandro@alliedtechnologygrouppr.com</a></div>
</div>