[Spce-user] rate-o-mat disabled. Not starting.
Theo
axessofficetheo at gmail.com
Wed Jul 23 08:35:22 EDT 2014
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> 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>
> 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>
>> 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>
>>> 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 listSpce-user at lists.sipwise.comhttps://lists.sipwise.com/listinfo/spce-user
>>>
>>>
>>>
>>> _______________________________________________
>>> Spce-user mailing list
>>> Spce-user at lists.sipwise.com
>>> https://lists.sipwise.com/listinfo/spce-user
>>>
>>>
>>
>>
>> _______________________________________________
>> Spce-user mailing list
>> 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/mailman/private/spce-user_lists.sipwise.com/attachments/20140723/acfbc8d1/attachment.html>
More information about the Spce-user
mailing list