[Spce-user] Rate not Applied to Customer SPCE
EMMANUEL AFANG
afang.emmanuel at gmail.com
Tue Mar 12 11:15:58 EDT 2019
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 | 11112222100 |
0 | 127.0.0.1 | NULL | NULL | NULL | NULL
| NULL | NULL | NULL | NULL | NULL |
NULL | | 11112222100 | 0
| 4 |
| | 0 |
8844014444110003347 | sbc.provder.com | 8844014444110003347 |
8844014444110003347 | 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 <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 4:00 PM Daniel Grotti <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 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 <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/66bbb867/attachment-0001.html>
-------------- next part --------------
+----+---------------------+--------------------------------------+--------------------+-------------------------------+-----------------------------+-------------------+-------------+------------------------+-------------+-------------+-----------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------------+-----------------+--------------------------------------+-------------------------+------------------------------------+----------------------------------+------------------------+---------------------+--------------------+-------------------------+---------------------+-----------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------------+----------------------+----------------+-----------------+-----------+-------------+-----------+----------------+----------------+----------+---------------------------------------------------------+---------------------+----------------------+----------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+--------------------------------+---------------------------------+---------------------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+------------------------------------+-------------------------------------+-------------------------------------+-------------------------------------+--------------------------------------+--------------------------------------+---------------------+----------------------+----------------------+---------------+-------+---------------------+---------------+---------------------+---------------+-----------------+----------------------+
| 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 | 11112222100 | 0 | 127.0.0.1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 11112222100 | 0 | 4 | | | 0 | 8844014444110003347 | sbc.provder.com | 8844014444110003347 | 8844014444110003347 | 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 |
+----+---------------------+--------------------------------------+--------------------+-------------------------------+-----------------------------+-------------------+-------------+------------------------+-------------+-------------+-----------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------+-------------------+-----------------+--------------------------------------+-------------------------+------------------------------------+----------------------------------+------------------------+---------------------+--------------------+-------------------------+---------------------+-----------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------+------------------------+----------------------+----------------+-----------------+-----------+-------------+-----------+----------------+----------------+----------+---------------------------------------------------------+---------------------+----------------------+----------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+--------------------------------+---------------------------------+---------------------------------+--------------------------+---------------------------+---------------------------+-------------------------------+--------------------------------+--------------------------------+------------------------------------+-------------------------------------+-------------------------------------+-------------------------------------+--------------------------------------+--------------------------------------+---------------------+----------------------+----------------------+---------------+-------+---------------------+---------------+---------------------+---------------+-----------------+----------------------+
More information about the Spce-user
mailing list