<div dir="ltr">Thanks to all, now is working rate-o-mat and the system is billing.<div><br></div><div>Resume:</div><div><br></div><div>Service rate-o-mat stopped because some users were eliminated with calls not billed (they had not been associated with any fee).</div>
<div><br></div><div>The solution was to manually delete records from MySql database "accounting"</div><div>that present problems.</div><div><br></div><div>example:</div><div><br></div>
<div>#<span style="color:rgb(0,0,0)">service ngcp-rate-o-mat start</span></div><div><span style="color:rgb(0,0,0)">#</span><span style="color:rgb(0,0,0)">rollback ineffective with AutoCommit enabled at /usr/sbin/rate-o-mat line </span><span style="color:rgb(0,0,0)">91. </span><span style="color:rgb(0,0,0)">rollback ineffective with AutoCommit enabled at /usr/sbin/rate-o-mat line </span><span style="color:rgb(0,0,0)">92. </span><span style="color:rgb(0,0,0)">Error rating CDR batch: No reseller info for user id </span><span style="color:rgb(0,0,0)">909d45f8-1b67-4b44-9655-27a8ccd755d5 found</span></div>
<div style><br></div><div style>MySql query:</div><div>delete from cdr where source_user_id="909d45f8-1b67-4b44-9655-27a8ccd755d5"<br></div><div><br></div><div><br></div><div><div><br></div></div><div class="gmail_extra">
<br><br><div class="gmail_quote">2013/3/17 Marcial Barrios <span dir="ltr"><<a href="mailto:marcial@tecnimoviles.com" target="_blank">marcial@tecnimoviles.com</a>></span><br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">Yes you were right I add the billing fees and work but this is like the story that never end. This is the new error message:<div><br></div><div><div> #rollback ineffective with AutoCommit enabled at /usr/sbin/rate-o-mat line 91.</div>
<div>
<div>rollback ineffective with AutoCommit enabled at /usr/sbin/rate-o-mat line 92.</div></div><div>Error rating CDR batch: No reseller info for user id 909d45f8-1b67-4b44-9655-27a8ccd755d5 found</div></div></div><div>
<div><div class="gmail_extra">
<br><br><div class="gmail_quote">2013/3/17 Daniel Grotti <span dir="ltr"><<a href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a>></span><br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div>Hi,<div>this means that you don't have any billing fees for calls to 0034*.</div><div>Please add a proper billing fees and restart rate-o-mat.</div><div><div><div><br></div><div>Daniel</div><div><br><br>
<br><font>Sent from Samsung Mobile</font> </div><br><br><br>Marcial Barrios <<a href="mailto:marcial@tecnimoviles.com" target="_blank">marcial@tecnimoviles.com</a>> wrote:<br><br><br><div dir="ltr">Hi Kevin, I do the following and works <div>
<br></div><div>update cdr set rating_status ="ok" where source_user_id="10d81223-c19c-4030-b2dd-429af4dd8376"<br></div><div><br></div><div>
but when I tried to </div><div><br></div><div>#service ngcp-rate-o-mat start<br></div><div><br></div><div>I have this other message:</div><div><br></div><div><div>rollback ineffective with AutoCommit enabled at /usr/sbin/rate-o-mat line 91.</div>
<div>rollback ineffective with AutoCommit enabled at /usr/sbin/rate-o-mat line 92.</div><div>Error rating CDR batch: No fee info for profile 2 and user '<a href="tel:0034922388318" value="+34922388318" target="_blank">0034922388318</a>' or domain '<a href="mailto:0034922388318@91.192.110.234" target="_blank">0034922388318@91.192.110.234</a>' found</div>
</div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/3/17 Kevin Masse <span dir="ltr"><<a href="mailto:kmasse@questblue.com" target="_blank">kmasse@questblue.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div lang="EN-US" link="blue" vlink="purple"><div><p class="">
<span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Are you using XML or SOAP to update subscribers? If so it is possible that you have deleted the subscriber before the rating process went over the CDRs. <u></u><u></u></span></p>
<p class=""><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><br>The only way to get your rating back running again is to update the accounting.cdr table manually by setting the rating_status to “ok” for source_subscriber_id=</span>10d81223-c19c-4030-b2dd-429af4dd8376<span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u><u></u></span></p>
<p class=""><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class=""><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class=""><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">If you are not using the XML or SOAP to update it still could be possible you deleted a subscriber before calls were rated.<u></u><u></u></span></p>
<p class=""><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class=""><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">This may have to be repeated a few times to get the status “ok” in all fields.<u></u><u></u></span></p>
<p class=""><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class=""><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Kevin<u></u><u></u></span></p>
<p class=""><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class=""><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class=""><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class=""><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<div style="border-style:solid none none;border-top-color:rgb(181,196,223);border-top-width:1pt;padding:3pt 0in 0in"><p class=""><b><span style="font-size:10pt;font-family:Tahoma,sans-serif">From:</span></b><span style="font-size:10pt;font-family:Tahoma,sans-serif"> <a href="mailto:spce-user-bounces@lists.sipwise.com" target="_blank">spce-user-bounces@lists.sipwise.com</a> [mailto:<a href="mailto:spce-user-bounces@lists.sipwise.com" target="_blank">spce-user-bounces@lists.sipwise.com</a>] <b>On Behalf Of </b>Marcial Barrios<br>
<b>Sent:</b> Sunday, March 17, 2013 12:07 PM<br><b>To:</b> Daniel Grotti; <a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a><br><b>Subject:</b> Re: [Spce-user] rate-o-mat<u></u><u></u></span></p>
</div><p class=""><u></u> <u></u></p><div><p class=""><u></u> <u></u></p><div><p class="" style="margin-bottom:12pt"><u></u> <u></u></p><div><div><p class="">2013/3/17 Marcial Barrios <<a href="mailto:marcial@tecnimoviles.com" target="_blank">marcial@tecnimoviles.com</a>><u></u><u></u></p>
<div><p class="">Hi, Daniel this is what rate-o-mat.log is saying:<u></u><u></u></p><div><p class=""><u></u> <u></u></p></div><div><div><p class="">Trying to connect to billing db...<u></u><u></u></p>
</div><div><p class="">Successfully connected to billing db...<u></u><u></u></p></div><div><p class="">Trying to connect to accounting db...<u></u><u></u></p></div><div><p class="">Successfully connected to accounting db...<u></u><u></u></p>
</div><div><p class="">Up and running.<u></u><u></u></p></div><div><p class="">rate cdr #13<u></u><u></u></p></div><div><p class="">No reseller info for user id 10d81223-c19c-4030-b2dd-429af4dd8376 found<u></u><u></u></p>
</div><div><p class="">Error rating CDR batch: No reseller info for user id 10d81223-c19c-4030-b2dd-429af4dd8376 found<u></u><u></u></p></div></div><div><p class=""><u></u> <u></u></p></div></div></div>
<div>
<div><div><p class="" style="margin-bottom:12pt"><u></u> <u></u></p><div><p class="">2013/3/17 Daniel Grotti <<a href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a>><u></u><u></u></p>
<div><div><p class="">Hi,<u></u><u></u></p><div><p class="">please check what /var/log/ngcp/rate-o-mat.log is saying.<u></u><u></u></p></div><div><p class=""><u></u> <u></u></p></div>
<div><p class="">Daniel<u></u><u></u></p></div><div><p class=""><br><br><br>Sent from Samsung Mobile <u></u><u></u></p></div></div><div><p class="" style="margin-bottom:12pt"><br><br><br>Marcial Barrios <<a href="mailto:marcial@tecnimoviles.com" target="_blank">marcial@tecnimoviles.com</a>> wrote:<br>
<br><u></u><u></u></p><div><div><div><p class=""><u></u> <u></u></p></div><div><p class="">No calls are rated. How can check if rate-o-mat is working properly?<u></u><u></u></p></div><p class="">
-- <u></u><u></u></p><div><p class=""><b>Marcial Barrios</b><u></u><u></u></p></div><div><p class=""><i>Administrador de Sistemas</i><u></u><u></u></p></div><div><p class=""><u></u><u></u></p></div>
</div><div><p class="">Móvil: <a href="tel:%28%2B34%29%20603%20053%20043" target="_blank">(+34) 603 053 043</a><u></u><u></u></p></div><div><div><p class=""> Tel: <a href="tel:%28%2B34%29%20902%20955%20290" target="_blank">(+34) 902 955 290</a><u></u><u></u></p>
</div><div><p class=""> Fax: <a href="tel:%28%2B34%29%20822%20201%20442" target="_blank">(+34) 822 201 442</a><u></u><u></u></p></div><div><p class="">email: <a href="mailto:marcial@tecnimoviles.com" target="_blank">marcial@tecnimoviles.com</a><u></u><u></u></p>
</div><div><p class=""> web: <a href="http://www.tecnimoviles.com/" target="_blank">www.tecnimoviles.com</a><u></u><u></u></p></div></div></div></div></div></div><div><p class=""><br><br clear="all">
<u></u><u></u></p><div><p class=""><u></u> <u></u></p></div><p class="">-- <u></u><u></u></p><div><p class=""><b>Marcial Barrios</b><u></u><u></u></p></div><div><p class=""><i>Administrador de Sistemas</i><u></u><u></u></p>
</div><div><p class=""><img border="0" width="200" height="57"><u></u><u></u></p></div><div><p class="">Móvil: <a href="tel:%28%2B34%29%20603%20053%20043" target="_blank">(+34) 603 053 043</a><u></u><u></u></p>
</div><div><p class=""> Tel: <a href="tel:%28%2B34%29%20902%20955%20290" target="_blank">(+34) 902 955 290</a><u></u><u></u></p></div><div><p class=""> Fax: <a href="tel:%28%2B34%29%20822%20201%20442" target="_blank">(+34) 822 201 442</a><u></u><u></u></p>
</div><div><p class="">email: <a href="mailto:marcial@tecnimoviles.com" target="_blank">marcial@tecnimoviles.com</a><u></u><u></u></p></div><div><p class=""> web: <a href="http://www.tecnimoviles.com/" target="_blank">www.tecnimoviles.com</a><u></u><u></u></p>
</div></div></div></div></div></div><div><p class=""><br><br clear="all"><u></u><u></u></p><div><p class=""><u></u> <u></u></p></div><p class="">-- <u></u><u></u></p><div><p class="">
<b>Marcial Barrios</b><u></u><u></u></p></div><div><p class=""><i>Administrador de Sistemas</i><u></u><u></u></p></div><div><p class=""><img border="0" width="200" height="57"><u></u><u></u></p></div><div>
<p class="">Móvil: <a href="tel:%28%2B34%29%20603%20053%20043" target="_blank">(+34) 603 053 043</a><u></u><u></u></p></div><div><p class=""> Tel: <a href="tel:%28%2B34%29%20902%20955%20290" target="_blank">(+34) 902 955 290</a><u></u><u></u></p>
</div><div><p class=""> Fax: <a href="tel:%28%2B34%29%20822%20201%20442" target="_blank">(+34) 822 201 442</a><u></u><u></u></p></div><div><p class="">email: <a href="mailto:marcial@tecnimoviles.com" target="_blank">marcial@tecnimoviles.com</a><u></u><u></u></p>
</div><div><p class=""> web: <a href="http://www.tecnimoviles.com/" target="_blank">www.tecnimoviles.com</a><u></u><u></u></p></div></div></div></div></div></div></blockquote></div><br><br clear="all"><div><br>
</div>
-- <br><div><b>Marcial Barrios</b></div><div><i>Administrador de</i><i> Sistemas</i></div><div><img src="http://tecnimoviles.com/wp-content/uploads/2012/10/cropped-cropped-headertecnimoviles1-e1351371092469.png" width="200" height="57"></div>
<div>Móvil: <a href="tel:%28%2B34%29%20603%20053%20043" value="+34603053043" target="_blank">(+34) 603 053 043</a></div><div> Tel: <a href="tel:%28%2B34%29%20902%20955%20290" value="+34902955290" target="_blank">(+34) 902 955 290</a></div>
<div> Fax: <a href="tel:%28%2B34%29%20822%20201%20442" value="+34822201442" target="_blank">(+34) 822 201 442</a></div><div>email: <a href="mailto:marcial@tecnimoviles.com" target="_blank">marcial@tecnimoviles.com</a></div>
<div> web: <a href="http://www.tecnimoviles.com/" target="_blank">www.tecnimoviles.com</a></div>
</div> </div></div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div><b>Marcial Barrios</b></div><div><i>Administrador de</i><i> Sistemas</i></div><div><img src="http://tecnimoviles.com/wp-content/uploads/2012/10/cropped-cropped-headertecnimoviles1-e1351371092469.png" width="200" height="57"></div>
<div>Móvil: <a href="tel:%28%2B34%29%20603%20053%20043" value="+34603053043" target="_blank">(+34) 603 053 043</a></div><div> Tel: <a href="tel:%28%2B34%29%20902%20955%20290" value="+34902955290" target="_blank">(+34) 902 955 290</a></div>
<div> Fax: <a href="tel:%28%2B34%29%20822%20201%20442" value="+34822201442" target="_blank">(+34) 822 201 442</a></div><div>email: <a href="mailto:marcial@tecnimoviles.com" target="_blank">marcial@tecnimoviles.com</a></div>
<div> web: <a href="http://www.tecnimoviles.com" target="_blank">www.tecnimoviles.com</a></div>
</div>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div><b>Marcial Barrios</b></div><div><i>Administrador de</i><i> Sistemas</i></div><div><img src="http://tecnimoviles.com/wp-content/uploads/2012/10/cropped-cropped-headertecnimoviles1-e1351371092469.png" width="200" height="57"></div>
<div>Móvil: <a href="tel:%28%2B34%29%20603%20053%20043" value="+34603053043" target="_blank">(+34) 603 053 043</a></div><div> Tel: <a href="tel:%28%2B34%29%20902%20955%20290" value="+34902955290" target="_blank">(+34) 902 955 290</a></div>
<div> Fax: <a href="tel:%28%2B34%29%20822%20201%20442" value="+34822201442" target="_blank">(+34) 822 201 442</a></div><div>email: <a href="mailto:marcial@tecnimoviles.com" target="_blank">marcial@tecnimoviles.com</a></div>
<div> web: <a href="http://www.tecnimoviles.com" target="_blank">www.tecnimoviles.com</a></div>
</div></div>