[Spce-user] all rates 0 value.... :-(

[Daniel Tiefnig]

Ramón,

with the data you provided I've reproduced the setup on a test VM over
here, and the rating was ok, creating a customer_cost of 0.49 using the
rate for "^346.*$".

In theory now I'd say it's impossible you get something different. :o(

By any chance, did you change rate-o-mat, or do anything else unusual?

br,
daniel


On 04/19/2011 10:54 AM, Daniel Tiefnig wrote:
> Hi,
> 
> is the customer_billing_fee_id in the CDR unchanged?
> 
> Can you issue the following two commands and send me the output files?
> 
> select * into outfile '/tmp/cdr137.txt'
>   from accounting.cdr where id = 137;
> 
> select * into outfile '/tmp/profile2.txt'
>   from billing.billing_fees_history where billing_profile_id = 2;
> 
> I'll try to reproduce the issue over here.
> 
> br,
> daniel
> 
> 
> On 04/18/2011 05:44 PM, Ramón Martínez wrote:
>>
>>
>>  no, it has not changed. the rates were inserted yesterday, i have executed the update query and all is the same.
>>
>>
>> in the rate-o-matic log all seems fine.
>>
>>  
>> Apr 18 15:41:53 sip rate-o-mat[737]: No new CDRs to rate, sleep 10
>> Apr 18 15:42:03 sip rate-o-mat[737]: rate cdr #137
>> Apr 18 15:42:03 sip rate-o-mat[737]: 30 CDRs rated so far.
>>
>>
>>  but the cost is still 0.
>>
>>
>> ----- Mensaje original -----
>> De: "Daniel Tiefnig" <dtiefnig at sipwise.com>
>> Para: spce-user at lists.sipwise.com
>> Enviados: Lunes, 18 de Abril 2011 17:31:53
>> Asunto: Re: [Spce-user] all rates 0 value.... :-(
>>
>> Hi,
>>
>> that entry looks perfectly ok. Maybe it has been changed only after the
>> CDR has been rated? If you change the rating status of the CDR to
>> 'unrated', fees will be calculated again:
>>
>> UPDATE accounting.cdr SET rating_status = 'unrated' WHERE id = 137;
>>
>> If that doesn't help, and if /var/log/ngcp/rate-o-mat.log doesn't print
>> anything unusual we'd have to debug rate-o-mat a bit.
>>
>> br,
>> daniel
>>
>>
>> On 04/18/2011 05:18 PM, Ramón Martínez wrote:
>>>
>>>  is that. 
>>>
>>> +-------+--------------------+-----------------+-------------+------+------------------+----------------------+--------------------+------------------------+-------------------+-----------------------+---------------------+-------------------------+---------------+
>>> | id    | billing_profile_id | billing_zone_id | destination | type | onpeak_init_rate | onpeak_init_interval | onpeak_follow_rate | onpeak_follow_interval | offpeak_init_rate | offpeak_init_interval | offpeak_follow_rate | offpeak_follow_interval | use_free_time |
>>> +-------+--------------------+-----------------+-------------+------+------------------+----------------------+--------------------+------------------------+-------------------+-----------------------+---------------------+-------------------------+---------------+
>>> | 20862 |                  2 |             969 | ^346.*$     | call |          0.00112 |                    6 |            0.00112 |                      6 |           0.00112 |                     6 |             0.00112 |                       6 |             0 |
>>> +-------+--------------------+-----------------+-------------+------+------------------+----------------------+--------------------+------------------------+-------------------+-----------------------+---------------------+-------------------------+---------------+
>>>
>>> ----- Mensaje original -----
>>> De: "Daniel Tiefnig" <dtiefnig at sipwise.com>
>>> Para: spce-user at lists.sipwise.com
>>> Enviados: Lunes, 18 de Abril 2011 17:12:05
>>> Asunto: Re: [Spce-user] all rates 0 value.... :-(
>>>
>>> Hi,
>>>
>>> I guess the subscriber's billing profile has a 0 rate for that
>>> destination then. What does the billing fee entry exactly look like?
>>>
>>> br,
>>> daniel
>>>
>>>
>>>
>>> On 04/18/2011 04:48 PM, Ramón Martínez wrote:
>>>> this is what the CDR looks like.
>>>>
>>>>  there are money in the carrier cost, but not in the customer cost.
>>>>
>>>>
>>>> '137','2011-04-18 11:20:20','050d6a16-5cf3-4845-893b-3e18f1941e00','1','rampa','sip.g-matrix.com','34925018XXX','0','0','4','34644044XXX','67.19.81.202','34644044XXX','sip.g-matrix.com','call','ok','200','2011-04-18 11:12:47','438','3176ff0f0f27972de76048adac0ddaea at 192.168.254.235','ok','2011-04-18 11:20:20','0.49','0.00','Spain Movile','Spain Movil','Spain Movile','Spain Movil','644044XXX'
>>>>
>>>> ----- Mensaje original -----
>>>> De: "Ramón Martínez" <ramon.martinez at tb-solutions.com>
>>>> Para: spce-user at lists.sipwise.com
>>>> Enviados: Lunes, 18 de Abril 2011 16:42:49
>>>> Asunto: [Spce-user] all rates 0 value.... :-(
>>>>
>>>>
>>>>  Hi.
>>>>
>>>>   the rate engine is rating all as €0.0000.
>>>>
>>>>
>>>>  How can i debug it? all the rates seems ok and the rate-o-matic is rating them. looking in the acc database, it rates with the correct billing rate id.
>>>>
>>>
>>
>


-- 
Geschäftsführer                                    Sipwise GmbH
e: dtiefnig at sipwise.com                          Europaring F15
t: +43 699 1129 1017                          A-2345 Brunn a.G.
w: www.sipwise.com        FN: 305595f    FG: LG Wiener Neustadt