[Spce-user] Error rating CDR batch: No contract balance for CDR 1211994 found

[Daniel Grotti]

Hi,
looks like contact_balance is missing for that account_id.
please check the following output:

mysql> select * from billing.contract_balances where contract_id="5";

where "5" is the source_account_id value in you CDR table.


Daniel



On 02/21/2014 06:14 AM, Martin Wong wrote:
> Hi guys,
> 
> can someone guide me on this? Rate-o-mat died and is causing all sort of
> issues on my end.
> 
> The error says 
> 
> Error rating CDR batch: No contract balance for CDR 1211994 found
> 
> Looking at 1211994, it's the following ... any idea? I've never had this
> stop like this before.
> 
> ----------+---------------+-------+----------+---------------+-------------+---------------+
> | id      | update_time         | source_user_id                       |
> source_provider_id | source_external_subscriber_id |
> source_external_contract_id | source_account_id | source_user         |
> source_domain | source_cli  | source_clir | source_ip       |
> destination_user_id | destination_provider_id |
> destination_external_subscriber_id | destination_external_contract_id |
> destination_account_id | destination_user | destination_domain |
> destination_user_dialed | destination_user_in | destination_domain_in |
> peer_auth_user | peer_auth_realm | call_type | call_status | call_code |
> init_time      | start_time     | duration | call_id                    
>                  | source_carrier_cost | source_reseller_cost |
> source_customer_cost | source_carrier_free_time |
> source_reseller_free_time | source_customer_free_time |
> source_carrier_billing_fee_id | source_reseller_billing_fee_id |
> source_customer_billing_fee_id | source_carrier_billing_zone_id |
> source_reseller_billing_zone_id | source_customer_billing_zone_id |
> destination_carrier_cost | destination_reseller_cost |
> destination_customer_cost | destination_carrier_free_time |
> destination_reseller_free_time | destination_customer_free_time |
> destination_carrier_billing_fee_id | destination_reseller_billing_fee_id
> | destination_customer_billing_fee_id |
> destination_carrier_billing_zone_id |
> destination_reseller_billing_zone_id |
> destination_customer_billing_zone_id | frag_carrier_onpeak |
> frag_reseller_onpeak | frag_customer_onpeak | is_fragmented | split |
> rated_at | rating_status | exported_at | export_status |
> +---------+---------------------+--------------------------------------+--------------------+-------------------------------+-----------------------------+-------------------+---------------------+---------------+-------------+-------------+-----------------+---------------------+-------------------------+------------------------------------+----------------------------------+------------------------+------------------+--------------------+-------------------------+---------------------+-----------------------+----------------+-----------------+-----------+-------------+-----------+----------------+----------------+----------+----------------------------------------------+---------------------+----------------------+----------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+--------------------------------+---------------------------------
 +
---------------------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+------------------------------------+-------------------------------------+-------------------------------------+-------------------------------------+--------------------------------------+--------------------------------------+---------------------+----------------------+----------------------+---------------+-------+----------+---------------+-------------+---------------+
> | 1211994 | 2013-12-01 16:49:02 | f1c1382d-57f9-4b86-bc6b-3c9c316be6ed |
> 1                  | username1           | user1                  |    
>             5 | username1 | X.X.X.X | 61411571373 |           0 |
> X.X.X.X | 0                   | 3                       |              
>                      |                                  |              
>        0 | 61411787787      | X.X.X.X    | 0411787787              |
> 61411787787         |  X.X.X.X          |                |              
>   | call      | ok          | 200       | 1385876899.128 |
> 1385876934.180 |    3.110 | NDgwNjUzZWFjNWM1M2Q0MTU5NGJmYmZhMDE1ODE3M2E.
> |                0.00 |                 0.00 |                 0.00 |  
>                   NULL |                      NULL |                    
>  NULL |                          NULL |                           NULL |
>                           NULL |                           NULL |      
>                      NULL |                            NULL |          
>           0.00 |                      0.00 |                      0.00 |
>                          NULL |                           NULL |        
>                   NULL |                               NULL |          
>                      NULL |                                NULL |      
>                          NULL |                                 NULL |  
>                               NULL |                NULL |              
>   NULL |                 NULL |          NULL |     0 | NULL     |
> unrated       | NULL        | unexported    |
> +---------+---------------------+--------------------------------------+--------------------+
> 
> 
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/listinfo/spce-user
>