asterisk2billing.org
http://forum.asterisk2billing.org/

v1.4.4 No Matching Rate Found - Has something been updated?
http://forum.asterisk2billing.org/viewtopic.php?f=21&t=7071		 Page 1 of 2
Author:  bruce [ Wed Feb 10, 2010 5:29 pm ]
Post subject:  v1.4.4 No Matching Rate Found - Has something been updated?
All Callplan, ratecard, trunk, provide and rates are fine. RateCard is inserted into callplan. International prefix is set properly and rates are generated. But when using simulator, I get No Matching Rate Found. Has there been changes made the .tar.gz of v.1.4.x ?

What is the way to debug this? what logs should be checked?

Thanks
Author:  Joao Marcelo [ Wed Dec 01, 2010 8:45 pm ]
Post subject:  Re: v1.4.4 No Matching Rate Found - Has something been updated?
I'm having the same error.

Any clues about it?
Author:  jroper [ Thu Dec 02, 2010 7:22 am ]
Post subject:  Re: v1.4.4 No Matching Rate Found - Has something been updated?
Hi

Check what prefixes you are removing in the agi-conf.

Joe
Author:  Joao Marcelo [ Thu Dec 02, 2010 11:29 am ]
Post subject:  Re: v1.4.4 No Matching Rate Found - Has something been updated?
jroper wrote:
Hi

Check what prefixes you are removing in the agi-conf.

Joe


Thanks for the reply, but I don't think that's the
problem.

If I create a rate like 025XXXXXXXX it doesn't work, when
I do a Simulated call I get: "No Matching Rate Found". I
can see the rate on the rate table, but its like it
doesn't exist.

But if I EDIT one of the already functional rates, it
works! Exactly the same rate (025XXXXXXXX)

I tried to do an mysql update and flush privileges without
sucess.

I realy need some help here!!

EDIT: Some additional information, if I use some editor like
Mysql Workbench, and manually add the rate, it works.
Author:  renatofb [ Thu Dec 02, 2010 5:25 pm ]
Post subject:  Re: v1.4.4 No Matching Rate Found - Has something been updated?
It's very strange but I still have this problem I reported sometime ago,

The workaround I found was to send numbers with the prefix to be removed by the agi-config

if I send direct number withou prefix like 00 it will have same problem.

another thing is that this does not happens to all rates only some.

Last time I checked I had version 1.8.1

I didnt tried with 1.8.3 yet.
Author:  harisrana [ Mon Jun 18, 2012 2:59 pm ]
Post subject:  Re: v1.4.4 No Matching Rate Found - Has something been updated?
i am having the exact issue, installed a2billing 1.7.1 and asterisk 1.4.23 in two different servers and having the exact.

did anyone find any soltution?

please guide me as well.
Author:  harisrana [ Mon Jun 18, 2012 3:55 pm ]
Post subject:  Re: v1.4.4 No Matching Rate Found - Has something been updated?
adding further more, after some time, some rates are found and some are still not found. can anyone help me.
joe please help us
Author:  jroper [ Mon Jun 18, 2012 9:59 pm ]
Post subject:  Re: v1.4.4 No Matching Rate Found - Has something been updated?
There is unlikely to be anything amiss here, other than your import, I would advise you to recheck what you have done carefully.

Joe
Author:  last24h [ Fri Jan 25, 2013 6:28 am ]
Post subject:  Re: v1.4.4 No Matching Rate Found - Has something been updated?
www.facebook.com/SysAdminMan :

You should check that dates on the ratecard, rate card and rates look good.
I’ve seen a valid-to date of 0000-00-00 cause this.
Author:  unixpro [ Wed Jan 30, 2013 4:36 pm ]
Post subject:  Re: v1.4.4 No Matching Rate Found - Has something been updated?
Hey guys,

I've experienced the same issue and here is the fix.

The problem is the expiry date of the rate card. Assuming you have access to the DB such as using phpmyadmin, go to the table "cc_tariffplan" when this happens it shows the expiration date as "0000-00-00 00:00:00" you can simply modify this or run a query like UPDATE `cc_tariffplan` SET `expirationdate` = '2030-01-30 00:00:00' WHERE `cc_tariffplan`.`id` =211; using of course your parameters.

this worked for me, i hope it helps.

Joe, could this be a bug with A2b when you create a new rate card?
Author:  ictdude [ Sat May 18, 2013 11:56 am ]
Post subject:  Re: v1.4.4 No Matching Rate Found - Has something been updated?
unixpro wrote:
Hey guys,

I've experienced the same issue and here is the fix.

The problem is the expiry date of the rate card. Assuming you have access to the DB such as using phpmyadmin, go to the table "cc_tariffplan" when this happens it shows the expiration date as "0000-00-00 00:00:00" you can simply modify this or run a query like UPDATE `cc_tariffplan` SET `expirationdate` = '2030-01-30 00:00:00' WHERE `cc_tariffplan`.`id` =211; using of course your parameters.

this worked for me, i hope it helps.

Joe, could this be a bug with A2b when you create a new rate card?


Hey guys i had the same problem here. A lot of trouble shoot before i did understand what was going on.
If it shows the expiration date as "0000-00-00 00:00:00" Then it will not work !! I recreated a new rate card.

double checked that the expiration date was like 2035-05-18 11:43 ;-) Now rates are ok. Looks like a bug here.
But that's the way to workaround it ;-) Can be you need to safe it again before the date is like 2035-05-18 11:43 :wink:
Author:  jroper [ Tue May 21, 2013 7:04 am ]
Post subject:  Re: v1.4.4 No Matching Rate Found - Has something been updated?
Hi

This issue is solved in version 2.X of A2Billing


Joe
Author:  ktqd502697 [ Fri Jun 14, 2013 9:10 am ]
Post subject:  Re: v1.4.4 No Matching Rate Found - Has something been updated?
hi, i have the same issue. i tried all most of the suggested method. But i can not solve this issue. if any one have more solution, please upload help us. Thank in advance
Author:  tanveerhk [ Mon Oct 21, 2013 10:02 pm ]
Post subject:  Re: v1.4.4 No Matching Rate Found - Has something been updated?
Dear All,

i am having the same problem on version 2.XX. here is the CLI debug output.

a2billing.php,2: file:Class.A2Billing.php - line:893 - uniqueid:1382391033.5 - DESTINATION ::> 00923335409526
a2billing.php,2: file:Class.A2Billing.php - line:900 - uniqueid:1382391033.5 - RULES APPLY ON DESTINATION ::> 00923335409526
a2billing.php,2: file:Class.A2Billing.php - line:3703 - uniqueid:1382391033.5 - [SAVING DESTINATION FOR REDIAL: SQL: UPDATE cc_card SET redial = '00923335409526' WHERE username = '8543877774']:[result: 1]
a2billing.php,2: file:Class.RateEngine.php - line:97 - uniqueid:1382391033.5 - [CC_asterisk_rate-engine: (7, 00923335409526)]
a2billing.php,2: file:Class.RateEngine.php - line:118 - uniqueid:1382391033.5 - [CC_asterisk_rate-engine - CALLERID : 8543877774]
a2billing.php,2: file:Class.A2Billing.php - line:1015 - uniqueid:1382391033.5 - ERROR ::> The phone number (00923335409526) cannot be dialed by the Rate engine, check that the Ratecard and Call Plan are well configured!
a2billing.php,2: file:a2billing.php - line:560 - uniqueid:1382391033.5 - ANSWER fct callingcard_ivr authorize:> -1
a2billing.php,2: file:Class.A2Billing.php - line:744 - uniqueid:1382391033.5 - [CARD STATUS UPDATE]
a2billing.php,2: file:Class.A2Billing.php - line:753 - uniqueid:1382391033.5 - [QUERY USING CARD UPDATE::> UPDATE cc_card SET inuse = inuse - 1, credit = credit + 0.25 WHERE username = '8543877774']
-- <SIP/8543877774-00000005>AGI Script a2billing.php completed, returning 4
== Spawn extension (a2billing, 00923335409526, 2) exited non-zero on 'SIP/8543877774-00000005'


here is my datbase

mysql> select * from cc_tariffgroup;
+----+--------+--------------+-----------------+---------+---------------------+-------------------+---------------------+
| id | iduser | idtariffplan | tariffgroupname | lcrtype | creationdate | removeinterprefix | id_cc_package_offer |
+----+--------+--------------+-----------------+---------+---------------------+-------------------+---------------------+
| 7 | 0 | 0 | CallPakistan | 1 | 2013-10-21 15:43:49 | 0 | -1 |
+----+--------+--------------+-----------------+---------+---------------------+-------------------+---------------------+
1 row in set (0.00 sec)


mysql> select * from cc_tariffplan;
+----+--------+--------------+---------------------+---------------------+---------------------+-------------+----------+----------------+-------------------+--------------------+---------------+---------+------------+----------------+
| id | iduser | tariffname | creationdate | startingdate | expirationdate | description | id_trunk | secondusedreal | secondusedcarrier | secondusedratecard | reftariffplan | idowner | dnidprefix | calleridprefix |
+----+--------+--------------+---------------------+---------------------+---------------------+-------------+----------+----------------+-------------------+--------------------+---------------+---------+------------+----------------+
| 8 | 0 | CallPakistan | 2013-10-21 15:42:22 | 2013-10-21 16:41:10 | 2030-01-30 00:00:00 | | 5 | 0 | 0 | 0 | 0 | 0 | all | all |
+----+--------+--------------+---------------------+---------------------+---------------------+-------------+----------+----------------+-------------------+--------------------+---------------+---------+------------+----------------+
1 row in set (0.00 sec)


i check the dates are ok but i am still getting no rate found on RATE CARD SIMULATION and also on CLI. your help would be appreciated. thank.

Tanveer
Author:  jroper [ Tue Oct 22, 2013 10:56 am ]
Post subject:  Re: v1.4.4 No Matching Rate Found - Has something been updated?
Hi

it won't be a bug it will be a misconfiguration on your part. Ensure the customer is connected to a callplan, the callplan has ratecards, and the rate cards have the appropriate rates. Also check to see what you are removing in remove international dial prefix in the agoi-conf if you have remove prefix enabled in the callplan

Joe
Page 1 of 2 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/