[Spce-user] rate-o-mat
Daniel Grotti
dgrotti at sipwise.com
Sun Mar 17 16:18:50 EDT 2013
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20130317/1a056e0b/attachment-0001.html>
More information about the Spce-user
mailing list