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

[Daniel Tiefnig]

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.
>>>
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> Spce-user mailing list
>>> Spce-user at lists.sipwise.com
>>> http://lists.sipwise.com/listinfo/spce-user
>>>
>>
> 

-- 
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