<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<tt>Hi Alessandro,<br>
it seems that contract_balance entry is missing for that customer.<br>
Please check the CDR, with:<br>
<br>
> select * from accounting.cdr where id='621075';<br>
<br>
then check contract balance for that source_account_id value:<br>
<br>
> select * from billing.contract_balance where contract_id=<</tt><tt><tt>source_account_id>;<br>
<br>
<br>
Is this account/customer still active?<br>
<br>
Cheers,<br>
<br>
Daniel<br>
<br>
<br>
<br>
<br>
</tt></tt>
<div class="moz-cite-prefix">On 01/18/2018 10:07 AM, Alessandro
Bolletta wrote:<br>
</div>
<blockquote type="cite"
cite="mid:6469203c-9bb0-4143-ac2e-848748e7886e@mediaspot.net">
<div style="font-family:Calibri, Arial, Helvetica, sans-serif;
font-size:12.0pt; line-height:1.3; color:#000000"><!-- ##### NINE BODY BEGIN ##### -->
<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;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-fareast-language:EN-US;} a:link, span.MsoHyperlink {mso-style-priority:99; color:#0563C1; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {mso-style-priority:99; color:#954F72; text-decoration:underline;} span.StileMessaggioDiPostaElettronica17 {mso-style-type:personal-compose; font-family:"Calibri",sans-serif; color:windowtext;} .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 2.0cm 2.0cm 2.0cm;} div.WordSection1 {page:WordSection1;} --></style>
<div lang="IT">
<div>
<p class="MsoNormal"><span lang="EN-US">Hi,</span><br>
</p>
<p class="MsoNormal"><span lang="EN-US"> </span><br>
</p>
<p class="MsoNormal"><span lang="EN-US">I have a spce
community edition mr3.8x (now I upgraded it at 3.8.12),
it runs in production for 2 years.</span><br>
</p>
<p class="MsoNormal"><span lang="EN-US">Now I have this
problem. The rating engine is stuck at this error:</span><br>
</p>
<p class="MsoNormal"><span lang="EN-US"> </span><br>
</p>
<p class="MsoNormal"><span lang="EN-US">rate-o-mat: Error
rating CDR batch: No contract balance for CDR 621075
found</span><br>
</p>
<p class="MsoNormal"><span lang="EN-US"> </span><br>
</p>
<p class="MsoNormal"><span lang="EN-US">I couldn’t figure
out why, it is the first time that I see this message.</span><br>
</p>
<p class="MsoNormal"><span lang="EN-US"> </span><br>
</p>
<p class="MsoNormal"><span lang="EN-US">I just read in this
mailing list that it is a contract balance related
problem, and I also read that somebody advice to change
the value of this field, but I don’t know how to do
this.</span><br>
</p>
<p class="MsoNormal"><span lang="EN-US"> </span><br>
</p>
<p class="MsoNormal">--<br>
</p>
<p class="MsoNormal">Alessandro Bolletta<br>
</p>
<p class="MsoNormal">Mediaspot Srl<br>
</p>
<p class="MsoNormal"> <br>
</p>
<p class="MsoNormal"><span lang="EN-US"> </span><br>
</p>
</div>
</div>
<!-- ##### NINE BODY END ##### --></div>
<br type="attribution">
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Spce-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Spce-user@lists.sipwise.com">Spce-user@lists.sipwise.com</a>
<a class="moz-txt-link-freetext" href="https://lists.sipwise.com/listinfo/spce-user">https://lists.sipwise.com/listinfo/spce-user</a>
</pre>
</blockquote>
<br>
</body>
</html>