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