[Spce-user] Error rating CDR batch: No contract balance for CDR 1211994 found
Daniel Grotti
dgrotti at sipwise.com
Mon Feb 24 02:54:13 EST 2014
Hi,
problem is that contract line for December is missing, so all the
subsequent contract balances will be 0.
To fix the problem you need to install a new version of rate-o-mat which
fix the issue.
You can follow the instruction I gave you in my first email:
1. upgrade your rate-o-mat (at least v1.5.6)
2. delete line 80 and 99 in contract_balance for that user (February and
January)
3. restart rate-o-mat
Daniel
On 02/24/2014 08:50 AM, Martin Wong wrote:
> So what happened here where the contract became zero?
>
> Is there a way to make it almighty contract so this doesn't happen again?
>
>
>
> On Mon, Feb 24, 2014 at 6:45 PM, Daniel Grotti <dgrotti at sipwise.com
> <mailto:dgrotti at sipwise.com>> wrote:
>
> Hi Martin,
> in order to upgrade rate-o-mat:
>
> /etc/init.d/rate-o-mat stop
> apt-get update
> apt-get install ngcp-rate-o-mat
> /etc/init.d/rate-o-mat start
>
>
> Yes, it looks like rate-o-mat is blocked since Dicember.
> It's trying to rate calls from Dicember but it fails because no contract
> balance are there.
>
> You can't "turn contract off".
> Contract is part of billing system.
>
> Daniel
>
>
>
> On 02/24/2014 04:55 AM, Martin Wong wrote:
> > 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
> <mailto:martin.wong at binaryelements.com.au>
> > <mailto:martin.wong at binaryelements.com.au
> <mailto: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 <mailto:dgrotti at sipwise.com>
> > <mailto:dgrotti at sipwise.com <mailto: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>
> <mailto:dgrotti at sipwise.com <mailto:dgrotti at sipwise.com>>
> > > <mailto:dgrotti at sipwise.com <mailto:dgrotti at sipwise.com>
> <mailto: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
> > <tel:61411571373 <tel:61411571373>> | 0 |
> > > > X.X.X.X | 0 | 3
> |
> > > > |
> |
> > > > 0 | 61411787787 <tel:61411787787>
> <tel:61411787787 <tel:61411787787>> | X.X.X.X
> > | 0411787787 <tel:0411787787> <tel:0411787787
> <tel:0411787787>> |
> > > > 61411787787 <tel:61411787787> <tel:61411787787
> <tel: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>
> > <mailto:Spce-user at lists.sipwise.com
> <mailto:Spce-user at lists.sipwise.com>>
> > <mailto:Spce-user at lists.sipwise.com
> <mailto:Spce-user at lists.sipwise.com>
> > <mailto: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>
> > <mailto:Spce-user at lists.sipwise.com
> <mailto:Spce-user at lists.sipwise.com>>
> > <mailto:Spce-user at lists.sipwise.com
> <mailto:Spce-user at lists.sipwise.com>
> > <mailto:Spce-user at lists.sipwise.com
> <mailto:Spce-user at lists.sipwise.com>>>
> > > http://lists.sipwise.com/listinfo/spce-user
> > >
> > >
> >
> >
> >
> >
>
>
More information about the Spce-user
mailing list