<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 style>
but when I tried to </div><div style><br></div><div style>#service ngcp-rate-o-mat start<br></div><div style><br></div><div style>I have this other message:</div><div style><br></div><div style><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 '0034922388318' or domain '<a href="mailto:0034922388318@91.192.110.234">0034922388318@91.192.110.234</a>' found</div>
</div><div style><br></div><div style><br></div><div style><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:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-US" link="blue" vlink="purple"><div><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">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="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><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:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">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="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">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="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Kevin<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0in 0in 0in"><p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;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="MsoNormal"><u></u> <u></u></p><div><p class="MsoNormal"><u></u> <u></u></p><div><p class="MsoNormal" style="margin-bottom:12.0pt"><u></u> <u></u></p><div><div class="im"><p class="MsoNormal">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="MsoNormal">Hi, Daniel this is what rate-o-mat.log is saying:<u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></p></div><div><div><p class="MsoNormal">Trying to connect to billing db...<u></u><u></u></p>
</div><div><p class="MsoNormal">Successfully connected to billing db...<u></u><u></u></p></div><div><p class="MsoNormal">Trying to connect to accounting db...<u></u><u></u></p></div><div><p class="MsoNormal">Successfully connected to accounting db...<u></u><u></u></p>
</div><div><p class="MsoNormal">Up and running.<u></u><u></u></p></div><div><p class="MsoNormal">rate cdr #13<u></u><u></u></p></div><div><p class="MsoNormal">No reseller info for user id 10d81223-c19c-4030-b2dd-429af4dd8376 found<u></u><u></u></p>
</div><div><p class="MsoNormal">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="MsoNormal"><u></u> <u></u></p></div></div></div><div>
<div><div><p class="MsoNormal" style="margin-bottom:12.0pt"><u></u> <u></u></p><div><p class="MsoNormal">2013/3/17 Daniel Grotti <<a href="mailto:dgrotti@sipwise.com" target="_blank">dgrotti@sipwise.com</a>><u></u><u></u></p>
<div><div class="im"><p class="MsoNormal">Hi,<u></u><u></u></p><div><p class="MsoNormal">please check what /var/log/ngcp/rate-o-mat.log is saying.<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div>
<div><p class="MsoNormal">Daniel<u></u><u></u></p></div><div><p class="MsoNormal"><br><br><br>Sent from Samsung Mobile <u></u><u></u></p></div></div><div><p class="MsoNormal" style="margin-bottom:12.0pt"><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 class="im"><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">No calls are rated. How can check if rate-o-mat is working properly?<u></u><u></u></p></div><p class="MsoNormal">
-- <u></u><u></u></p><div><p class="MsoNormal"><b>Marcial Barrios</b><u></u><u></u></p></div><div><p class="MsoNormal"><i>Administrador de Sistemas</i><u></u><u></u></p></div><div><p class="MsoNormal"><u></u><u></u></p></div>
</div><div><p class="MsoNormal">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 class="im"><div><p class="MsoNormal"> 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="MsoNormal"> 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="MsoNormal">email: <a href="mailto:marcial@tecnimoviles.com" target="_blank">marcial@tecnimoviles.com</a><u></u><u></u></p>
</div><div><p class="MsoNormal"> 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 class="im"><p class="MsoNormal"><br><br clear="all">
<u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></p></div><p class="MsoNormal">-- <u></u><u></u></p><div><p class="MsoNormal"><b>Marcial Barrios</b><u></u><u></u></p></div><div><p class="MsoNormal"><i>Administrador de Sistemas</i><u></u><u></u></p>
</div><div><p class="MsoNormal"><img border="0" width="200" height="57"><u></u><u></u></p></div><div><p class="MsoNormal">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="MsoNormal"> 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="MsoNormal"> 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="MsoNormal">email: <a href="mailto:marcial@tecnimoviles.com" target="_blank">marcial@tecnimoviles.com</a><u></u><u></u></p></div><div><p class="MsoNormal"> 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 class="im"><p class="MsoNormal"><br><br clear="all"><u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></p></div><p class="MsoNormal">-- <u></u><u></u></p><div><p class="MsoNormal">
<b>Marcial Barrios</b><u></u><u></u></p></div><div><p class="MsoNormal"><i>Administrador de Sistemas</i><u></u><u></u></p></div><div><p class="MsoNormal"><img border="0" width="200" height="57"><u></u><u></u></p></div><div>
<p class="MsoNormal">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="MsoNormal"> 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="MsoNormal"> 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="MsoNormal">email: <a href="mailto:marcial@tecnimoviles.com" target="_blank">marcial@tecnimoviles.com</a><u></u><u></u></p>
</div><div><p class="MsoNormal"> 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: (+34) 603 053 043</div><div> Tel: (+34) 902 955 290</div><div> Fax: (+34) 822 201 442</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>