[Spce-user] Outgoing CDR Records

[Kevin Masse]

Andreas I have provided the following based on your request.  Additionally I did not manually edit any of the database files.

mysql> select * FROM contracts where id='7f7c19f9-92d2-432b-a845-fbeea01727a8'\G
*************************** 1. row ***************************
                 id: 7
        customer_id: NULL
        reseller_id: 1
         contact_id: NULL
           order_id: NULL
             status: active
        external_id: fpbx
   modify_timestamp: 2012-12-26 15:01:22
   create_timestamp: 2012-12-26 15:01:22
 activate_timestamp: 2012-12-26 15:01:22
terminate_timestamp: NULL
1 row in set, 1 warning (0.00 sec)


mysql> select * from billing.contracts where id=1\G
*************************** 1. row ***************************
                 id: 1
        customer_id: NULL
        reseller_id: NULL
         contact_id: NULL
           order_id: NULL
             status: active
        external_id: NULL
   modify_timestamp: 0000-00-00 00:00:00
   create_timestamp: 0000-00-00 00:00:00
 activate_timestamp: 0000-00-00 00:00:00
terminate_timestamp: NULL
1 row in set (0.00 sec)

Contracact to Billing Profile looks good.  1

Does the above info help?

Kevin


-----Original Message-----
From: spce-user-bounces at lists.sipwise.com [mailto:spce-user-bounces at lists.sipwise.com] On Behalf Of Andreas Granig
Sent: Friday, February 08, 2013 1:30 PM
To: spce-user at lists.sipwise.com
Subject: Re: [Spce-user] Outgoing CDR Records

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

_______________________________________________
Spce-user mailing list
Spce-user at lists.sipwise.com
http://lists.sipwise.com/listinfo/spce-user