[Spce-user] Rate not Applied to Customer SPCE

[Daniel Grotti]

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 
> <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
> 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/74ba4d90/attachment-0001.html>