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

Martin Wong martin.wong at binaryelements.com.au
Sun Feb 23 22:55:49 EST 2014


Also, can you let me know what this contract does?

is it possible to turn this off?

and also, why is rate-o-mat looking at december ones? Does it mean that it
hasn't been doing its rating since Jan?

Please advise soonest.

Thanks

Martin

On Mon, Feb 24, 2014 at 2:44 PM, Martin Wong <
martin.wong at binaryelements.com.au> wrote:

> Hi, it's getting stuck all over in the CDR.
>
> This is a fairly utilized system and I don't want to upgrade the system if
> it's working.
>
> Can you tell me how to get only rate-o-mat upgraded?
>
> Martin
>
> On Fri, Feb 21, 2014 at 7:06 PM, Daniel Grotti <dgrotti at sipwise.com>wrote:
>
>> Hi,
>> Ok, problem is that the contract_balance from dicember 2013 is missing
>> and rate-o-mat is traying to rate a call from dicember.
>>
>> I suggest to:
>>
>> 1. upgrade your rate-o-mat (at least v1.5.6)
>> 2. delete line 80 and 99 in contract_balance for that user
>> 3. restart rate-o-mat
>>
>> if you get the same error for other users (regardind calls from
>> Dicember), just delete the lines in contract_balances relate to Feb and
>> Jan and restart rate-o-mat.
>>
>>
>> Daniel
>>
>>
>>
>>
>>
>>
>> On 02/21/2014 08:57 AM, Martin Wong wrote:
>> > 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
>> > <mailto: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 <mailto:Spce-user at lists.sipwise.com>
>> >     > http://lists.sipwise.com/listinfo/spce-user
>> >     >
>> >
>> >     _______________________________________________
>> >     Spce-user mailing list
>> >     Spce-user at lists.sipwise.com <mailto: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/20140224/f2ed96fe/attachment-0001.html>


More information about the Spce-user mailing list