DROPPED PERCENT in real time report not populating

[randy_delgado_03]

Good Day Vicidial Group,

We're currently running an inbound campaign and we noticed that the DROPPED PERCENT in the real time screen is not populating even though we have a high volume of inbound calls and a small group of inbound agents logged in ...

A bit of idea where to start would be highly appreciated ...

Thank You ...

[mflorell]

Is the ASTVDadapt screen running on one of your dialers?

[randy_delgado_03]

Hi Matt,

Yes ASTVDadapt screen is running ...

Here's the active screens on the server:

There are screens on:
16460.ASTVDadapt (Detached)
2625.ASTemail (Detached)
2622.ASTVDautoFILL (Detached)
2619.ASTfastlog (Detached)
2613.ASTVDremote (Detached)
2610.ASTVDauto (Detached)
2607.ASTlisten (Detached)
2604.ASTsend (Detached)
2601.ASTupdate (Detached)
2439.asterisk (Detached)
2433.astshell20160505182821 (Detached)
11 Sockets in /var/run/screens/S-root.

[williamconley]

SVN: Yes

SVN should be a version instead of "Yes/No".

Is this server a fresh install or has it been upgraded? If so, from what version/SVN revision/dbSchema originally?

Have you checked for crashed tables?

Do other values update for the campaign? (Calls made/answered, trunk fill ...)

Is the problem on all campaigns or a specific campaign?

[randy_delgado_03]

Hi William,

As for the SVN, my bad, will update my signature ...

For the following questions:

Is this server a fresh install or has it been upgraded? If so, from what version/SVN revision/dbSchema originally?

Yes this is a fresh install.

Have you checked for crashed tables?

Yes, no crashed tables. Looked into MySQL log.

Do other values update for the campaign? (Calls made/answered, trunk fill ...)

Yes, only the DROPPED and DROPPED PERCENTAGES are not updating.

Is the problem on all campaigns or a specific campaign?

No, however, the other campaign is a outbound campaign and drop is updating ok.

[williamconley]

dropped call is specific to outbound.

inbound calls are not assigned to "campaigns" which have real time screens ... until after they are answered by an agent in a campaign. Since dropped calls never reach an agent, they are never actually assigned to a campaign.

You'll be wanting to look at Inbound Service Level Report.

[randy_delgado_03]

Noted William. But may i ask, what script is feeding the real time report? I mean what script is responsible for computing the values of the real time report?

Thank You ...

[williamconley]

Those values are pulled from tables. Several other scripts contribute. The admin keepalive script (perl script in /usr/share/astguiclient) which runs every minute, I believe, contributes. There may be others. I don't recall offhand whether campaign stats are stored on the campaign record or if there is also a campaign stats table. this may also change based on version.

[randy_delgado_03]

Vicidial Group,

I monitored and dig in to this issue, on the DB side, whenever the call comes in from the ingroup and there's no available agent, it will be tagged as QUEUE on the vicidial_closer_log table, once it gets dropped, the status on the vicidial_list will be updated as DROP but on the vicidial_closer_log its still QUEUE ...

Any thoughts would be highly appreciated ...

Thanks ...

[mflorell]

Have you checked for crashed or corrupted tables in your database?

[randy_delgado_03]

@Matt,

Yes i've checked it already and no crashed table/s so far. The thing is, i'm curious on why on the vicidial_closer_log table, it updates the new queued call as QUEUE but once its already dropped, its not updating the vicidial_closer_log as DROP.

I tested updating manually on one of the newly inserted record on vicidial_closer_log as DROP and it reflected on the real time report ...

[mflorell]

It should only use the status QUEUE if the call is attempting to be sent to an agent. I really don't know why else it would be doing that.