[Spce-user] Error rating CDR batch: No contract balance for CDR 1211994 found
Martin Wong
martin.wong at binaryelements.com.au
Fri Feb 21 02:57:47 EST 2014
I guess this means it's gone to zero somehow.
My question is ... how did it start off with a value there and how is it
zero ... if you can let me know what's happening cuz I have a few more
contracts which have zero value as well.
+----+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+
| id | contract_id | cash_balance | cash_balance_interval |
free_time_balance | free_time_balance_interval | start | end
| invoice_id |
+----+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+
| 4 | 5 | 0 | 69047.2996051473 |
0 | 0 | 2013-07-01 00:00:00 | 2013-07-31 23:59:59
| NULL |
| 9 | 5 | 0 | 180614.057300869 |
0 | 0 | 2013-08-01 00:00:00 | 2013-08-31 23:59:59
| NULL |
| 36 | 5 | 0 | 118444.60765611 |
0 | 0 | 2013-09-01 00:00:00 | 2013-09-30 23:59:59
| NULL |
| 49 | 5 | 0 | 110544.34936783 |
0 | 0 | 2013-10-01 00:00:00 | 2013-10-31 23:59:59
| NULL |
| 70 | 5 | 0 | 308513.299971317 |
0 | 0 | 2013-11-01 00:00:00 | 2013-11-30 23:59:59
| NULL |
| 80 | 5 | 0 | 0 |
0 | 0 | 2014-01-01 00:00:00 | 2014-01-31 23:59:59
| NULL |
| 99 | 5 | 0 | 0 |
0 | 0 | 2014-02-01 00:00:00 | 2014-02-28 23:59:59
| NULL |
+----+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+
On Fri, Feb 21, 2014 at 6:28 PM, Daniel Grotti <dgrotti at sipwise.com> wrote:
> 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
> >
>
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/listinfo/spce-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20140221/94307afb/attachment-0001.html>
More information about the Spce-user
mailing list