[Spce-user] rate-o-mat disabled. Not starting.

[Daniel Grotti]

Hi,
go to mysql:


> select * from accounting.cdr where id=401875\G;

then:

> select * from billing.contract_balances where
contract_id=<cdr.source_account_id>;
> select * from billing.billing_mappings where
contract_id=<cdr.source_account_id>;

You should have a result from those.
If not, the contract is missing, which means that customer has no
billing profile.

Daniel




On 07/23/2014 02:10 PM, Theo wrote:
> Hi Daniel
>
> I set this up over a year ago, so possibly I did. I can't really think
> of a reason why I would have but will check that. In the meantime:
>
> Still struggling to get past my error. 
>
>  Error rating CDR batch: No contract balance for CDR 401875 found
>
> I have found the other posts regarding this issue but am not quite
> getting it. I understand this is related to the contract balance. My
> first step is to find out to which contract this belongs. I am not
> succeeding with that but that's mostly because I am not familiar
> enough with msql I am sure. Could someone help me with the exact steps
> to identify the contract id this belongs to?
>
> Incidentally we are not yet using the rating at all, but we do need
> the cdrs to show up in the webinterface. However, we intend switching
> on the rating soonish.
>
> Thanks a lot!
>
>
> On Wed, Jul 23, 2014 at 2:06 PM, Daniel Grotti <dgrotti at sipwise.com
> <mailto:dgrotti at sipwise.com>> wrote:
>
>     Hi,
>     Are you sure you didn't touch your config.yml file ?
>
>     rateomat:
>       enable: 'no'
>       loopinterval: 10
>       splitpeakparts: 0
>
>
>
>     Daniel
>
>
>
>
>
>     On 07/23/2014 11:41 AM, Theo wrote:
>>     Ok I found the rate o mat config file and it had: RATEOMAT_RUN=no
>>
>>     which I changed to yes. Still have an error but at least it's
>>     attempting to start now. Will try and solve the error first, but
>>     why would this have been set to no? I cannot remember ever
>>     touching this file?
>>
>>
>>     On Wed, Jul 23, 2014 at 11:34 AM, Theo <axessofficetheo at gmail.com
>>     <mailto:axessofficetheo at gmail.com>> wrote:
>>
>>         Hi
>>
>>         After a reboot of our system our cdrs are not generated. This
>>         would be because rate o mat is not running, but when trying
>>         to start I get:
>>
>>         rate-o-mat disabled. Not starting.
>>
>>         /var/log/ngcp/rate-o-mat.log is empty
>>
>>         Any ideas?
>>
>>         Thanks a lot in advance
>>
>>
>>
>>
>>     _______________________________________________
>>     Spce-user mailing list
>>     Spce-user at lists.sipwise.com <mailto:Spce-user at lists.sipwise.com>
>>     https://lists.sipwise.com/listinfo/spce-user
>
>
>     _______________________________________________
>     Spce-user mailing list
>     Spce-user at lists.sipwise.com <mailto:Spce-user at lists.sipwise.com>
>     https://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/20140723/500943f6/attachment-0001.html>