[Spce-user] rate-o-mat disabled. Not starting.
Theo
axessofficetheo at gmail.com
Wed Jul 23 15:56:26 EDT 2014
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> 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>
> 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/7ecd8a42/attachment.html>
More information about the Spce-user
mailing list