[Spce-user] No contract balance
Abel Alejandro
aalejandro at alliedtechnologygrouppr.com
Wed Oct 16 18:25:17 EDT 2013
Oops sorry I meant this contract:
mysql> select * from contract_balances where contract_id=13;
+----+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+
| id | contract_id | cash_balance | cash_balance_interval |
free_time_balance | free_time_balance_interval | start | end
| invoice_id |
+----+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+
| 12 | 13 | 0 | 219 |
0 | 0 | 2013-07-01 00:00:00 | 2013-07-31 23:59:59
| NULL |
| 19 | 13 | 0 | 1927.5 |
0 | 0 | 2013-08-01 00:00:00 | 2013-08-31 23:59:59
| NULL |
| 22 | 13 | 0 | 0 |
0 | 0 | 2013-10-01 00:00:00 | 2013-10-31 23:59:59
| NULL |
+----+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+
3 rows in set (0.00 sec)
On Wed, Oct 16, 2013 at 6:23 PM, Abel Alejandro <
aalejandro at alliedtechnologygrouppr.com> wrote:
> 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
>
--
*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/6ecb8d96/attachment-0001.html>
More information about the Spce-user
mailing list