<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi!<br>
<br>
I has solved the issue, with a drastic solution but the rate-o-mat
service works fine.<br>
<br>
The problem was that on 7th of September rate-o-mat stops because a
destination hasn't been found on billing fees. On 20 of September I
deleted a Subscriber and your Account ID. <br>
<br>
Yesterday I saw that the rate-o-mat service was stopped and I try to
start it, but I have the next error:<br>
Error rating CDR batch: No contract id found for uuid
'7cb9097d-aece-469f-88ec-02359a17b203'<br>
<br>
Then I try to update de database for set 'unrated' cdr to 'ok':<br>
update accounting.cdr set rating_status = 'ok' where source_user_id
= '7cb9097d-aece-469f-88ec-02359a17b203';<br>
<br>
And I try to start again rate-o-mat service, but the error was the
same... <br>
<br>
Finally, I try to update all the CDRs to 'ok' (like a drastic
measure) to try to up the rate-o-mat service:<br>
update cdr set rating_status = 'ok';<br>
<br>
Try again to start rate-o-mat service and it works fine again.<br>
<br>
To prevent this on the future I think to write a small script for
read rate-o-mat log and when it detects that a billing feed doesn't
exist it send me a e-mail. Has Sipwise a mechanism to advertise that
a feed doesn't exist?<br>
<br>
<div class="moz-signature">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<title></title>
<font size="-1"><font face="Calibri">Saludos,</font></font><span
style="font-size:8.0pt;font-family:"Arial
Narrow",sans-serif;
color:#17365D;mso-ansi-language:CA;mso-fareast-language:ES"
lang="CA"></span><br>
</div>
Robert Cuaresma.<br>
<blockquote type="cite"
cite="mid:0ebe7759-8d58-c0b5-b3d9-f7609e1a8da5@telcon.es">
<div><font size="-1"><font face="Calibri">
<br>
I have a problem with a rate-o-mat service. If I try to
start I have this error:<br>
Error rating CDR batch: No contract id found for uuid
'7cb9097d-aece-469f-88ec-02359a17b203'<br>
<br>
In witch mysql table does SipWise store the calls with the
UUID? I don't know how to find the call with this UUID
because I don't know wich subscriber could make the call.<br>
<br>
Thanks!<br>
<br>
</font></font>
<div class="moz-signature">-- <br>
<font size="-1"><font face="Calibri">Robert Cuaresma.</font></font><span
style="font-size:8.0pt;font-family:"Arial
Narrow",sans-serif;
color:#17365D;mso-ansi-language:CA;mso-fareast-language:ES"
lang="CA"></span><br>
</div>
</div>
<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>