MM:SS issue in Realtime report

[maxhbp204]

Hi,
I was using vicidial 2.0.5 and now i have upgraded database and scripts as per the given upgrade procedure,
All is fine with upgrade and calls are also going fine,
I have upgraded to trunk VERSION: 2.4-275
And asterisk 1.4
I have two issues with realtime screen page.

1) When i was making calls and it is working fine that time I have seen the MM:SS results which is not updating it is keeping 00:0,
I have also tried to debug that too, in newer version it is having sec_convert from functions.php.
I have also seen the database from the query and values it is not taking proper values or some other issue which i didn't get.

2) And all realtime campaign page i am not getting all the campaigns values like DROPPED/ANSWERED, DIFF etc.. some fields are filling on some campaigns and some are not,
And on the same page i am getting all the values of the other campaign as well,
So is there any issue with this?

[mflorell]

Which version of Asterisk 1.4 are you using?

Did you first upgrade to 2.2.1 then to the latest 2.4 version?

I am having a hard time understanding the exact problems you are having, can you describe in more detail please?

[williamconley]

when you post, please post your entire configuration including (but not limited to) your installation method, vicidial version and build, asterisk version, telephony hardware (model number is helpful here), cluster information if you have one, and whether any other software is installed in the box.

Similar to This:
Vicibox X.X from .iso | Vicidial X.X.X Build XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation

this IS a requirement for posting along with reading the stickies (at the top of each forum) and the manager's manual (available on EFLO.net, both free and paid versions)
___________

When you upgraded, what instructions did you follow? (link or filename if you used something from the download).

Did you skip any steps, watch for or see any errors?

[maxhbp204]

Hello,
Thanks for reply,
Here is the informaton regarding my vicidial server,
Sever is centos 5.4.
Asterisk 1.4.21.2
Vicidial VERSION: 2.4-275
BUILD: 100817-1243
Single server
No digium/Hardware on server.
No extra software running.

I am really sorry if i missed out this points.
I have installed 2.0.5 from scratch installation and After successfully using I have upgraded with latest trunk version described above.

I have upgraded database from 2.0.5 to 2.2.4 and then 2.4 version, I mean I have followed all the steps of upgrade in database too without any issue.

Let me describe the details again.
1) I have four campaings and I am checking realtime report of that all,
In that I am not getting all the values on first Two and getting all the values of last two.
---------------------------------------------------

CAMPID1 - Modify
DIAL LEVEL: 0 TRUNK SHORT/FILL: / 0 FILTER: NONE TIME: 2010-09-03 11:19:50
DIALABLE LEADS: 126 CALLS TODAY: 0 AVG AGENTS: 0 DIAL METHOD: MANUAL
HOPPER LEVEL: 50 DROPPED / ANSWERED: 0 / 0 DL DIFF: 0 STATUSES: N, NI, NA, ERI, CALLBK, DROP, DC, B, A, AM, AA, NEW
LEADS IN HOPPER: 92 DROPPED PERCENT: 0% DIFF: 0.00% ORDER: DOWN
NO LIVE CALLS WAITING NO AGENTS ON CALLS

closer - Modify
DIAL LEVEL: 1.0 TRUNK SHORT/FILL: 0 / 0 FILTER: NONE TIME: 2010-09-03 11:19:50
DIALABLE LEADS: 0 CALLS TODAY: 0 AVG AGENTS: 1 DIAL METHOD: RATIO
HOPPER LEVEL: 5 DROPPED / ANSWERED: 0 / 0 DL DIFF: 0 STATUSES: NEW
LEADS IN HOPPER: 0 DROPPED PERCENT: 0% DIFF: 0.00% ORDER: DOWN
NO LIVE CALLS WAITING NO AGENTS ON CALLS

INBOU2_I - Modify
DIAL LEVEL: 6 TRUNK SHORT/FILL: 0 / 0 FILTER: NONE TIME: 2010-09-03 11:19:50
DIALABLE LEADS: 11417 CALLS TODAY: 3180 AVG AGENTS: 7.55 DIAL METHOD: RATIO
HOPPER LEVEL: 2000 DROPPED / ANSWERED: 743 / 897 DL DIFF: -1.8 STATUSES: DROP, NA, B, XDROP, N, CALLBK, A, NEW
LEADS IN HOPPER: 3474 DROPPED PERCENT: 82.83% DIFF: -23.84% ORDER: DOWN
28 current active calls 27 calls ringing 0 calls waiting for agents 0 calls in IVR
8 agents logged in 4 agents in calls 2 agents waiting 2 paused agents


INBOU_I - Modify
DIAL LEVEL: 5 TRUNK SHORT/FILL: 0 / 0 FILTER: NONE TIME: 2010-09-03 11:19:50
DIALABLE LEADS: 9607 CALLS TODAY: 1133 AVG AGENTS: 5.2 DIAL METHOD: RATIO
HOPPER LEVEL: 2000 DROPPED / ANSWERED: 68 / 108 DL DIFF: 2.3 STATUSES: XDROP, NA, N, DROP, A, CALLBK, B, NEW
LEADS IN HOPPER: 2139 DROPPED PERCENT: 62.96% DIFF: 44.23% ORDER: DOWN
17 current active calls 17 calls ringing 0 calls waiting for agents 0 calls in IVR
5 agents logged in 2 agents in calls 2 agents waiting 1 paused agents

---------------------------------------------------
Second issue is related to MM:SS values, Here is the live report data,
It is refreshing and updating properly but not updating MM:SS value.

----------------------------------------------------
VICIDIAL: Agents Time On Calls Campaign: |INBOU2_I| 2010-09-03 11:21:28
+----------------+------------------------+-----------+----------+---------+------------+-------+------+------------------
| STATION | USER SHOW ID INFO | SESSIONID | STATUS | MM:SS | CAMPAIGN | CALLS | HOLD | IN-GROUP
+----------------+------------------------+-----------+----------+---------+------------+-------+------+------------------
| SIP/1017 | 1017 + | 8600065 | INCALL I | 0:00 | INBOU2_I | 40 | 6 | inbound2 - inbound2
| SIP/1015 | 1015 + | 8600055 | INCALL A | 0:00 | INBOU2_I | 186 |
| SIP/1014 | 1014 + | 8600059 | INCALL A | 0:00 | INBOU2_I | 270 |
| SIP/1012 | 1012 + | 8600060 | INCALL A | 0:00 | INBOU2_I | 255 |
| SIP/1016 | 1016 + | 8600053 | INCALL A | 0:00 | INBOU2_I | 300 |
| SIP/1011 | 1011 + | 8600062 | PAUSED | 0:00 | INBOU2_I | 216 |
| SIP/1019 | 1019 + | 8600054 | DISPO | 0:00 | INBOU2_I | 170 |
| SIP/1018 | 1018 + | 8600056 | DISPO | 0:00 | INBOU2_I | 277 |
+----------------+------------------------+-----------+----------+---------+------------+-------+------+------------------
8 agents logged in on all servers
----------------------------------------
Please suggest me!
Thanks,

[maxhbp204]

Can any body provide me some help please!!
Thanks.

[williamconley]

sorry, scratch installs take too long to troubleshoot for oddities. i haven't had time to formulate any questions for this issue.

have you tried creating new campaigns to see if new ones work correctly?

why did you scratch install instead of using vicidialnow or vicibox?

also:

When you upgraded, what instructions did you follow? (link or filename if you used something from the download).

which of these campaigns did you create before or after the upgrade?

[maxhbp204]

Thanks for reply,
I will try with vicibox too,
I have created this campaigns before upgrading,
I will check with new campaigns with the same.

Thanks

[williamconley]

FYI: if you back up your database, build the new system, make sure the new system works properly, then restore your database ... you will have all your data AND you will find out if your data causes a problem on restore (in which case you can export and import instead of backup/restore and you will resolve the problem).

that way you have a clean system, standard, AND your data.