[Spce-user] Rate not Applied to Customer SPCE

[EMMANUEL AFANG]

Rate-o-mat keeps crashing...

:~# tail -f /var/log/ngcp/rate-o-mat.log
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Trying to
connect to accounting db...
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Successfully
connected to accounting db...
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: local cdr
time balance column model loaded
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: local cdr
relation column model loaded
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: local cdr
cash balance column model loaded
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: local cdr
tag column model loaded
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Up and running.
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Grabbed 9 CDRs
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: 1/9 - rate CDR ID 38
Mar 12 15:57:09 vmi236882 (info) rate-o-mat[19580]: INFO: Caught DBI:err 1690


Best Regards



*Emmanuel Afang *


Mobile +2347084280332
Email:  *a <cuzomba at dial-mobile.com>fang.emmanuel at gmail.com
<fang.emmanuel at gmail.com>*

Skype: *a <cuzomba at dial-mobile.com>fang.emmanuel*



On Tue, Mar 12, 2019 at 3:54 PM Daniel Grotti <dgrotti at sipwise.com> wrote:

> You can try to enable rate-o-mat debug level:
>
> cat /mnt/glusterfs/home/dgrotti# cat /etc/default/ngcp-rate-o-mat
>
> # Options for the NGCP rate-o-mat
> RATEOMAT_DEBUG=2
> ...
> ...
>
>
> There restart rate-o-mat and check again the log.
>
> --
> Daniel Grotti
>
> Head of Customer Support                               Sipwise GmbH
> e: dgrotti at sipwise.com                               Europaring F15
> t: +43(0)130120332                          A-2345 Brunn Am Gebirge
> w: www.sipwise.com          FN: 305595f      FG: LG Wiener Neustadt
>
> On 3/12/19 3:50 PM, EMMANUEL AFANG wrote:
>
> The CallID for CDR 39 is 97576ZTQxOGYyYjc3ZTVjZmNhNTZmZjcwZmI3ZjVmYWM0ZmE
> Everything is auto generated.
>
> Best Regards
>
>
>
> *Emmanuel Afang *
>
>
> Mobile +2347084280332
> Email:  *a <cuzomba at dial-mobile.com>fang.emmanuel at gmail.com
> <fang.emmanuel at gmail.com>*
>
> Skype: *a <cuzomba at dial-mobile.com>fang.emmanuel*
>
>
>
> On Tue, Mar 12, 2019 at 3:46 PM Daniel Grotti <dgrotti at sipwise.com> wrote:
>
>> Hi,
>> do you maybe have some string value out of range in CDR id 39 ?
>>
>>
>> *Error: 1690* SQLSTATE: 22003 (ER_DATA_OUT_OF_RANGE)
>> Message: %s value is out of range in '%s'
>>
>>
>>
>> --
>> Daniel Grotti
>>
>> Head of Customer Support                               Sipwise GmbH
>> e: dgrotti at sipwise.com                               Europaring F15
>> t: +43(0)130120332                          A-2345 Brunn Am Gebirge
>> w: www.sipwise.com          FN: 305595f      FG: LG Wiener Neustadt
>>
>> On 3/12/19 3:38 PM, EMMANUEL AFANG wrote:
>>
>> Rate-o-mat service failed with the following log:
>>
>> :~# tail -f /var/log/ngcp/rate-o-mat.log
>> Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Batch of 1 CDRs completed. 10 CDRs rated overall so far.
>> Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Batch of 0 CDRs completed. 10 CDRs rated overall so far.
>> Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Batch of 0 CDRs completed. 10 CDRs rated overall so far.
>> Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Grabbed 1 CDRs
>> Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: 1/1 - rate CDR ID 37
>> Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Batch of 1 CDRs completed. 11 CDRs rated overall so far.
>> Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Batch of 0 CDRs completed. 11 CDRs rated overall so far.
>> Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Grabbed 1 CDRs
>> Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: 1/1 - rate CDR ID 38
>> Mar 12 13:24:42 vmi236882 (info) rate-o-mat[1226]: INFO: Caught DBI:err 1690
>>
>>
>> Best Regards,
>>
>> Afang Emmanuel
>>
>> Mobile: +234 708 428 0332
>> Skype: Afang.Emmanuel
>>
>>
>> On Tue, Mar 12, 2019, 2:02 PM EMMANUEL AFANG <afang.emmanuel at gmail.com>
>> wrote:
>>
>>> Hi
>>> I configured rate for customer with direction out. CDR still shows a
>>> cost of zero.
>>> mr7.1.1
>>> Please what am I doing wrong?
>>>
>>> Best Regards
>>>
>>>
>>>
>>> *Emmanuel Afang *
>>>
>>>
>>> Mobile +2347084280332
>>> Email:  *a <cuzomba at dial-mobile.com>fang.emmanuel at gmail.com
>>> <fang.emmanuel at gmail.com>*
>>>
>>> Skype: *a <cuzomba at dial-mobile.com>fang.emmanuel*
>>>
>>>
>> _______________________________________________
>> Spce-user mailing listSpce-user at lists.sipwise.comhttps://lists.sipwise.com/listinfo/spce-user
>>
>>
>> _______________________________________________
>> Spce-user mailing list
>> Spce-user at lists.sipwise.com
>> https://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/20190312/c4eb749f/attachment-0001.html>