I just noticed that I am missing calls. A customer had 462 calls according to his IVR, my a2b database shows me only 435 calls.
Checking the CDR on the machine where a2b is running confirms the 462 calls.
I have seen a similar topic from 2008 (here:
viewtopic.php?f=16&t=4250&start=15) but not really sure if it's related. What I can see according to the logs is that there was never a insert statement in the cc_call table which is very very strange.
Since a2b didn't do a-leg billing with the old version what I always did was create a new trunk with this provider IP %dialingnumber%@79.111.111.111, where 79.111.111.111 stands for the remote SIP Server where I want to send the traffic. Then I added a new rate using this new trunk and so I could add a destination 1234 for example with VOIP Call no but still send the call over SIP and bill it. I just wanted to mention this so that my setup is understood ... it might contribute to the problem.
Attached is a log of one such missing call.
The odd thing is, that there is no trace at all of the unique ID 1314087566.22982 from this call after this line:
Aug 23 10:19:26 sip php: file:Class.RateEngine.php - line:1157 - uniqueid:1314087566.22982 - [TRUNK STATUS UPDATE : UPDATE cc_trunk SET inuse=inuse+1 WHERE id_trunk='10']
In my CDR file the call is listed as my customer sees it on his IVR and the call lasted 40 min, that is quite a lot to just 'loose'
Code:
Master.csv:"","030680yyxxx","2502XXX","a2billing-did","""030680yyxxx"" <030680yyxxx>","SIP/foobarcust-00005760","SIP/79.111.111.111-00005761","Dial","SIP/
[email protected],60,HRgrL(2147483647:61000:30000)","2011-08-23 08:19:26","2011-08-23 08:19:26","2011-08-23 08:59:21",2395,2395,"ANSWERED","DOCUMENTATION","1314087566.22982",""
although I don't quite understand why the timestamp in the CSV file has a different Timezone, but don't really care about that for now.
Any suggestions where I might be losing my calls ?
LE: I forgot, my a2b version is: A2Billing 1.9.4 (Cuprum), Asterisk 1.6.2.9-2+squeeze3 running on Debian 6.0.2 - Kernel 2.6.32-5