[Spce-user] rate-o-mat disabled. Not starting.
Daniel Grotti
dgrotti at sipwise.com
Wed Jul 23 08:32:16 EDT 2014
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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20140723/58f3da2f/attachment-0001.html>
More information about the Spce-user
mailing list