<div dir="auto">Hi Razvan,</div><div dir="auto"><br></div><div dir="auto">Just fix the billing entry, I.e. create a rate for the prefix that fails and then restart rate-o-mat.  The cdr will then be populated in MySQL again. </div><div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, 10 Dec 2020 at 05:37, Razvan Radu <<a href="mailto:razvanf.radu@gmail.com">razvanf.radu@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hello everybody,<div><br></div><div>I just encountered a problem with rate-o-mat service, who failed because a prefix was not found on one of the providers we use.</div><div>However, the calls went through further without any problem. </div><div>We discovered this issue and fixed it but I noticed in mysql that we did not have the cdrs for the time rate-o-mat service was stopped.</div><div><br></div><div>Is there a way to retrieve those calls and have the cdr's for those missing calls as normal?</div><div>Has anybody encountered this issue before?</div><div><br></div><div>We are using sipwise CE mr7.5.4</div><div><br></div><div>Thank you,</div><div>Razvan R.</div></div><div dir="ltr"><div><br></div></div>
-- <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/mailman/listinfo/spce-user_lists.sipwise.com" rel="noreferrer" target="_blank">https://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com</a><br>
</blockquote></div></div>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><table border="0" cellspacing="0" cellpadding="0" width="346" style="font-family:Helvetica;width:259.8pt"><tbody><tr><td valign="top" style="padding:0cm"><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><br></div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman"">Warmest Regards,</div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><span style="color:purple"><a href="https://myrepublic.com.sg/" style="color:purple" target="_blank"><br><img border="0" width="140" height="92" src="https://myrepublic.com.sg/resources/email-signature.png"></a></span><span></span></div></td><td style="padding:0cm"><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><b><span style="font-size:10pt;font-family:Arial;color:rgb(127,43,153)">Walter Klomp</span></b><span></span></div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><span style="font-size:8.5pt;font-family:Arial;color:rgb(77,77,77)">Head of Voice & Systems</span><span></span></div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><span style="font-size:8.5pt;font-family:Arial;color:rgb(77,77,77)">MyRepublic Limited</span><span></span></div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><span style="font-size:8.5pt;font-family:Arial;color:rgb(77,77,77)">T: +65 6816 1120</span><span></span></div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><span style="font-size:8.5pt;font-family:Arial;color:rgb(77,77,77)">F: +65 6717 2031</span></div></td></tr><tr><td width="333" colspan="2" style="width:249.75pt;padding:0cm"><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""> <span></span></div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><span style="font-size:8.5pt;font-family:Arial;color:rgb(77,77,77)">MyRepublic Limited</span><span></span></div><div style="font-family:arial,sans-serif;font-size:16px;margin:0in 0in 0.0001pt"><font color="#4d4d4d" face="Arial, sans-serif"><span style="font-size:11.3333px">11 Lorong 3 Toa Payoh Block B Jackson Square</span></font></div><div style="font-family:arial,sans-serif;font-size:16px;margin:0in 0in 0.0001pt"><font color="#4d4d4d" face="Arial, sans-serif"><span style="font-size:11.3333px">#04-11/15 Singapore 319579</span></font></div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><span style="font-size:8.5pt;font-family:Arial;color:rgb(77,77,77)"><br></span><span style="color:rgb(77,77,77)"><a href="https://myrepublic.com.sg/" style="color:purple" target="_blank"><span style="font-size:8.5pt;font-family:Arial;color:rgb(77,77,77)">myrepublic.com.sg</span></a></span><span></span></div><div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:"Times New Roman""><span style="font-size:8.5pt;font-family:Arial;color:rgb(77,77,77)">Follow us on: <a href="https://twitter.com/myrepublic" style="color:purple" target="_blank"><span style="color:rgb(77,77,77)">Twitter</span></a> | <a href="https://facebook.com/myrepublicsg" style="color:purple" target="_blank"><span style="color:rgb(77,77,77)">Facebook</span></a> | <a href="https://www.linkedin.com/company/myrepublic" style="color:purple" target="_blank"><span style="color:rgb(5,99,193)">LinkedIn</span></a></span></div></td></tr></tbody></table><div style="color:rgb(0,0,0);font-family:Helvetica;font-size:14px"><br></div><table border="0" cellspacing="0" cellpadding="0" width="400" style="font-family:Helvetica;width:259.8pt"><tbody><tr><td valign="top" style="padding:0in"><br></td></tr></tbody></table></div></div>

<br>
<span style="color:rgb(34,34,34);font-family:sans-serif;background-color:rgb(255,255,255)"><font size="1"><span style="font-family:Arial;color:rgb(102,102,102);font-style:italic;vertical-align:baseline;white-space:pre-wrap">The contents of this email and any attachments are confidential and may also be privileged. You must not disseminate the contents of this email and any attachments without permission of the sender. If you have received this email by mistake, please delete all copies and inform the sender immediately. You may refer to our company's Privacy Policy </span><span style="color:rgb(102,102,102);font-family:Arial;font-style:italic;vertical-align:baseline;white-space:pre-wrap"><a href="https://myrepublic.net/sg/legal/terms-of-use-policies/privacy-policy/" target="_blank">here</a></span><span style="font-family:Arial;color:rgb(102,102,102);font-style:italic;vertical-align:baseline;white-space:pre-wrap">.</span></font></span>