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

Martin Stix ms at pluteus.at
Thu Jul 24 02:25:48 EDT 2014


Hi!

Maybe it helps, had a similar problem after upgrading to mr 3.2.2:


Check if there is an entry for contract_id in billing.contract_balances for the contract_id referring to your cdr 401875, if not insert one:

insert into contract_balances VALUES(NULL,*contract_id*,0,0,0,0,’2013-10-01 00:00:00′,’2014-12-01 00:00:00′,NULL);

Then:

/etc/init.d/ngcp-rate-o-mat start

regards

mit freundlichen Grüßen
best regards
Martin Stix
CEO
pluteus communication solutions
ms at pluteus.at<mailto:ms at pluteus.at>
www.pluteus.at
Dampfsägestraße 17
3300 Amstetten
Austria
tel.: +43 7472 28165 20
fax.: +43 7472 28165 22

Von: Theo [mailto:axessofficetheo at gmail.com]
Gesendet: Donnerstag, 24. Juli 2014 08:08
An: Dario D. Busso
Cc: spce-user at lists.sipwise.com
Betreff: Re: [Spce-user] rate-o-mat disabled. Not starting.

Hi

The log is completely blank. However, we do know what causes it not to start:
 Error rating CDR batch: No contract balance for CDR 401875 found

Just not 100% sure how to fix it, and more importantly, what caused it.


On Thu, Jul 24, 2014 at 6:34 AM, Dario D. Busso <dbusso at sipwise.com<mailto:dbusso at sipwise.com>> wrote:
Hi Theo,
what does report the rate-o-mat in the log file rate-o-mat.log?

Il 23/lug/2014 22:00 Theo <axessofficetheo at gmail.com<mailto:axessofficetheo at gmail.com>> ha scritto:
>
> Hmm, the cdrs are back now, including the missing ones. No idea why  they are now showing up?
>
> Just rate o mat that's not starting. As mentioned, we're not rating at this point so it's not affecting anything, but we want to start looking at rating calls through sipwise so we'd better get rate o mat going :-)?
>
>
> On Wed, Jul 23, 2014 at 9:56 PM, Theo <axessofficetheo at gmail.com<mailto:axessofficetheo at gmail.com>> wrote:
>>
>> Hi
>>
>> I have updated 2.8 to the latest version. Rate o mat still fails to start for the same reason though?
>>
>>
>> On Wed, Jul 23, 2014 at 2:35 PM, Theo <axessofficetheo at gmail.com<mailto:axessofficetheo at gmail.com>> wrote:
>>>
>>> Hi Daniel
>>>
>>> I will do so tonight when things are quiet and let you know if it fixed the issue. I am on the 2.8Lt version currently which truth-be-told has not been updated for a while so let's.
>>>
>>> Cheers
>>>
>>>
>>> On Wed, Jul 23, 2014 at 2:32 PM, Daniel Grotti <dgrotti at sipwise.com<mailto:dgrotti at sipwise.com>> wrote:
>>>>
>>>> Hi,
>>>> we had some issue for missing entries in billing_mapping, and we fixed some problem.
>>>> Please update to the latest release packages.
>>>>
>>>> Daniel
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On 07/23/2014 02:26 PM, Theo wrote:
>>>>>
>>>>> I was close then with my amateur queries, but not close enough :-)
>>>>>
>>>>> So I reckon this is the issue?:
>>>>>
>>>>>   21 |          14 |            0 |                     0 |                 0 |                          0 | 2013-04-01 00:00:00 | 2013-04-30 23:59:59 |       NULL |
>>>>> | 24 |          14 |            0 |                     0 |                 0 |                          0 | 2013-05-01 00:00:00 | 2013-05-31 23:59:59 |       NULL |
>>>>> | 32 |          14 |            0 |                     0 |                 0 |                          0 | 2013-06-01 00:00:00 | 2013-06-30 23:59:59 |       NULL |
>>>>> | 37 |          14 |            0 |                     0 |                 0 |                          0 | 2013-07-01 00:00:00 | 2013-07-31 23:59:59 |       NULL |
>>>>> | 38 |          14 |            0 |                     0 |                 0 |                          0 | 2013-08-01 00:00:00 | 2013-08-31 23:59:59 |       NULL |
>>>>> | 44 |          14 |            0 |                     0 |                 0 |                          0 | 2013-09-01 00:00:00 | 2013-09-30 23:59:59 |       NULL |
>>>>> | 46 |          14 |            0 |                     0 |                 0 |                          0 | 2013-10-01 00:00:00 | 2013-10-31 23:59:59 |       NULL |
>>>>> | 48 |          14 |            0 |                     0 |                 0 |                          0 | 2013-11-01 00:00:00 | 2013-11-30 23:59:59 |       NULL |
>>>>> | 49 |          14 |            0 |                     0 |                 0 |                          0 | 2013-12-01 00:00:00 | 2013-12-31 23:59:59 |       NULL |
>>>>> | 52 |          14 |            0 |                     0 |                 0 |                          0 | 2014-01-01 00:00:00 | 2014-01-31 23:59:59 |       NULL |
>>>>> | 56 |          14 |            0 |                     0 |                 0 |                          0 | 2014-03-01 00:00:00 | 2014-03-31 23:59:59 |       NULL |
>>>>> | 58 |          14 |            0 |                     0 |                 0 |                          0 | 2014-04-01 00:00:00 | 2014-04-30 23:59:59 |       NULL |
>>>>> | 60 |          14 |            0 |                     0 |                 0 |                          0 | 2014-05-01 00:00:00 | 2014-05-31 23:59:59 |       NULL |
>>>>> | 62 |          14 |            0 |                     0 |                 0 |                          0 | 2014-06-01 00:00:00 | 2014-06-30 23:59:59 |       NULL |
>>>>> | 63 |          14 |            0 |                     0 |                 0 |                          0 | 2014-07-01 00:00:00 | 2014-07-31 23:59:59 |       NULL |
>>>>>
>>>>> Looks like Feb is missing. Question of course is: why is it missing?  and what do I do about it? It's of no consequence right now because we don't use it for rating anyway but would love to understand the issue?
>>>>>
>>>>>
>>>>> On Wed, Jul 23, 2014 at 2:17 PM, Daniel Grotti <dgrotti at sipwise.com<mailto:dgrotti at sipwise.com>> wrote:
>>>>>>
>>>>>> 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
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> 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/20140724/104fd786/attachment-0001.html>


More information about the Spce-user mailing list