[Spce-user] rate-o-mat

[Marcial Barrios]

Yes you were right I add the billing fees and work but this is like the
story that never end. This is the new error message:

 #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
909d45f8-1b67-4b44-9655-27a8ccd755d5 found


2013/3/17 Daniel Grotti <dgrotti at sipwise.com>

> Hi,
> this means that you don't have any billing fees for calls to 0034*.
> Please add a proper billing fees and restart rate-o-mat.
>
> Daniel
>
>
>
> Sent from Samsung Mobile
>
>
>
> Marcial Barrios <marcial at tecnimoviles.com> wrote:
>
>
> Hi Kevin, I do the following and works
>
> update cdr set rating_status ="ok" where
>  source_user_id="10d81223-c19c-4030-b2dd-429af4dd8376"
>
> but when I tried to
>
> #service ngcp-rate-o-mat start
>
> I have this other message:
>
> 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 fee info for profile 2 and user '0034922388318'
> or domain '0034922388318 at 91.192.110.234' found
>
>
>
>
>
> 2013/3/17 Kevin Masse <kmasse at questblue.com>
>
>> 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.  ****
>>
>>
>> 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=10d81223-c19c-4030-b2dd-429af4dd8376****
>>
>> ** **
>>
>> ** **
>>
>> If you are not using the XML or SOAP to update it still could be possible
>> you deleted a subscriber before calls were rated.****
>>
>> ** **
>>
>> This may have to be repeated a few times to get the status “ok” in all
>> fields.****
>>
>> ** **
>>
>> Kevin****
>>
>> ** **
>>
>> ** **
>>
>> ** **
>>
>> ** **
>>
>> *From:* spce-user-bounces at lists.sipwise.com [mailto:
>> spce-user-bounces at lists.sipwise.com] *On Behalf Of *Marcial Barrios
>> *Sent:* Sunday, March 17, 2013 12:07 PM
>> *To:* Daniel Grotti; spce-user at lists.sipwise.com
>> *Subject:* Re: [Spce-user] rate-o-mat****
>>
>> ** **
>>
>> ** **
>>
>> ** **
>>
>> 2013/3/17 Marcial Barrios <marcial at tecnimoviles.com>****
>>
>> Hi, Daniel this is what rate-o-mat.log is saying:****
>>
>> ** **
>>
>> Trying to connect to billing db...****
>>
>> Successfully connected to billing db...****
>>
>> Trying to connect to accounting db...****
>>
>> Successfully connected to accounting db...****
>>
>> Up and running.****
>>
>> rate cdr #13****
>>
>> No reseller info for user id 10d81223-c19c-4030-b2dd-429af4dd8376 found**
>> **
>>
>> Error rating CDR batch: No reseller info for user id
>> 10d81223-c19c-4030-b2dd-429af4dd8376 found****
>>
>> ** **
>>
>> ** **
>>
>> 2013/3/17 Daniel Grotti <dgrotti at sipwise.com>****
>>
>> Hi,****
>>
>> please check what /var/log/ngcp/rate-o-mat.log is saying.****
>>
>> ** **
>>
>> Daniel****
>>
>>
>>
>>
>> Sent from Samsung Mobile ****
>>
>>
>>
>>
>> Marcial Barrios <marcial at tecnimoviles.com> wrote:
>>
>> ****
>>
>> ** **
>>
>> No calls are rated.  How can check if rate-o-mat is working properly?****
>>
>> -- ****
>>
>> *Marcial Barrios*****
>>
>> *Administrador de Sistemas*****
>>
>> ****
>>
>> Móvil: (+34) 603 053 043****
>>
>>   Tel:  (+34) 902 955 290****
>>
>>  Fax:  (+34) 822 201 442****
>>
>> email: marcial at tecnimoviles.com****
>>
>>   web: www.tecnimoviles.com****
>>
>>
>>
>> ****
>>
>> ** **
>>
>> -- ****
>>
>> *Marcial Barrios*****
>>
>> *Administrador de Sistemas*****
>>
>> ****
>>
>> Móvil: (+34) 603 053 043****
>>
>>   Tel:  (+34) 902 955 290****
>>
>>  Fax:  (+34) 822 201 442****
>>
>> email: marcial at tecnimoviles.com****
>>
>>   web: www.tecnimoviles.com****
>>
>>
>>
>> ****
>>
>> ** **
>>
>> -- ****
>>
>> *Marcial Barrios*****
>>
>> *Administrador de Sistemas*****
>>
>> ****
>>
>> Móvil: (+34) 603 053 043****
>>
>>   Tel:  (+34) 902 955 290****
>>
>>  Fax:  (+34) 822 201 442****
>>
>> email: marcial at tecnimoviles.com****
>>
>>   web: www.tecnimoviles.com****
>>
>
>
>
> --
> *Marcial Barrios*
> *Administrador de** Sistemas*
> Móvil: (+34) 603 053 043
>   Tel:  (+34) 902 955 290
>  Fax:  (+34) 822 201 442
> email: marcial at tecnimoviles.com
>   web: www.tecnimoviles.com
>



-- 
*Marcial Barrios*
*Administrador de** Sistemas*
Móvil: (+34) 603 053 043
  Tel:  (+34) 902 955 290
 Fax:  (+34) 822 201 442
email: marcial at tecnimoviles.com
  web: www.tecnimoviles.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20130317/aae1e1d4/attachment-0001.html>