Real time report issue

[ivschakravarthi]

In Real time report,some times i am facing the below issue.







This is a Inbound Service and No outbound.
Actually Current Active Calls should be equal to No of Agents in Call + No of waiting Calls.

But in the above screenshots,it is not coming equal.
I monitored around for 1 hour and it always keep showing the Current Active Calls total with difference of 2 calls.
Please help where to find and fix it.



Vicdial VERSION: 2.8-403a |BUILD: 130510-1350 |asterisk 1.4.27.1|single server |Centos6.5 |One Digium card | No cluster

[mflorell]

You would need to post the contents of the vicidial_auto_calls table.

[ivschakravarthi]

Hi,
I have a difference of 3 calls.
Below is the output of vicidial_auto_calls table.....


mysql> select * from vicidial_auto_calls\G
*************************** 1. row ***************************
auto_call_id: 2380339
server_ip: 11.11.11.11
campaign_id: campaign1
status: CLOSER
lead_id: 1182076
uniqueid: 1402328521.1521138
callerid: Y6091742010001182076
channel: SIP/6789-b52e2768
phone_code: 1
phone_number: XXXXXXXXXx
call_time: 2014-06-09 17:42:01
call_type: IN
stage: CLOSER-30
last_update_time: 2014-06-09 17:42:31
alt_dial: NONE
queue_priority: 0
agent_only:
agent_grab:
queue_position: 3
extension:
agent_grab_extension:
*************************** 2. row ***************************
auto_call_id: 2376372
server_ip: 11.11.11.11
campaign_id: campaign2
status: CLOSER
lead_id: 1680321
uniqueid: 1402305841.1499911
callerid: Y6091124010001680321
channel: SIP/6789-b4811688
phone_code: 1
phone_number: XXXXXXXXXx
call_time: 2014-06-09 11:24:01
call_type: IN
stage: CLOSER-0
last_update_time: 2014-06-09 11:24:01
alt_dial: NONE
queue_priority: 3
agent_only:
agent_grab:
queue_position: 1
extension:
agent_grab_extension:
*************************** 3. row ***************************
auto_call_id: 2380348
server_ip: 11.11.11.11
campaign_id: campaign1
status: CLOSER
lead_id: 1580276
uniqueid: 1402328558.1521179
callerid: Y6091742380001580276
channel: SIP/6789-b52741d8
phone_code: 1
phone_number: XXXXXXXXXx
call_time: 2014-06-09 17:42:38
call_type: IN
stage: CLOSER-14
last_update_time: 2014-06-09 17:42:52
alt_dial: NONE
queue_priority: 0
agent_only:
agent_grab:
queue_position: 3
extension:
agent_grab_extension:
*************************** 4. row ***************************
auto_call_id: 2380342
server_ip: 11.11.11.11
campaign_id: campaign1
status: CLOSER
lead_id: 1620301
uniqueid: 1402328535.1521153
callerid: Y6091742150001620301
channel: SIP/6789-b52c0f00
phone_code: 1
phone_number: XXXXXXXXXx
call_time: 2014-06-09 17:42:15
call_type: IN
stage: CLOSER-20
last_update_time: 2014-06-09 17:42:35
alt_dial: NONE
queue_priority: 0
agent_only:
agent_grab:
queue_position: 3
extension:
agent_grab_extension:
*************************** 5. row ***************************
auto_call_id: 2380320
server_ip: 11.11.11.11
campaign_id: campaign1
status: CLOSER
lead_id: 1676482
uniqueid: 1402328422.1521045
callerid: Y6091740220001676482
channel: SIP/6789-b52555e0
phone_code: 1
phone_number: XXXXXXXXXx
call_time: 2014-06-09 17:40:22
call_type: IN
stage: CLOSER-14
last_update_time: 2014-06-09 17:40:36
alt_dial: NONE
queue_priority: 0
agent_only:
agent_grab:
queue_position: 1
extension:
agent_grab_extension:
*************************** 6. row ***************************
auto_call_id: 2374838
server_ip: 11.11.11.11
campaign_id: campaign2
status: CLOSER
lead_id: 1679762
uniqueid: 1402295750.1491748
callerid: Y6090835510001679762
channel: SIP/6789-b4c2f7a8
phone_code: 1
phone_number: XXXXXXXXXx
call_time: 2014-06-09 08:35:51
call_type: IN
stage: CLOSER-3
last_update_time: 2014-06-09 08:35:54
alt_dial: NONE
queue_priority: 3
agent_only:
agent_grab:
queue_position: 1
extension:
agent_grab_extension:
*************************** 7. row ***************************
auto_call_id: 2380337
server_ip: 11.11.11.11
campaign_id: campaign1
status: CLOSER
lead_id: 1395167
uniqueid: 1402328506.1521132
callerid: Y6091741460001395167
channel: SIP/6789-b52ddbd0
phone_code: 1
phone_number: XXXXXXXXXx
call_time: 2014-06-09 17:41:46
call_type: IN
stage: CLOSER-3
last_update_time: 2014-06-09 17:41:49
alt_dial: NONE
queue_priority: 0
agent_only:
agent_grab:
queue_position: 2
extension:
agent_grab_extension:
*************************** 8. row ***************************
auto_call_id: 2380343
server_ip: 11.11.11.11
campaign_id: campaign1
status: CLOSER
lead_id: 1639100
uniqueid: 1402328537.1521154
callerid: Y6091742170001639100
channel: SIP/6789-b52fad08
phone_code: 1
phone_number: XXXXXXXXXx
call_time: 2014-06-09 17:42:17
call_type: IN
stage: CLOSER-19
last_update_time: 2014-06-09 17:42:36
alt_dial: NONE
queue_priority: 0
agent_only:
agent_grab:
queue_position: 4
extension:
agent_grab_extension:
*************************** 9. row ***************************
auto_call_id: 2380340
server_ip: 11.11.11.11
campaign_id: campaign1
status: CLOSER
lead_id: 1656723
uniqueid: 1402328522.1521139
callerid: Y6091742030001656723
channel: SIP/6789-b522d690
phone_code: 1
phone_number: XXXXXXXXXx
call_time: 2014-06-09 17:42:03
call_type: IN
stage: CLOSER-28
last_update_time: 2014-06-09 17:42:31
alt_dial: NONE
queue_priority: 0
agent_only:
agent_grab:
queue_position: 4
extension:
agent_grab_extension:
*************************** 10. row ***************************
auto_call_id: 2380345
server_ip: 11.11.11.11
campaign_id: campaign1
status: CLOSER
lead_id: 1681403
uniqueid: 1402328542.1521158
callerid: Y6091742220001681403
channel: SIP/6789-b5237f68
phone_code: 1
phone_number: XXXXXXXXXx
call_time: 2014-06-09 17:42:22
call_type: IN
stage: CLOSER-15
last_update_time: 2014-06-09 17:42:37
alt_dial: NONE
queue_priority: 0
agent_only:
agent_grab:
queue_position: 6
extension:
agent_grab_extension:
*************************** 11. row ***************************
auto_call_id: 2380349
server_ip: 11.11.11.11
campaign_id: campaign1
status: CLOSER
lead_id: 1448108
uniqueid: 1402328569.1521196
callerid: Y6091742490001448108
channel: SIP/6789-b526fe88
phone_code: 1
phone_number: XXXXXXXXXx
call_time: 2014-06-09 17:42:49
call_type: IN
stage: CLOSER-4
last_update_time: 2014-06-09 17:42:53
alt_dial: NONE
queue_priority: 0
agent_only:
agent_grab:
queue_position: 2
extension:
agent_grab_extension:
*************************** 12. row ***************************
auto_call_id: 2378344
server_ip: 11.11.11.11
campaign_id: campaign2
status: CLOSER
lead_id: 1680888
uniqueid: 1402318226.1510894
callerid: Y6091450270001680888
channel: SIP/6789-b4a89570
phone_code: 1
phone_number: XXXXXXXXXx
call_time: 2014-06-09 14:50:27
call_type: IN
stage: CLOSER-13
last_update_time: 2014-06-09 14:50:40
alt_dial: NONE
queue_priority: 3
agent_only:
agent_grab:
queue_position: 1
extension:
agent_grab_extension:
*************************** 13. row ***************************
auto_call_id: 2380346
server_ip: 11.11.11.11
campaign_id: campaign1
status: CLOSER
lead_id: 1681397
uniqueid: 1402328548.1521161
callerid: Y6091742290001681397
channel: SIP/6789-b523ca58
phone_code: 1
phone_number: XXXXXXXXXx
call_time: 2014-06-09 17:42:29
call_type: IN
stage: CLOSER-13
last_update_time: 2014-06-09 17:42:42
alt_dial: NONE
queue_priority: 0
agent_only:
agent_grab:
queue_position: 7
extension:
agent_grab_extension:
*************************** 14. row ***************************
auto_call_id: 2380350
server_ip: 11.11.11.11
campaign_id: campaign1
status: CLOSER
lead_id: 1568274
uniqueid: 1402328588.1521205
callerid: Y6091743080001568274
channel: SIP/6789-b5267e98
phone_code: 1
phone_number: XXXXXXXXXx
call_time: 2014-06-09 17:43:08
call_type: IN
stage: CLOSER-0
last_update_time: 2014-06-09 17:43:08
alt_dial: NONE
queue_priority: 0
agent_only:
agent_grab:
queue_position: 1
extension:
agent_grab_extension:
*************************** 15. row ***************************
auto_call_id: 2380297
server_ip: 11.11.11.11
campaign_id: campaign1
status: CLOSER
lead_id: 1483828
uniqueid: 1402328295.1520870
callerid: Y6091738160001483828
channel: SIP/6789-b52ca070
phone_code: 1
phone_number: XXXXXXXXXx
call_time: 2014-06-09 17:38:16
call_type: IN
stage: CLOSER-58
last_update_time: 2014-06-09 17:39:14
alt_dial: NONE
queue_priority: 0
agent_only:
agent_grab:
queue_position: 15
extension:
agent_grab_extension:
*************************** 16. row ***************************
auto_call_id: 2380338
server_ip: 11.11.11.11
campaign_id: campaign1
status: CLOSER
lead_id: 1681401
uniqueid: 1402328512.1521135
callerid: Y6091741530001681401
channel: SIP/6789-b52d1058
phone_code: 1
phone_number: XXXXXXXXXx
call_time: 2014-06-09 17:41:53
call_type: IN
stage: CLOSER-16
last_update_time: 2014-06-09 17:42:09
alt_dial: NONE
queue_priority: 0
agent_only:
agent_grab:
queue_position: 2
extension:
agent_grab_extension:
*************************** 17. row ***************************
auto_call_id: 2380334
server_ip: 11.11.11.11
campaign_id: campaign1
status: CLOSER
lead_id: 1399669
uniqueid: 1402328499.1521119
callerid: Y6091741400001399669
channel: SIP/6789-b52f4270
phone_code: 1
phone_number: XXXXXXXXXx
call_time: 2014-06-09 17:41:40
call_type: IN
stage: CLOSER-1
last_update_time: 2014-06-09 17:41:41
alt_dial: NONE
queue_priority: 0
agent_only:
agent_grab:
queue_position: 1
extension:
agent_grab_extension:
*************************** 18. row ***************************
auto_call_id: 2380344
server_ip: 11.11.11.11
campaign_id: campaign1
status: CLOSER
lead_id: 1681402
uniqueid: 1402328540.1521157
callerid: Y6091742200001681402
channel: SIP/6789-b5233ff0
phone_code: 1
phone_number:XXXXXXXXXx
call_time: 2014-06-09 17:42:20
call_type: IN
stage: CLOSER-16
last_update_time: 2014-06-09 17:42:36
alt_dial: NONE
queue_priority: 0
agent_only:
agent_grab:
queue_position: 5
extension:
agent_grab_extension:
*************************** 19. row ***************************
auto_call_id: 2380319
server_ip: 11.11.11.11
campaign_id: campaign1
status: CLOSER
lead_id: 1637522
uniqueid: 1402328421.1521044
callerid: Y6091740210001637522
channel: SIP/6789-b52cc3f8
phone_code: 1
phone_number: XXXXXXXXXx
call_time: 2014-06-09 17:40:21
call_type: IN
stage: CLOSER-0
last_update_time: 2014-06-09 17:40:22
alt_dial: NONE
queue_priority: 0
agent_only:
agent_grab:
queue_position: 1
extension:
agent_grab_extension:
*************************** 20. row ***************************
auto_call_id: 2380351
server_ip: 11.11.11.11
campaign_id: campaign1
status: CLOSER
lead_id: 1595912
uniqueid: 1402328589.1521208
callerid: Y6091743090001595912
channel: SIP/6789-b5253ee0
phone_code: 1
phone_number: XXXXXXXXXx
call_time: 2014-06-09 17:43:09
call_type: IN
stage: CLOSER-0
last_update_time: 2014-06-09 17:43:09
alt_dial: NONE
queue_priority: 0
agent_only:
agent_grab:
queue_position: 1
extension:
agent_grab_extension:
*************************** 21. row ***************************
auto_call_id: 2380329
server_ip: 11.11.11.11
campaign_id: campaign1
status: CLOSER
lead_id: 1555469
uniqueid: 1402328477.1521088
callerid: Y6091741170001555469
channel: SIP/6789-b5261bc8
phone_code: 1
phone_number: XXXXXXXXXx
call_time: 2014-06-09 17:41:17
call_type: IN
stage: CLOSER-5
last_update_time: 2014-06-09 17:41:22
alt_dial: NONE
queue_priority: 0
agent_only:
agent_grab:
queue_position: 2
extension:
agent_grab_extension:
*************************** 22. row ***************************
auto_call_id: 2380314
server_ip: 11.11.11.11
campaign_id: campaign3
status: CLOSER
lead_id: 1681398
uniqueid: 1402328402.1521015
callerid: Y6091740020001681398
channel: SIP/6789-b52bf970
phone_code: 1
phone_number: XXXXXXXXXx
call_time: 2014-06-09 17:40:02
call_type: IN
stage: CLOSER-0
last_update_time: 2014-06-09 17:40:02
alt_dial: NONE
queue_priority: 2
agent_only:
agent_grab:
queue_position: 1
extension:
agent_grab_extension:
22 rows in set (0.00 sec)