Jump to content


< Back to Forum


 

Mysql Does Not Save The Log


  • Please log in to reply

#1 roman 26 January 2017 - 03:56 AM

I installed MySql to save the call log and VG can comunicate whit it because it creates its tables, but VG was unable to save the log. What is missing? Can you help us?

 

I include the VG log.

 

Regards



#2 SupportTeam 26 January 2017 - 09:44 AM

vgEngine traces shows that the calltrack entries are saved in database.

 

Are you referring to the calltrack table entries or another table?



#3 roman 31 January 2017 - 03:34 AM

Hi Support.

 

The table cdrout is empty and all the others.

 

Thanks



#4 roman 04 February 2017 - 04:44 AM

Hi Support Can you help me?

 

The Mysql Data Base doesn't save any calltrack. Please help me,  I need the statistics.



#5 SupportTeam 05 February 2017 - 06:10 AM

The previously posted traces seem to show that the calltrack table is being updated.
 

eg. from 0124_1022_vgEngine.txt :

103726.502  12               db    Db_UpdateCallTrack call: UPDATE calltrack SET Outcome='Answered_Live', History='dialed@103707, Answered_Live@103726, ', TimeCallAnswered='2017-01-24 10:37:26', RetriesLeft=0 WHERE (QueID=1340 OR QueGUID=@guidDialoutGuid);
103726.504  12               db    Db_UpdateCallTrack returned

Can you please post traces from time when you found that the calltrack table was not updated and we can look at what is happening.

 

Could you maybe also post what data you can actually see saved in the calltrack table? eg output of SQL "select * from calltrack"



#6 roman 24 February 2017 - 06:19 AM

Hi Team.

All the tables are Empty. I erased the database, VG has rebuilded the tables and I made a call. All the tables are empty but I found and error in 0223_1335_vgDialListLoad.txt file at line 224 (The given value was not in a supported format). Can you help me?

Thank you.



#7 SupportTeam 24 February 2017 - 06:52 AM

So that we can replicate your setup can you please advise which version of MySQL is used.

 

What is the language used on this system?

 

Is the MySQL installed locally or remotely? If remotely then is it installed on Windows or on another OS ?

 

( Trace shows that MySql.Data.MySqlClient v6.9.9.0 data connector is used )



#8 SupportTeam 25 February 2017 - 07:29 PM

Looking at the traces we can see that an older version Dialer Loader GUI is used on this system.

 

Could you please do the following:

 

1. Stop VoiceGuide service and exit all programs.

2. Delete file vgDialListLoad.exe from VoiceGuide directory.

3. Run VoiceGuide install of latest version ans install over the top of existing install

4. Stop VoiceGuide service.

5. Unzip attached file and place the .sql file in VoiceGuide's \system\setup\ directory (overwrite existing verison)

6. Drop all tables in the database schema used by VoiceGuide to store details of outgoing calls. (ie. delete all tables)

7. Start VoiceGuide service. (VoiceGuide will now create tables again using the new SQL script)

8. Start Dial List Loader and load some new calls into the system.

 

and please post traces as before if you still encounter problems.



#9 SupportTeam 26 February 2017 - 08:18 PM

When updating system to latest version of VoiceGuide please use this install:

 

[old link removed]

 

This is the latest development build. We can best respond to any provided traces if the latest version is used.