<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">I noticed that some peering groups were
linked to non existent contracts (I don't know how it may have
happened). Now I linked them to proper, existing contracts but the
problem is not solved. Probably the old link is preserved for old
records. How can I change that?<br>
<pre class="moz-signature" cols="72">Best Regards,
Daniel Speichert</pre>
On 2012-08-29 01:21, Andreas Granig wrote:<br>
</div>
<blockquote cite="mid:503D5271.9080405@sipwise.com" type="cite">
<pre wrap="">Hi Daniel,
On 08/15/2012 01:47 PM, Daniel Speichert wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I have some error in the database that makes rate-o-mat throw a fatal error.
The message of it is below, I just don't know what "provider" is it
complaining about as the words used in www_admin are quite different.
root@<a class="moz-txt-link-freetext" href="sip:~#">sip:~#</a> rollback ineffective with AutoCommit enabled at
/usr/sbin/rate-o-mat line 90.
rollback ineffective with AutoCommit enabled at /usr/sbin/rate-o-mat
line 91.
Error rating CDR batch: No provider info for provider id 5 found
</pre>
</blockquote>
<pre wrap="">
The provider info is the billing contract for the
destination_provider_id column in the CDR, which must therefore be a
valid billing contract id. Do you have a billing contract with id 5? If
not (maybe you deleted it, and if so, how?) then you need to manually
set the rating_status to 'ok' or 'failed' for the CDRs in question. You
must never delete a billing contract from the DB if there are still
unrated CDRs for this contract.
Andreas
</pre>
<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="http://lists.sipwise.com/listinfo/spce-user">http://lists.sipwise.com/listinfo/spce-user</a>
</pre>
</blockquote>
<br>
</body>
</html>