[Spce-user] Billing not working

Tue Feb 23 11:34:53 EST 2021

Are the rates successfully imported in the billing profile?

I believe there is the problem…

I checked my CSV import files and it looks bit different to yours.. I have to use “” to get it to work…

"^43.+$","^4365.+$",out,"Austria","Mobil",0.1666667,1,0.1666667,1,0.1666667,1,0.1666667,1,1

"^43.+$","^4366.+$",out,"Austria","Mobil",0.1666667,1,0.1666667,1,0.1666667,1,0.1666667,1,1

"^43.+$","^4367.+$",out,"Austria","Mobil",0.1666667,1,0.1666667,1,0.1666667,1,0.1666667,1,1

"^43.+$","^4368.+$",out,"Austria","Mobil",0.1666667,1,0.1666667,1,0.1666667,1,0.1666667,1,1

"^43.+$","^4369.+$",out,"Austria","Mobil",0.1666667,1,0.1666667,1,0.1666667,1,0.1666667,1,1

Von: Viraj Balgobind <ideatells at outlook.com> 
Gesendet: Dienstag, 23. Februar 2021 15:24
An: Matthias Hohl <matthias.hohl at telematica.at>; spce-user at lists.sipwise.com
Betreff: RE: [Spce-user] Billing not working

Hi Matthias,

The rates are not applied to an outbound call, not on the peer and not on the customer.

When I click on the subscriber > call log I see the inbound and outbound call log and it is not being rated.

Please check the following screenshot:

Kind regards,

Viraj

From: Matthias Hohl <matthias.hohl at telematica.at <mailto:matthias.hohl at telematica.at> > 
Sent: Tuesday, 23 February 2021 15:06
To: 'Viraj Balgobind' <ideatells at outlook.com <mailto:ideatells at outlook.com> >; spce-user at lists.sipwise.com <mailto:spce-user at lists.sipwise.com> 
Subject: AW: [Spce-user] Billing not working

Hey,

what did you mean, they are not applied to your calls?

If you go into the subscriber > call log… did you see the calls there and also the rated amount?

Von: Viraj Balgobind <ideatells at outlook.com <mailto:ideatells at outlook.com> > 
Gesendet: Dienstag, 23. Februar 2021 14:38
An: spce-user at lists.sipwise.com <mailto:spce-user at lists.sipwise.com> 
Betreff: [Spce-user] Billing not working

Dear,

I am facing an issue with applying a billing profile to my subscribers and peers.

I applied the billing profile to my peers and customer, but the rates are not applied to my calls.

I used a CSV to upload my rates. An example is one the following:

.,^35526490,out, VoIP, VoIP,3,1,0.233333333,1,3,1,0.233333333,1,0,prefix

.,^35526523,out, VoIP, VoIP,3,1,0.233333333,1,3,1,0.233333333,1,0,prefix

.,^35526563,out, VoIP, VoIP,3,1,0.233333333,1,3,1,0.233333333,1,0,prefix

I checked the following logs:

root at spce:/var/log/ngcp# cat cdr.log

Feb 23 12:37:23 spce (info) mediator[1081]: mediator.c:443 [main]: Total CDR creation rate 145.623999 CDR/sec

Feb 23 12:47:06 spce (info) mediator[1081]: mediator.c:442 [main]: Runtime for loop processing 1 callids and generating 1 CDRs was 6857 us.

Feb 23 12:47:06 spce (info) mediator[1081]: mediator.c:443 [main]: Total CDR creation rate 145.836372 CDR/sec

Feb 23 12:47:49 spce (info) mediator[1081]: mediator.c:442 [main]: Runtime for loop processing 1 callids and generating 1 CDRs was 7676 us.

Feb 23 12:47:49 spce (info) mediator[1081]: mediator.c:443 [main]: Total CDR creation rate 130.276186 CDR/sec

Feb 23 12:48:12 spce (info) mediator[1081]: mediator.c:442 [main]: Runtime for loop processing 1 callids and generating 0 CDRs was 2176 us.

Feb 23 12:48:12 spce (info) mediator[1081]: mediator.c:443 [main]: Total CDR creation rate 0.000000 CDR/sec

Feb 23 12:48:22 spce (info) mediator[1081]: mediator.c:442 [main]: Runtime for loop processing 1 callids and generating 1 CDRs was 6967 us.

Feb 23 12:48:22 spce (info) mediator[1081]: mediator.c:443 [main]: Total CDR creation rate 143.533802 CDR/sec

Feb 23 12:48:25 spce (info) mediator[1081]: mediator.c:442 [main]: Runtime for loop processing 1 callids and generating 0 CDRs was 1353 us.

Feb 23 12:48:25 spce (info) mediator[1081]: mediator.c:443 [main]: Total CDR creation rate 0.000000 CDR/sec

Feb 23 12:48:35 spce (info) mediator[1081]: mediator.c:442 [main]: Runtime for loop processing 1 callids and generating 1 CDRs was 6205 us.

Feb 23 12:48:35 spce (info) mediator[1081]: mediator.c:443 [main]: Total CDR creation rate 161.160355 CDR/sec

Feb 23 13:13:08 spce (info) mediator[1081]: mediator.c:442 [main]: Runtime for loop processing 1 callids and generating 1 CDRs was 6586 us.

Feb 23 13:13:08 spce (info) mediator[1081]: mediator.c:443 [main]: Total CDR creation rate 151.837230 CDR/sec

Feb 23 13:17:41 spce (info) mediator[1081]: mediator.c:442 [main]: Runtime for loop processing 1 callids and generating 0 CDRs was 1706 us.

Feb 23 13:17:41 spce (info) mediator[1081]: mediator.c:443 [main]: Total CDR creation rate 0.000000 CDR/sec

Feb 23 13:17:51 spce (info) mediator[1081]: mediator.c:442 [main]: Runtime for loop processing 1 callids and generating 1 CDRs was 5205 us.

Feb 23 13:17:51 spce (info) mediator[1081]: mediator.c:443 [main]: Total CDR creation rate 192.122959 CDR/sec

Feb 23 13:23:24 spce (info) mediator[1081]: mediator.c:442 [main]: Runtime for loop processing 1 callids and generating 1 CDRs was 7136 us.

Feb 23 13:23:24 spce (info) mediator[1081]: mediator.c:443 [main]: Total CDR creation rate 140.134529 CDR/sec

Feb 23 13:23:27 spce (info) mediator[1081]: mediator.c:442 [main]: Runtime for loop processing 1 callids and generating 1 CDRs was 8149 us.

Feb 23 13:23:27 spce (info) mediator[1081]: mediator.c:443 [main]: Total CDR creation rate 122.714443 CDR/sec

Feb 23 13:23:50 spce (info) mediator[1081]: mediator.c:442 [main]: Runtime for loop processing 1 callids and generating 1 CDRs was 7276 us.

Feb 23 13:23:50 spce (info) mediator[1081]: mediator.c:443 [main]: Total CDR creation rate 137.438153 CDR/sec

root at spce:/var/log/ngcp# cat rate-o-mat.log  

root at spce:/var/log/ngcp#

This is what I see when I click on customers in the menu. It looks like it is applied to the customer.

Could you help me out with this issue?

Kind regards,

Viraj

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20210223/8a5d2ba9/attachment-0002.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 96205 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20210223/8a5d2ba9/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 20757 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20210223/8a5d2ba9/attachment-0005.png>