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

[Martin Wong]

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    |
+---------+---------------------+--------------------------------------+--------------------+
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20140221/ce228a39/attachment.html>