[Spce-user] Rate not Applied to Customer SPCE

Daniel Grotti dgrotti at sipwise.com
Tue Mar 12 11:19:08 EDT 2019


Hi,
please be so kind to use \G at the end of you mysql query, for 
readability purpose.


--
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 4:15 PM, EMMANUEL AFANG wrote:
> Here you it is. Also attached.
>
> +----+---------------------+--------------------------------------+--------------------+-------------------------------+-----------------------------+-------------------+-------------+------------------------+-------------+-------------+-----------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------------+-----------------+--------------------------------------+-------------------------+------------------------------------+----------------------------------+------------------------+---------------------+--------------------+-------------------------+---------------------+-----------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------------+----------------------+----------------+-----------------+-----------+-------------+-----------+----------------+----------------+----------+---------------------------------------------------------+---------------------+----------------------+----------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+--------------------------------+---------------------------------+---------------------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+------------------------------------+-------------------------------------+-------------------------------------+-------------------------------------+--------------------------------------+--------------------------------------+---------------------+----------------------+----------------------+---------------+-------+---------------------+---------------+---------------------+---------------+-----------------+----------------------+
> | id | update_time         | source_user_id          | 
> source_provider_id | source_external_subscriber_id | 
> source_external_contract_id | source_account_id | source_user | 
> source_domain          | source_cli  | source_clir | source_ip | 
> source_gpp0 | source_gpp1 | source_gpp2 | source_gpp3 | source_gpp4 | 
> source_gpp5 | source_gpp6 | source_gpp7 | source_gpp8 | source_gpp9 | 
> source_lnp_prefix | source_user_out | destination_user_id              
>     | destination_provider_id | destination_external_subscriber_id | 
> destination_external_contract_id | destination_account_id | 
> destination_user    | destination_domain | destination_user_dialed | 
> destination_user_in | destination_domain_in | destination_gpp0 | 
> destination_gpp1 | destination_gpp2 | destination_gpp3 | 
> destination_gpp4 | destination_gpp5 | destination_gpp6 | 
> destination_gpp7 | destination_gpp8 | destination_gpp9 | 
> destination_lnp_prefix | destination_user_out | peer_auth_user | 
> peer_auth_realm | call_type | call_status | call_code | init_time      
> | start_time     | duration | call_id                        | 
> source_carrier_cost | source_reseller_cost | source_customer_cost | 
> source_carrier_free_time | source_reseller_free_time | 
> source_customer_free_time | source_carrier_billing_fee_id | 
> source_reseller_billing_fee_id | source_customer_billing_fee_id | 
> source_carrier_billing_zone_id | source_reseller_billing_zone_id | 
> source_customer_billing_zone_id | destination_carrier_cost | 
> destination_reseller_cost | destination_customer_cost | 
> destination_carrier_free_time | destination_reseller_free_time | 
> destination_customer_free_time | destination_carrier_billing_fee_id | 
> destination_reseller_billing_fee_id | 
> destination_customer_billing_fee_id | 
> destination_carrier_billing_zone_id | 
> destination_reseller_billing_zone_id | 
> destination_customer_billing_zone_id | frag_carrier_onpeak | 
> frag_reseller_onpeak | frag_customer_onpeak | is_fragmented | split | 
> rated_at            | rating_status | exported_at        | 
> export_status | source_lnp_type | destination_lnp_type |
> +----+---------------------+--------------------------------------+--------------------+-------------------------------+-----------------------------+-------------------+-------------+------------------------+-------------+-------------+-----------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------------+-----------------+--------------------------------------+-------------------------+------------------------------------+----------------------------------+------------------------+---------------------+--------------------+-------------------------+---------------------+-----------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------------+----------------------+----------------+-----------------+-----------+-------------+-----------+----------------+----------------+----------+---------------------------------------------------------+---------------------+----------------------+----------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+--------------------------------+---------------------------------+---------------------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+------------------------------------+-------------------------------------+-------------------------------------+-------------------------------------+--------------------------------------+--------------------------------------+---------------------+----------------------+----------------------+---------------+-------+---------------------+---------------+---------------------+---------------+-----------------+----------------------+
> | 39 | 2019-03-12 13:34:53 | defdcdee-14e0-4d11-80b0-64fcbdc5c7f4 | 1  
>                 | test_custm                    | test_custm |        
>          6 | 11112222100 | app.sipwise.com.za 
> <http://app.sipwise.com.za>    | 11112222100 |           0 | 127.0.0.1 
> | NULL        | NULL        | NULL        | NULL        | NULL        
> | NULL        | NULL        | NULL        | NULL        | NULL        
> |                   | 11112222100     | 0                             
> | 4                       |                               |     |      
>                 0 | 8844014444110003347 | sbc.provder.com 
> <http://sbc.provder.com>   | 8844014444110003347     | 
> 8844014444110003347 | app.sipwise.com.za <http://app.sipwise.com.za>   
> | NULL             | NULL             | NULL             | NULL        
>      | NULL             | NULL             | NULL             | NULL  
>            | NULL             | NULL             |                    
>     | 4444110003347     |                |                 | call      
> | cancel     | 487       | 1552394085.050 | 1552394085.217 |    0.000 
> | 97576NjY1ZWZiNDc2MzdkYmM3Y2NiYjhjZTc1ZThmOTViZTY        |           
> 0.000000 |             0.000000 |  0.000000 |                     NULL 
> | NULL |                      NULL | NULL |                          
>  NULL |      NULL |                           NULL |             NULL 
> |                            NULL |          0.000000 |                
>   0.000000 |     0.000000 |                          NULL |           
>    NULL |                           NULL |                        NULL 
> | NULL |                                NULL |                 NULL |  
>                                NULL |                                
>  NULL |                NULL |                 NULL |                
>  NULL | NULL |     0 | NULL                | unrated       | NULL     
>         | unexported    | NULL            | NULL          |
> +----+---------------------+--------------------------------------+--------------------+-------------------------------+-----------------------------+-------------------+-------------+------------------------+-------------+-------------+-----------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------------+-----------------+--------------------------------------+-------------------------+------------------------------------+----------------------------------+------------------------+---------------------+--------------------+-------------------------+---------------------+-----------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------------+----------------------+----------------+-----------------+-----------+-------------+-----------+----------------+----------------+----------+---------------------------------------------------------+---------------------+----------------------+----------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+--------------------------------+---------------------------------+---------------------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+------------------------------------+-------------------------------------+-------------------------------------+-------------------------------------+--------------------------------------+--------------------------------------+---------------------+----------------------+----------------------+---------------+-------+---------------------+---------------+---------------------+---------------+-----------------+----------------------+
>
>
> 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 4:00 PM Daniel Grotti <dgrotti at sipwise.com 
> <mailto:dgrotti at sipwise.com>> wrote:
>
>     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  <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: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/d18bbe1e/attachment-0001.html>


More information about the Spce-user mailing list