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

[Theo]

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/pipermail/spce-user_lists.sipwise.com/attachments/20140723/8b50dbd5/attachment-0001.html>