<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Open Sans";
panose-1:2 11 6 6 3 5 4 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Verdana","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:10.0pt;
font-family:"Verdana","sans-serif";}
span.E-MailFormatvorlage17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="DE-AT" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US">Hi!<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US">Maybe it helps, had a similar problem after upgrading to mr 3.2.2:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p style="mso-margin-top-alt:12.0pt;margin-right:0cm;margin-bottom:12.0pt;margin-left:0cm;line-height:15.75pt;background:white;vertical-align:baseline">
<span lang="EN-US" style="font-size:10.5pt;font-family:"Open Sans","sans-serif";color:#333333">Check if there is an entry for contract_id in billing.contract_balances for the contract_id referring to your cdr
</span><span lang="EN-US" style="font-family:"Arial","sans-serif"">401875</span><span lang="EN-US" style="font-size:10.5pt;font-family:"Open Sans","sans-serif";color:#333333">, if not insert one:<o:p></o:p></span></p>
<p style="mso-margin-top-alt:12.0pt;margin-right:0cm;margin-bottom:12.0pt;margin-left:0cm;line-height:15.75pt;background:white;vertical-align:baseline;outline: 0px;orphans: auto;text-align:start;widows: auto;-webkit-text-stroke-width: 0px;word-spacing:0px">
<span lang="EN-US" style="font-size:10.5pt;font-family:"Open Sans","sans-serif";color:#333333">insert into contract_balances VALUES(NULL,*contract_id*,0,0,0,0,’2013-10-01 00:00:00′,’2014-12-01 00:00:00′,NULL);<o:p></o:p></span></p>
<p style="mso-margin-top-alt:12.0pt;margin-right:0cm;margin-bottom:12.0pt;margin-left:0cm;line-height:15.75pt;background:white;vertical-align:baseline">
<span lang="EN-US" style="font-size:10.5pt;font-family:"Open Sans","sans-serif";color:#333333">Then:<o:p></o:p></span></p>
<p style="mso-margin-top-alt:12.0pt;margin-right:0cm;margin-bottom:12.0pt;margin-left:0cm;line-height:15.75pt;background:white;vertical-align:baseline">
<span lang="EN-US" style="font-size:10.5pt;font-family:"Open Sans","sans-serif";color:#333333;background:white">/etc/init.d/ngcp-rate-o-mat start</span><span lang="EN-US" style="font-size:10.5pt;font-family:"Open Sans","sans-serif";color:#333333"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US">regards<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-size:7.5pt;color:#080000"><o:p> </o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:7.5pt;color:#080000">mit freundlichen Grüßen<br>
best regards</span><span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:7.5pt;color:#080000">Martin Stix<o:p></o:p></span></b></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-size:7.5pt;color:#080000">CEO</span><span lang="EN-US" style="font-size:7.5pt;color:#080000"><br>
pluteus communication solutions<br>
</span><span style="font-size:7.5pt;color:#1F497D"><a href="mailto:ms@pluteus.at"><span lang="EN-US" style="color:#080000">ms@pluteus.at</span></a></span><span lang="EN-US" style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:7.5pt;color:#1F497D">www.pluteus.at</span><span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:7.5pt;color:#1F497D">Dampfsägestraße 17<br>
3300 Amstetten<br>
Austria<br>
</span><span style="font-size:7.5pt;color:#080000">tel.: +43 7472 28165 20<br>
fax.: +43 7472 28165 22</span><span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="DE" style="font-size:11.0pt;font-family:"Calibri","sans-serif"">Von:</span></b><span lang="DE" style="font-size:11.0pt;font-family:"Calibri","sans-serif""> Theo [mailto:axessofficetheo@gmail.com]
<br>
<b>Gesendet:</b> Donnerstag, 24. Juli 2014 08:08<br>
<b>An:</b> Dario D. Busso<br>
<b>Cc:</b> spce-user@lists.sipwise.com<br>
<b>Betreff:</b> Re: [Spce-user] rate-o-mat disabled. Not starting.<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Hi<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">The log is completely blank. However, we do know what causes it not to start:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif""> Error rating CDR batch: No contract balance for CDR 401875 found</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">Just not 100% sure how to fix it, and more importantly, what caused it.</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Thu, Jul 24, 2014 at 6:34 AM, Dario D. Busso <<a href="mailto:dbusso@sipwise.com" target="_blank">dbusso@sipwise.com</a>> wrote:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<p class="MsoNormal">Hi Theo,<br>
what does report the rate-o-mat in the log file rate-o-mat.log?<br>
<br>
Il 23/lug/2014 22:00 Theo <<a href="mailto:axessofficetheo@gmail.com">axessofficetheo@gmail.com</a>> ha scritto:<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal">><br>
> Hmm, the cdrs are back now, including the missing ones. No idea why they are now showing up? <br>
><br>
> 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 :-)?<br>
><br>
><br>
> On Wed, Jul 23, 2014 at 9:56 PM, Theo <<a href="mailto:axessofficetheo@gmail.com">axessofficetheo@gmail.com</a>> wrote:<br>
>><br>
>> Hi<br>
>><br>
>> I have updated 2.8 to the latest version. Rate o mat still fails to start for the same reason though?<br>
>><br>
>><br>
>> On Wed, Jul 23, 2014 at 2:35 PM, Theo <<a href="mailto:axessofficetheo@gmail.com">axessofficetheo@gmail.com</a>> wrote:<br>
>>><br>
>>> Hi Daniel<br>
>>><br>
>>> 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.<br>
>>><br>
>>> Cheers<br>
>>><br>
>>><br>
>>> On Wed, Jul 23, 2014 at 2:32 PM, Daniel Grotti <<a href="mailto:dgrotti@sipwise.com">dgrotti@sipwise.com</a>> wrote:<br>
>>>><br>
>>>> 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.<br>
>>>><br>
>>>> Daniel<br>
>>>><br>
>>>><br>
>>>><br>
>>>><br>
>>>><br>
>>>> On 07/23/2014 02:26 PM, Theo wrote:<br>
>>>>><br>
>>>>> I was close then with my amateur queries, but not close enough :-)<br>
>>>>><br>
>>>>> So I reckon this is the issue?:<br>
>>>>><br>
>>>>> 21 | 14 | 0 | 0 | 0 | 0 | 2013-04-01 00:00:00 | 2013-04-30 23:59:59 | NULL |<br>
>>>>> | 24 | 14 | 0 | 0 | 0 | 0 | 2013-05-01 00:00:00 | 2013-05-31 23:59:59 | NULL |<br>
>>>>> | 32 | 14 | 0 | 0 | 0 | 0 | 2013-06-01 00:00:00 | 2013-06-30 23:59:59 | NULL |<br>
>>>>> | 37 | 14 | 0 | 0 | 0 | 0 | 2013-07-01 00:00:00 | 2013-07-31 23:59:59 | NULL |<br>
>>>>> | 38 | 14 | 0 | 0 | 0 | 0 | 2013-08-01 00:00:00 | 2013-08-31 23:59:59 | NULL |<br>
>>>>> | 44 | 14 | 0 | 0 | 0 | 0 | 2013-09-01 00:00:00 | 2013-09-30 23:59:59 | NULL |<br>
>>>>> | 46 | 14 | 0 | 0 | 0 | 0 | 2013-10-01 00:00:00 | 2013-10-31 23:59:59 | NULL |<br>
>>>>> | 48 | 14 | 0 | 0 | 0 | 0 | 2013-11-01 00:00:00 | 2013-11-30 23:59:59 | NULL |<br>
>>>>> | 49 | 14 | 0 | 0 | 0 | 0 | 2013-12-01 00:00:00 | 2013-12-31 23:59:59 | NULL |<br>
>>>>> | 52 | 14 | 0 | 0 | 0 | 0 | 2014-01-01 00:00:00 | 2014-01-31 23:59:59 | NULL |<br>
>>>>> | 56 | 14 | 0 | 0 | 0 | 0 | 2014-03-01 00:00:00 | 2014-03-31 23:59:59 | NULL |<br>
>>>>> | 58 | 14 | 0 | 0 | 0 | 0 | 2014-04-01 00:00:00 | 2014-04-30 23:59:59 | NULL |<br>
>>>>> | 60 | 14 | 0 | 0 | 0 | 0 | 2014-05-01 00:00:00 | 2014-05-31 23:59:59 | NULL |<br>
>>>>> | 62 | 14 | 0 | 0 | 0 | 0 | 2014-06-01 00:00:00 | 2014-06-30 23:59:59 | NULL |<br>
>>>>> | 63 | 14 | 0 | 0 | 0 | 0 | 2014-07-01 00:00:00 | 2014-07-31 23:59:59 | NULL |<br>
>>>>><br>
>>>>> 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?<br>
>>>>><br>
>>>>><br>
>>>>> On Wed, Jul 23, 2014 at 2:17 PM, Daniel Grotti <<a href="mailto:dgrotti@sipwise.com">dgrotti@sipwise.com</a>> wrote:<br>
>>>>>><br>
>>>>>> 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.<br>
>>>>>><br>
>>>>>> Daniel<br>
>>>>>><br>
>>>>>><br>
>>>>>><br>
>>>>>><br>
>>>>>><br>
>>>>>> On 07/23/2014 02:10 PM, Theo wrote:<br>
>>>>>>><br>
>>>>>>> Hi Daniel<br>
>>>>>>><br>
>>>>>>> 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:<br>
>>>>>>><br>
>>>>>>> Still struggling to get past my error. <br>
>>>>>>><br>
>>>>>>> Error rating CDR batch: No contract balance for CDR 401875 found<br>
>>>>>>><br>
>>>>>>> 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?<br>
>>>>>>><br>
>>>>>>> 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.<br>
>>>>>>><br>
>>>>>>> Thanks a lot!<br>
>>>>>>><br>
>>>>>>><br>
>>>>>>> On Wed, Jul 23, 2014 at 2:06 PM, Daniel Grotti <<a href="mailto:dgrotti@sipwise.com">dgrotti@sipwise.com</a>> wrote:<br>
>>>>>>>><br>
>>>>>>>> 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<br>
>>>>>>>><br>
>>>>>>>><br>
>>>>>>>><br>
>>>>>>>><br>
>>>>>>>><br>
>>>>>>>> On 07/23/2014 11:41 AM, Theo wrote:<br>
>>>>>>>>><br>
>>>>>>>>> Ok I found the rate o mat config file and it had: RATEOMAT_RUN=no<br>
>>>>>>>>><br>
>>>>>>>>> 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?<br>
>>>>>>>>><br>
>>>>>>>>><br>
>>>>>>>>> On Wed, Jul 23, 2014 at 11:34 AM, Theo <<a href="mailto:axessofficetheo@gmail.com">axessofficetheo@gmail.com</a>> wrote:<br>
>>>>>>>>>><br>
>>>>>>>>>> Hi<br>
>>>>>>>>>><br>
>>>>>>>>>> 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:<br>
>>>>>>>>>><br>
>>>>>>>>>> rate-o-mat disabled. Not starting.<br>
>>>>>>>>>><br>
>>>>>>>>>> /var/log/ngcp/rate-o-mat.log is empty<br>
>>>>>>>>>><br>
>>>>>>>>>> Any ideas?<br>
>>>>>>>>>><br>
>>>>>>>>>> Thanks a lot in advance<br>
>>>>>>>>><br>
>>>>>>>>><br>
>>>>>>>>><br>
>>>>>>>>><br>
>>>>>>>>> _______________________________________________<br>
>>>>>>>>><br>
>>>>>>>>> Spce-user mailing list<br>
>>>>>>>>><br>
>>>>>>>>> <a href="mailto:Spce-user@lists.sipwise.com">Spce-user@lists.sipwise.com</a><br>
>>>>>>>>><br>
>>>>>>>>> <a href="https://lists.sipwise.com/listinfo/spce-user" target="_blank">
https://lists.sipwise.com/listinfo/spce-user</a><br>
>>>>>>>>><br>
>>>>>>>><br>
>>>>>>>><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>
>>>>>>><br>
>>>>>><br>
>>>>>><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>
>>>>><br>
>>>><br>
>>><br>
>><br>
><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><o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</body>
</html>