Vicidial_log status not getting updated

[konextu]

When a call is placed in creates the vicidial_log entry and marks it as INCALL, after the call is done and the REP dispositions the call it updates the STATUS column on vicidial_list but never creates/updates a log record for the call. I've seen this work on other systems. The issue is its causing all reporting to be way off. It seems like only system generated statuses are working (E.G. INCALL, QUEUE, DC, NA, etc) but nothing that i created is working, however it does update the actual lead under list, odd?

Thanks.

I have deleted all statuses and recreated by hand, that didnt help. I also have verified the existence of extension h in all context's of the dialplan, and i see no error's at all on the asterisk CLI with agi logging set to both. I'm kinda lost on this one.

Thanks guys and gals.

[mcargile]

vicidial.php version and build number please.

Also, Vicidial has had a number of log reporting issues fixed in the SVN code base (soon to be 2.0.5). Some of the bug fixes were back ported to 2.0.4 svn branch while others were far too complex or would have required changes to the database in order to implement in 2.0.4.

[konextu]

Running the latest in trunk as always

VERSION: 2.0.5-164 BUILD: 90210-1042

[mcargile]

What kind of calling are you doing?

Does the problem happen with just a single agent logged in?

Try editing the vdc_db_query.php script and change this line:

Code: Select all

$mel=1;               # Mysql Error Log enabled = 1


to:

Code: Select all

$mel=2;               # Mysql Error Log enabled = 1


There should be a file called vicidial_mysql_errors.txt in the agc directory. See if there are any errors in that file.

[konextu]

AutoDialing, have done adaptive and ratio. Using IAX Trunks. Problem happens when just a single agent is logged in. I'll try changing that script.

Logs looked clean. no errors logged

[konextu]

This is way to weird. Vicidial_list is updating with the correct status but vicidial_log isnt.

I've Tried:

-different web servers
-new users
-single users
-clearing the log table (after backup of course)

The issue is reports are not showing any of the other statuses, and its causing call's to get logged as INCALL and therefor alt dialing is hitting other numbers even though the call has been disposition'd in a way we stop calling.

Any ideas? I need some serious help here guys.

Thanks.

[mflorell]

I fixed a related issue in SVN a few days ago, try updating SVN trunk and see if that fixes it for you.

[konextu]

Updated the latest in SVN trunk and its still happening. which script or process updates the log file when the agent dispo's the call?

[mflorell]

Are you seeing any errors in the Firefox Error Console when this happens?

The agc/vdc_db_query.php script is where the dispo is updated.

[konextu]

The agents are using IE6. I tried with Firefox and the error log is clean (in regards to the vicidial). Crazy part is there are no error's in the vicidial_mysql_errors.txt file either.

Which script updates the leads to INCALL, NA, DROP status?

[konextu]

After reviewing the log when change MEL to 2 there are only two update commands i see in the vicidial_mysql_errors.txt being issued in regards to vicidial_log, for each call.:

Code: Select all

2009-03-03 10:48:57|vdc_db_query|00090|0||UPDATE vicidial_log set term_reason='AGENT', end_epoch='1236098937', length_in_sec='90' where uniqueid='1236098834.24732' and lead_id='87835' and user='2140' order by call_date desc limit 1;|2140|10.1.2.17|1236097781_214015374139|

and

Code: Select all

2009-03-03 10:48:59|vdc_db_query|00113|0||UPDATE vicidial_log set user='2222', comments='AUTO', list_id='3135', status='INCALL', user_group='Cycle1' where lead_id='87854' and uniqueid='1236098919.25100';|2222|10.1.2.17|1236097304_222212649495|

I do not see where it goes back and adds in the disposition to the vicidial_log table. Only the original. Yes these are two seperate leads but I wanted to show one that ran longer (length of call) as well.

THanks

Hope this might help

KG

[mflorell]

This is a very strange problem, I have never seen this happen before at any of our client sites. I am guessing for some reason that the updateDISPO function in vdc_db_query.php is not running. I don't really know why, but the problem might be related to that somewhere.

[konextu]

Does it require any special perl modules? i'll dig and see how it works maybe its linked to something..

[konextu]

Ok maybe i missed something. Its updating vicidial_closer_log but not the regular log. Did i miss something big?

[mflorell]

Is this on an inbound call or an outbound call?

[konextu]

I dont see inbounds in the vicidial_log. Outbounds are not getting the status change. sorry for the confusion.

[mflorell]

That's correct, inbound calls are only supposed to be logged to the vicidial_closer_log table, and outbound calls should only be logged to the vicidial_log table.

[konextu]

Not sure if this helps either. I notice quite a few calls (over half) in vicidial_log having a list_id of NULL but when searching for the "lead" in admin.php it clearly show's its list ID.

[konextu]

For whatever reason creating new campaigns fixed the problem.

[mflorell]

That's a strange one, maybe some of the required campaign tables were not present.

[konextu]

No doubt my friend. The only thing i can think of is somehow it screwy in the upgrade process, i've literally tore this thing down and rebuilt it 5 times.