[Spce-user] Error rating CDR batch: No provider info for provider id 5 found

[Daniel Speichert]

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?

Best Regards,
Daniel Speichert

On 2012-08-29 01:21, Andreas Granig wrote:
> Hi Daniel,
>
> On 08/15/2012 01:47 PM, Daniel Speichert wrote:
>> 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 at sip:~# 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
> 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
>
>
>
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/listinfo/spce-user

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20120830/e4490109/attachment-0001.html>