[Spce-user] rate-o-mat disabled. Not starting.
Theo
axessofficetheo at gmail.com
Thu Jul 24 02:07:53 EDT 2014
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> 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> 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> 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>
> 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 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
> >>>>>>>>
> >>>>>>>
> >>>>>>
> >>>>>>
> >>>>>> _______________________________________________
> >>>>>> 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/20140724/de908afc/attachment.html>
More information about the Spce-user
mailing list