[Spce-user] Outgoing CDR Records

[Andreas Granig]

On 02/05/2013 04:31 PM, Jon Bonilla (Manwe) wrote:
> El Wed, 30 Jan 2013 16:16:24 -0500
> "Kevin Masse" <kmasse at questblue.com> escribió:
>
>> It appears that I have found one particular issue:
>>
>> If I attempt to start the ngcp-rate-o-mat service see below:
>>
>> service ngcp-rate-o-mat start
>> /var/log/ngcp# rollback ineffective with AutoCommit enabled
>> at /usr/sbin/rate-o-mat line 91. rollback ineffective with AutoCommit enabled
>> at /usr/sbin/rate-o-mat line 92. Error rating CDR batch: No reseller info for
>> user id 7f7c19f9-92d2-432b-a845-fbeea01727a8 found
>>
>> I tried researching this particular error and I did not find anything in the
>> list, however I may have been searching for the wrong item.
>>
>> Kevin
>>
>>
>
> Could you check if that user's account has a billing profile asigned?

You also might want to post the following infos:

-- contract info of user
select * from billing.contracts where id=<account id of affected user>\G

-- contract info of "reseller" (id always 1, unless you messed with it)
select * from billing.contracts where id=1\G

Also check in billing.billing_mappings if there is a mapping for 
contract_id=1 to a billing_profile (for the dummy-reseller) and one for 
contract_id=<account id of affected user> to a billing_profile.

Andreas