[Spce-user] No contract balance

[Abel Alejandro]

Hello

I removed the CDR but more still coming up with the same error.

For example:

root at spce:/var/log/ngcp# /etc/init.d/ngcp-rate-o-mat restart
Restarting rate-o-mat: rate-o-mat.
root at spce:/var/log/ngcp# Error rating CDR batch: No contract balance for
CDR 15247 found

mysql> select source_account_id from cdr where id = 15247;
+-------------------+
| source_account_id |
+-------------------+
|                13 |
+-------------------+
1 row in set (0.00 sec)

mysql> select * from contract_balances where contract_id=6;
+----+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+
| id | contract_id | cash_balance | cash_balance_interval |
free_time_balance | free_time_balance_interval | start               | end
                | invoice_id |
+----+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+
|  5 |           6 |            0 |               1089.03 |
0 |                          0 | 2013-07-01 00:00:00 | 2013-07-31 23:59:59
|       NULL |
| 18 |           6 |            0 |                  3402 |
0 |                          0 | 2013-08-01 00:00:00 | 2013-08-31 23:59:59
|       NULL |
| 44 |           6 |            0 |                    84 |
0 |                          0 | 2013-09-01 00:00:00 | 2013-09-30 23:59:59
|       NULL |
+----+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+
3 rows in set (0.00 sec)


Any ideas?

Thanks!







On Wed, Oct 2, 2013 at 9:49 PM, Abel Alejandro <
aalejandro at alliedtechnologygrouppr.com> wrote:

> I am getting this error:
>
> root at spce:/var/log/ngcp# /etc/init.d/ngcp-rate-o-mat restart
> Restarting rate-o-mat: rate-o-mat.
> root at spce:/var/log/ngcp# Use of uninitialized value in addition (+) at
> /usr/sbin/rate-o-mat line 933.
> Use of uninitialized value in addition (+) at /usr/sbin/rate-o-mat line
> 933.
> Error rating CDR batch: No contract balance for CDR 14750 found
>
> However I havent setup any limits for the account, so I am confused by it.
>
> The cdr is as follow:
>
> mysql> select * from cdr where id=14750\G
> *************************** 1. row ***************************
>                                   id: 14750
>                          update_time: 2013-09-03 07:58:17
>                       source_user_id: 66ec170b-dfad-4d7e-96b7-941b557bd334
>                   source_provider_id: 1
>        source_external_subscriber_id:
>          source_external_contract_id: Dr Jaime Ortiz
>                    source_account_id: 13
>                          source_user: 802
>                        source_domain: sip.alliedtechpr.com
>                           source_cli: 17877058924
>                          source_clir: 0
>                            source_ip: 192.254.110.8
>                  destination_user_id: 0
>              destination_provider_id: 2
>   destination_external_subscriber_id:
>     destination_external_contract_id:
>               destination_account_id: 0
>                     destination_user: 178772753XX
>                   destination_domain: 196.12.170.XXX
>              destination_user_dialed: 78772753XX
>                  destination_user_in: 178772753XX
>                destination_domain_in: sip.alliedtechpr.com
>                       peer_auth_user:
>                      peer_auth_realm:
>                            call_type: call
>                          call_status: ok
>                            call_code: 200
>                            init_time: 1378209427.219
>                           start_time: 1378209432.490
>                             duration: 55.640
>                              call_id:
> 4f007f934e211aeb179ebf5246ee9e0b at sip.alliedtechpr.com
>                  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)
>
> mysql>
>
>
>
> --
> Abel Alejandro
>



-- 
*Abel Alejandro*

787 586 8313 | 787 705 0555
<joquendo at alliedtechnologygrouppr.com>


400 Calle Calaf 477
San Juan, PR 00918
aalejandro at alliedtechnologygrouppr.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20131016/c597e52c/attachment-0001.html>