[Spce-user] Rate not Applied to Customer SPCE

Daniel Grotti dgrotti at sipwise.com
Tue Mar 12 11:00:32 EDT 2019


please share or check how CDR id 38 looks like please.
Looks like there are some field that does not like to rateomat.

--
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:58 PM, EMMANUEL AFANG wrote:
> 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 <mailto:cuzomba at dial-mobile.com>fang.emmanuel at gmail.com 
> <mailto:fang.emmanuel at gmail.com>_
>
> Skype: _a <mailto:cuzomba at dial-mobile.com>fang.emmanuel_
>
>
>
>
> On Tue, Mar 12, 2019 at 3:54 PM Daniel Grotti <dgrotti at sipwise.com 
> <mailto: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  <mailto:dgrotti at sipwise.com>                                Europaring F15
>     t: +43(0)130120332                          A-2345 Brunn Am Gebirge
>     w:www.sipwise.com  <http://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 <mailto:cuzomba at dial-mobile.com>fang.emmanuel at gmail.com
>>     <mailto:fang.emmanuel at gmail.com>_
>>
>>     Skype: _a <mailto:cuzomba at dial-mobile.com>fang.emmanuel_
>>
>>
>>
>>
>>     On Tue, Mar 12, 2019 at 3:46 PM Daniel Grotti
>>     <dgrotti at sipwise.com <mailto: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  <mailto:dgrotti at sipwise.com>                                Europaring F15
>>         t: +43(0)130120332                          A-2345 Brunn Am Gebirge
>>         w:www.sipwise.com  <http://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 <mailto: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
>>>             <mailto:cuzomba at dial-mobile.com>fang.emmanuel at gmail.com
>>>             <mailto:fang.emmanuel at gmail.com>_
>>>
>>>             Skype: _a <mailto:cuzomba at dial-mobile.com>fang.emmanuel_
>>>
>>>
>>>
>>>         _______________________________________________
>>>         Spce-user mailing list
>>>         Spce-user at lists.sipwise.com  <mailto:Spce-user at lists.sipwise.com>
>>>         https://lists.sipwise.com/listinfo/spce-user
>>
>>         _______________________________________________
>>         Spce-user mailing list
>>         Spce-user at lists.sipwise.com <mailto: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/6a237bf1/attachment-0001.html>


More information about the Spce-user mailing list