report problems vicidial_log and vicidial_agent_log

[telconetcol]

Hi.
I have had many troubles with the reports (Differente from vicidial_log and from vidicial_agent_log
I am using sip trunk. these are the sympthoms:

1. If I call to a number that doesn´t exist or is disconnected, that call is not written into the vicidial_log, but yes in the vicidial_agent_log.
2. these calls never activate the live call button in the vicidial.php page.
3. Despite of giving a dispo for the call, the information is not keept in the vicidial_log
4. lloking into the asterisk i see:

for a complete call:

== Parsing '/etc/asterisk/manager.conf': Found
== Manager 'sendcron' logged on from 127.0.0.1
-- Executing MeetMe("Local/8600051@default-0f07,2", "8600051|F") in new stack
> Channel Local/8600051@default-0f07,1 was answered.
-- Executing AGI("Local/8600051@default-0f07,1", "agi://127.0.0.1:4577/call_log") in new stack
-- AGI Script agi://127.0.0.1:4577/call_log completed, returning 0
-- Executing Dial("Local/8600051@default-0f07,1", "SIP/teles/573137591275|20|tTo") in new stack
-- Called teles/573137591275
-- SIP/teles-08228a98 is making progress passing it to Local/8600051@default-0f07,1
== Manager 'sendcron' logged off from 127.0.0.1
-- SIP/teles-08228a98 is making progress passing it to Local/8600051@default-0f07,1
-- SIP/teles-08228a98 is ringing
-- SIP/teles-08228a98 is making progress passing it to Local/8600051@default-0f07,1
== Parsing '/etc/asterisk/manager.conf': Found
== Manager 'sendcron' logged on from 127.0.0.1
== Parsing '/etc/asterisk/manager.conf': Found
== Manager 'sendcron' logged on from 127.0.0.1
== Manager 'sendcron' logged off from 127.0.0.1
-- SIP/teles-08228a98 answered Local/8600051@default-0f07,1
== Manager 'sendcron' logged off from 127.0.0.1
== Parsing '/etc/asterisk/manager.conf': Found
== Manager 'sendcron' logged on from 127.0.0.1
== Spawn extension (default, 3137591275, 2) exited non-zero on 'Local/8600051@default-0f07,1'
-- Executing DeadAGI("Local/8600051@default-0f07,1", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16-----ANSWER-----13-----4") in new stack
-- AGI Script agi://127.0.0.1:4577/call_log--HVcauses ... --13-----4 completed, returning 0
== Spawn extension (default, 8600051, 1) exited non-zero on 'Local/8600051@default-0f07,2'
-- Executing DeadAGI("Local/8600051@default-0f07,2", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----0---------------") in new stack
-- AGI Script agi://127.0.0.1:4577/call_log--HVcauses ... ---------- completed, returning 0
== Parsing '/etc/asterisk/manager.conf': Found
== Manager 'sendcron' logged on from 127.0.0.1
== Manager 'sendcron' logged off from 127.0.0.1
== Manager 'sendcron' logged off from 127.0.0.1


those are the statements used against the database:
INSERT INTO vicidial_log (uniqueid,lead_id,list_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,comments,processed,user_group,alt_dial) values('1228787333.175','256','101','OUT003','2008-12-08 20:49:00','1228787340','INCALL','0','3137591275','ag10c1','MANUAL','N','Agentes0','');
UPDATE vicidial_log set term_reason='AGENT', end_epoch='1228787346', length_in_sec='6' where uniqueid='1228787333.175' and lead_id='256' and user='ag10c1' order by call_date desc limit 1;
UPDATE vicidial_log set status='SALE' where lead_id='256' and user='ag10c1' order by uniqueid desc limit 1;




for a wrong call (to a bad numbr or disconnected number)[/b]

== Manager 'sendcron' logged on from 127.0.0.1
-- Executing MeetMe("Local/8600051@default-0fea,2", "8600051|F") in new stack
> Channel Local/8600051@default-0fea,1 was answered.
-- Executing AGI("Local/8600051@default-0fea,1", "agi://127.0.0.1:4577/call_log") in new stack
-- AGI Script agi://127.0.0.1:4577/call_log completed, returning 0
-- Executing Dial("Local/8600051@default-0fea,1", "SIP/teles/573137591273|20|tTo") in new stack
-- Called teles/573137591273
-- SIP/teles-081dd848 is making progress passing it to Local/8600051@default-0fea,1
== Manager 'sendcron' logged off from 127.0.0.1
-- SIP/teles-081dd848 is circuit-busy
== Everyone is busy/congested at this time (1:0/1/0)
== Parsing '/etc/asterisk/manager.conf': Found
== Manager 'sendcron' logged on from 127.0.0.1
-- Executing DeadAGI("Local/8600051@default-0fea,1", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----1-----CONGESTION----------") in new stack
-- AGI Script agi://127.0.0.1:4577/call_log--HVcauses ... ---------- completed, returning 0
== Spawn extension (default, 8600051, 1) exited non-zero on 'Local/8600051@default-0fea,2'
-- Executing DeadAGI("Local/8600051@default-0fea,2", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----0---------------") in new stack
-- AGI Script agi://127.0.0.1:4577/call_log--HVcauses ... ---------- completed, returning 0
== Manager 'sendcron' logged off from 127.0.0.1
call1*CLI>

statements over the db for vicidial_log:
no output for the vicidial_log table statements.


I can see that when we get busy signal from asterisk, the call is not appearing into vicidial_log. In the other cases yes.

So the differences between the campaign reports and the agent reports are huge.

I have tried many things, but I haven´t been able to fix it up.

I would be so grateful if someone can help with that.

Thanks

[mflorell]

astguiclient version?

[telconetcol]

2.0.5 188 but i have seen it in previous versions.

[mflorell]

Is this a manual call? If so, how are you initiating it?

[telconetcol]

sorry. i missed.

Yes we are using manual dial. As soon a We receive the next lead from database, we try to dial using the dial now link.
When the calls dont reach succes, the reult is the same always. No live call, congestion from asterisk, hangup customer and make dispo call, no appearing in the vicidial_log but yes in vicidial_agent_log.

Thanks for your replies.

[mflorell]

Sounds like a bug, I will try to duplicate and post my results.

[telconetcol]

Matt,

which one version do you suggest me for using?

I have had troubles with reports as well in the past with oldest versions.

When asterisk answers congestion/busy to vicidial, some time has function properly the call disposition for those calls??

Thanks again.

If i downgrade to that version (an older version), can i keep the db unmodified, taking into account the changes that i made for the version using this moment?? sql_upgrade??

[mflorell]

database versions need to stay with the code that you are using. Older code will not work properly with newer database schema.

[telconetcol]

Ok _Matt.....

What version could i use?? We need a stable version despite of not having the last features.

[mflorell]

The latest version is "stable" even if it is not perfect. This is one bug that you are having issues with and it is not somethign that is preventing the system from running.

[telconetcol]

the svn (trunk) may be used or should i prefer using the 2.0.4 version?


that was the question, actually.


Anway thanks mat.. We´ll be waiting for some good news...

[mflorell]

We install SVN trunk at all client sites that we maintain. It has more accurate logging overall than 2.0.4 and a lot more features.

[mflorell]

I worked on this bug tonight in the SVN/trunk code-base and found the exact opposite problem, issues with writing to the agent log, not the vicidial log.

I have fixed it and tested it in many cases and seems to work fine on my test system.

For calls that end as Busy, Disconnected or NA(Ring No Answer) by the carrier the system will automatically give it the carrier statuses in the vicidial_log table even when in Manual dial.

[telconetcol]

Matt.

What special topic can i check for having the states NA, DC etc. automatically??

I haven´t been able to achieve it.
I use sip trunks to net2phone for calling outside.

How can i get the latest svn versions??

Thanks for your replies!!!!

[mflorell]

NA always works if you r system is configured properly, DC is a bit more inconsistent depending on your carrier and the carrier of the person you are calling. Both of those are handled by the FastAGI_log process when a call is Hungup or hangs up.

[telconetcol]

If no one answer a call, wouldn't I have to make call dispo or which one would be the process??

[mflorell]

For manual dial calls, yes you do have to disposition every call, but if you disposition it before the channel hangs up then it will be overwritten as an NA.

[schernit]

I have exactly the same bug but I have also another one. With some numbers (destinations) I receive the green live call message when ringing and with other numbers I don´t.

When having the green messagge the call is recorded on vicidial_log so I don´t have the first bug but I think It shouldn´t work on this way. I mean, when ringing no live call message should appear.

What should I do ?

I always call using the same carrier and using MANUAL DIALING.

Regards,

Sebastian

[mflorell]

vicidial.php version and build?