<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>