[Spce-user] rate-o-mat rates calls with 0 cost even though a rate is available

[Daniel Grotti]

Hi,
you should first check the CDR of that call in mysql, accounting.cdr table.
in CDR you will see the filed:

source_customer_billing_fee_id: xxxxxx


That number is the billing_fee_id matched to bill that call, and you can 
find it via:

select * from billing_fees_history where id='xxxxx'

in this way you can see if the call is really fetching the expected fee 
or not.

 From what you are saying it seems that the call is fetching another fee 
with rate 0.


Daniel





On 11/21/2017 07:48 PM, 4voice Service wrote:
>
> Hi all,
>
> I have an issue with rate-o-mat rating most calls with 0 cost even tough
> a billing fee is available:
>
>
> situation:
>
> subscriber X has a billing profile assigned
>
> the billing profile contains a record
>
> source: .
> destination: ^43.+$
> fee: 0.02
>
> When the subscriber calls a record is added to the cdr table.
>
> But after rate-o-matic rates the call it says rating status "rated", but
> the cost is still 0
>
> +--------------+-------------------------+----------+----------------------+---------------+--------------------------------+---------------------------+-------------------------------------+ 
>
> | source_user  | destination_user_dialed | duration |
> source_customer_cost | rating_status | source_customer_billing_fee_id |
> destination_customer_cost | destination_customer_billing_fee_id |
> +--------------+-------------------------+----------+----------------------+---------------+--------------------------------+---------------------------+-------------------------------------+ 
>
> | 4367xxxxxxx | 431xxxxxxxxxxx            |  129.825 | 0.000000 |
> ok            |                           NULL |
> 0.000000 |                                NULL |
> +--------------+-------------------------+----------+----------------------+---------------+--------------------------------+---------------------------+-------------------------------------+ 
>
> 1 row in set (0.00 sec)
>
> Note that the billing_fee_ids also remain 0.
>
> I've tried creating and assigning a new billing profile with just 1
> catchall record. But after setting the status to 'unrated' it just gets
> rated again with 0 cost.
>
> There are no errors in cdr.log and rate-o-mat.log (the latter shows the
> cdr has been rated, but no additional errors/info)
>
> How do I troubleshoot/fix?
>
> Regards,
> Pieter
>
>
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user