<div dir="ltr">I was close then with my amateur queries, but not close enough :-)<div><br></div><div>So I reckon this is the issue?:</div><div><br></div><div><span style="font-family:arial,sans-serif;font-size:13px"> </span><font face="arial, sans-serif"> 21 | 14 | 0 | 0 | 0 | 0 | 2013-04-01 00:00:00 | 2013-04-30 23:59:59 | NULL |<br>
</font></div><div><font face="arial, sans-serif">| 24 | 14 | 0 | 0 | 0 | 0 | 2013-05-01 00:00:00 | 2013-05-31 23:59:59 | NULL |</font></div>
<div><font face="arial, sans-serif">| 32 | 14 | 0 | 0 | 0 | 0 | 2013-06-01 00:00:00 | 2013-06-30 23:59:59 | NULL |</font></div><div><font face="arial, sans-serif">| 37 | 14 | 0 | 0 | 0 | 0 | 2013-07-01 00:00:00 | 2013-07-31 23:59:59 | NULL |</font></div>
<div><font face="arial, sans-serif">| 38 | 14 | 0 | 0 | 0 | 0 | 2013-08-01 00:00:00 | 2013-08-31 23:59:59 | NULL |</font></div><div><font face="arial, sans-serif">| 44 | 14 | 0 | 0 | 0 | 0 | 2013-09-01 00:00:00 | 2013-09-30 23:59:59 | NULL |</font></div>
<div><font face="arial, sans-serif">| 46 | 14 | 0 | 0 | 0 | 0 | 2013-10-01 00:00:00 | 2013-10-31 23:59:59 | NULL |</font></div><div><font face="arial, sans-serif">| 48 | 14 | 0 | 0 | 0 | 0 | 2013-11-01 00:00:00 | 2013-11-30 23:59:59 | NULL |</font></div>
<div><font face="arial, sans-serif">| 49 | 14 | 0 | 0 | 0 | 0 | 2013-12-01 00:00:00 | 2013-12-31 23:59:59 | NULL |</font></div><div><font face="arial, sans-serif">| 52 | 14 | 0 | 0 | 0 | 0 | 2014-01-01 00:00:00 | 2014-01-31 23:59:59 | NULL |</font></div>
<div><font face="arial, sans-serif">| 56 | 14 | 0 | 0 | 0 | 0 | 2014-03-01 00:00:00 | 2014-03-31 23:59:59 | NULL |</font></div><div><font face="arial, sans-serif">| 58 | 14 | 0 | 0 | 0 | 0 | 2014-04-01 00:00:00 | 2014-04-30 23:59:59 | NULL |</font></div>
<div><font face="arial, sans-serif">| 60 | 14 | 0 | 0 | 0 | 0 | 2014-05-01 00:00:00 | 2014-05-31 23:59:59 | NULL |</font></div><div><font face="arial, sans-serif">| 62 | 14 | 0 | 0 | 0 | 0 | 2014-06-01 00:00:00 | 2014-06-30 23:59:59 | NULL |</font></div>
<div><font face="arial, sans-serif">| 63 | 14 | 0 | 0 | 0 | 0 | 2014-07-01 00:00:00 | 2014-07-31 23:59:59 | NULL |</font></div><div><font face="arial, sans-serif"><br>
</font></div><div><font face="arial, sans-serif">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?</font></div>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Jul 23, 2014 at 2:17 PM, Daniel Grotti <span dir="ltr"><<a href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>Hi,<br>
go to mysql:<br>
<br>
<br>
> select * from accounting.cdr where id=401875\G;<br>
<br>
then:<br>
<br>
> select * from billing.contract_balances where
contract_id=<cdr.source_account_id>;<br>
> select * from billing.billing_mappings where
contract_id=<cdr.source_account_id>;<br>
<br>
You should have a result from those.<br>
If not, the contract is missing, which means that customer has no
billing profile.<span class="HOEnZb"><font color="#888888"><br>
<br>
Daniel</font></span><div><div class="h5"><br>
<br>
<br>
<br>
<br>
On 07/23/2014 02:10 PM, Theo wrote:<br>
</div></div></div><div><div class="h5">
<blockquote type="cite">
<div dir="ltr">Hi Daniel
<div><br>
</div>
<div>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:</div>
<div><br>
</div>
<div>
<div>Still struggling to get past my error. </div>
<div><br>
</div>
<div> Error rating CDR batch: No contract balance for CDR
401875 found</div>
<div><br>
</div>
<div>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?</div>
</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Thanks a lot!</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Wed, Jul 23, 2014 at 2:06 PM, Daniel
Grotti <span dir="ltr"><<a href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>Hi,<br>
Are you sure you didn't touch your config.yml file ?<br>
<br>
rateomat:<br>
enable: 'no'<br>
loopinterval: 10<br>
splitpeakparts: 0<br>
<br>
<br>
<br>
Daniel
<div>
<div><br>
<br>
<br>
<br>
<br>
On 07/23/2014 11:41 AM, Theo wrote:<br>
</div>
</div>
</div>
<blockquote type="cite">
<div>
<div>
<div dir="ltr">Ok I found the rate o mat config file
and it had: RATEOMAT_RUN=no
<div><br>
</div>
<div>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?</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Wed, Jul 23, 2014 at
11:34 AM, Theo <span dir="ltr"><<a href="mailto:axessofficetheo@gmail.com" target="_blank">axessofficetheo@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Hi
<div><br>
</div>
<div>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:</div>
<div><br>
</div>
<div>
<div>rate-o-mat disabled. Not starting.</div>
</div>
<div><br>
</div>
<div>
<div>/var/log/ngcp/rate-o-mat.log is empty</div>
</div>
<div><br>
</div>
<div>Any ideas?</div>
<div><br>
</div>
<div>Thanks a lot in advance</div>
</div>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset></fieldset>
<br>
</div>
</div>
<pre>_______________________________________________
Spce-user mailing list
<a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a>
<a href="https://lists.sipwise.com/listinfo/spce-user" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a>
</pre>
</blockquote>
<br>
</div>
<br>
_______________________________________________<br>
Spce-user mailing list<br>
<a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br>
<a href="https://lists.sipwise.com/listinfo/spce-user" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</div></div></div>
<br>_______________________________________________<br>
Spce-user mailing list<br>
<a href="mailto:Spce-user@lists.sipwise.com">Spce-user@lists.sipwise.com</a><br>
<a href="https://lists.sipwise.com/listinfo/spce-user" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a><br>
<br></blockquote></div><br></div>