<div dir="ltr">Hi Daniel<div><br></div><div>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.</div>
<div><br></div><div>Cheers</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Jul 23, 2014 at 2:32 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>
we had some issue for missing entries in billing_mapping, and we
fixed some problem.<br>
Please update to the latest release packages.<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:26 PM, Theo wrote:<br>
</div></div></div><div><div class="h5">
<blockquote type="cite">
<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><font color="#888888"><br>
<br>
Daniel</font></span>
<div>
<div><br>
<br>
<br>
<br>
<br>
On 07/23/2014 02:10 PM, Theo wrote:<br>
</div>
</div>
</div>
<div>
<div>
<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" 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>
</blockquote></div><br></div>