[Spce-user] R: Problem with rating

[Alessandro Bolletta]

Thank you Daniel, 
 
that solved my problem.

Regards,
Alessandro Bolletta
 
Da: Spce-user [mailto:spce-user-bounces at lists.sipwise.com] Per conto di Daniel Grotti
Inviato: giovedì 18 gennaio 2018 10.30
A: spce-user at lists.sipwise.com
Oggetto: Re: [Spce-user] Problem with rating
 
Hi Alessandro,
it seems that contract_balance entry is missing for that customer.
Please check the CDR, with:

> select * from accounting.cdr where id='621075';

then check contract balance for that source_account_id value:

> select * from billing.contract_balance where contract_id=<source_account_id>;


Is this account/customer still active?

Cheers,

Daniel



On 01/18/2018 10:07 AM, Alessandro Bolletta wrote:
Hi,
 
I have a spce community edition mr3.8x (now I upgraded it at 3.8.12), it runs in production for 2 years.
Now I have this problem. The rating engine is stuck at this error:
 
rate-o-mat: Error rating CDR batch: No contract balance for CDR 621075 found
 
I couldn’t figure out why, it is the first time that I see this message.
 
I just read in this mailing list that it is a contract balance related problem, and I also read that somebody advice to change the value of this field, but I don’t know how to do this.
 
--
Alessandro Bolletta
Mediaspot Srl
 
 




_______________________________________________Spce-user mailing listSpce-user at lists.sipwise.comhttps://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/20180123/ed9a263a/attachment-0001.html>