Problem With Voiceguide And Mysql

[bill-r]

Gentlemen:

 

I am running Voiceguide 6.0.3107 Enterprise VGDialer 4 line license with a Dialogic D/41JCT-LS running Drivers Release SR5.11 version DNA5 Build 80 ServicePack1.

 

I have been running off of a Microsoft Access Database and am migrating to MySQL Server version: 5.0.67-0ubuntu6 Protocol Version 10.

 

I am getting an error of:

 

075814.92 2 ERROR 6.0.3107 RunModule line=5840, 13:Type mismatch:VoiceGuide

 

This error occurs using both MySQL Connector versions 3.51 and 5.15.

 

I am able to connect to the MySQL database and execute several small queries before I attempt to execute the large query. The log file is attached.

 

The Access version of the query works using IIf instead of IF when I link the tables using the MySql ODBC connector using DAO. The MySQL version of the query also runs correctly when I test it in a PHPMYADMIN sql window.

 

What am I doing wrong or do I need to upgrade something?

 

Any help would be appreciated.

0409vgm.txt

0409tw.txt

[SupportTeam]

Could you please update to the latest version of VG v6 (v6.0.3386) and post traces from this new version if you are still experiencing a problem.

[bill-r]

I upgraded to v6.0.3386 and I am still having the same problem.

 

111158.81 2 ERROR 6.0.3386 RunModule line=5940, 13:Type mismatch:VoiceGuide

 

Logs are attached.

 

Thanks

0410vgm.txt

0410tw.txt

[SupportTeam]

Trace shows that the insert SQL statement in module [update Call Log] executed fine:

 

111148.53 2 db About to execute a Modify type operation [iNSERT INTO tblCallLog (telephone_number,dnis,line,name,mailbox) VALUES ('3607351900','',2,'',8100)]

111148.53 2 db Modify operation returned OK

111148.53 2 rv add [update Call Log_RowCount]{1}

 

So looks like there is no problem with the ODBC connect string & VG connecting to the MySQL or with the database itself.

 

The select SQL statement in the [Get Last Record Number] module was fine as well, with $RV[Get Last Record Number_1_1] being assigned a value of 2624

 

The next SQL statement to run, in module [Database Query 1] is fairly complex:

 

SELECT tbl_vm_new.mailbox, tbl_vm_new.mailbox_greeting_wavfile, tbl_vm_new.property_address_wavfile, tbl_vm_new.property_description_wavfile, tbl_vm_new.SendNumberEmail, tblwebmap.financing_link, tblwebmap.prequal_link, tblwebmap.CryptKey, tblwebmap.property_type, tblwebmap.property_address, tblwebmap.property_city, tblwebmap.property_state, tblwebmap.property_zip, tblwebmap.offering_price, tblwebmap.info_link, tblwebmap.property_name, tblwebmap.date_added, tbl_tret_users.rp_first_name, tbl_tret_users.rp_last_name, tbl_tret_users.rp_description, IF(tbl_tret_users.rp_description="FSBO","http://www.therealestatetour.net/documents/TRETBrochure.pdf",IF(tbl_tret_users.rp_description="Realtor","http://www.therealestatetour.net/documents/RETourRealtors.pdf",""'>http://www.therealestatetour.net/documents/TRETBrochure.pdf",IF(tbl_tret_users.rp_description="Realtor","http://www.therealestatetour.net/documents/RETourRealtors.pdf","")) AS brochure, tbl_tret_users.rp_email, tbl_tret_loan_officers.lo_first_name, tbl_tret_loan_officers.lo_last_name, tbl_tret_loan_officers.txt_lo_title, tbl_tret_loan_officers.txtCompany, tbl_tret_loan_officers.txtAddress, tbl_tret_loan_officers.txtCity, tbl_tret_loan_officers.txtState, tbl_tret_loan_officers.txtZip, tbl_tret_loan_officers.txtlo_email, tbl_tret_loan_officers.txtwebsite, tbl_tret_loan_officers.lo_telephone1, tbl_tret_loan_officers.lo_telephone1_type, tbl_tret_loan_officers.lo_telephone2, tbl_tret_loan_officers.lo_telephone2_type, tbl_tret_users.rp_txtmessage_email, tbl_vm_new.property_price_wavfile, tbl_tret_loan_officers.txtlo_display_email, tblwebmap.group_name, tbl_vm_new.property_price_wavfile, tbl_vm_new.rp_vm_email,tbl_vm_new.rp_vm_text,tbl_vm_new.rp_info_accessed_email,t

bl_vm_new.rp_info_accessed_text,tbl_vm_new.lo_vm_email, tbl_vm_new.lo_vm_text,tbl_vm_new.lo_info_accessed_email, tbl_vm_new.lo_info_accessed_text,IF(tbl_vm_new.rp_vm_email=-1,tbl_tret_users.rp_email,"") AS rp_vm_email_address,IF(tbl_vm_new.rp_vm_text=-1,tbl_tret_users.rp_txtmessage_email,"") AS rp_txt_message_email_address,IF(tbl_vm_new.rp_info_accessed_email=-1,tbl_tret_users.rp_email,"") AS rp_info_accessed_email_address,IF(tbl_vm_new.rp_info_accessed_text=-1,tbl_tret_users.rp_txtmessage_email,"") AS rp_info_accessed_text_address,IF(tbl_vm_new.lo_vm_email=-1,tbl_tret_loan_officers.txtlo_email,"") AS lo_vm_email_address, IF(tbl_vm_new.lo_vm_text=-1,tbl_tret_loan_officers.txtlo_textmessage_email,"") AS lo_vm_text_address, IF(tbl_vm_new.lo_info_accessed_email=-1,tbl_tret_loan_officers.txtlo_email,"") AS lo_info_accessed_email_address,IF(tbl_vm_new.lo_info_accessed_text=-1,tbl_tret_loan_officers.txtlo_textmessage_email,"") AS lo_info_accessed_text_address,tblwebmap.info_link2,tblwebmap.info_link_label2, tbl_tret_users.UserCryptKey, tblwebmap.offering_price_comment, tbl_tret_users.id_tret_user FROM ((tbl_vm_new LEFT JOIN tblwebmap ON tbl_vm_new.mailbox = tblwebmap.mailbox) INNER JOIN tbl_tret_loan_officers ON tbl_vm_new.id_tret_loan_officer = tbl_tret_loan_officers.id_tret_loan_officer) INNER JOIN tbl_tret_users ON tbl_vm_new.id_tret_user = tbl_tret_users.id_tret_user WHERE tbl_vm_new.mailbox=8100

 

but still completes OK:

 

111158.75 2 db [Database Query 1] row count=1

111158.75 2 rv add [Database Query 1_RowCount]{1}

 

and looks like the error occurs in VG when it tries to save the returned data into the local RVs:

 

111158.77 2 db update RVs

111158.81 2 ERROR 6.0.3386 RunModule line=5940, 13:Type mismatch:VoiceGuide

 

We will look into this and should have an answer available for you within 24 hours.

 

Is one of the returned data a blob? Can you could try reducing the fields returned (down to 1 initially) and gradually increasing the number of fields returned to see which field causes the problem?

 

 

 

111142.92 2 state [update Call Log] DB Query

111142.92 2 db ODBC mode used name:[tret_local] connect:[ODBC;UID=voiceguide;PWD=vgsbrm69]

111148.52 2 rv replace start: [iNSERT INTO tblCallLog (telephone_number,dnis,line,name,mailbox) VALUES ('$RV_CIDNUMBER','$RV_DNIS',$RV_LINEID,'$RV_CIDNAME',$RV[system Welcome])]

111148.52 2 rvns [PathSysVoice]{C:\Program Files\VoiceGuide\system\voice\}[PathApp]{C:\Program Files\VoiceGuide\}[PathDataVm]{C:\Program Files\VoiceGuide\data\}[PathVgSys]{C:\Program Files\VoiceGuide\system\}[$RV_STARTTIME]{4/10/2009 11:11:34 AM}[$RV_DEVICEID]{2}[DlgcNetworkResource]{dxxxB1C2}[DlgcVoiceResource]{dxxxB1C2}

[$RV_CIDNAME]{}[PathApp]{C:\Program Files\VoiceGuide\}[scriptsPath]{C:\Program Files\VoiceGuide\Scripts\TRET4\}[scriptPath]{C:\Program Files\VoiceGuide\Scripts\TRET4\}[$RV_CIDNUMBER]{3607351900}[system Welcome]{8100}[system Welcome_PathTaken]{success}

111148.52 2 rv replace end: [iNSERT INTO tblCallLog (telephone_number,dnis,line,name,mailbox) VALUES ('3607351900','',2,'',8100)]

111148.53 2 db About to execute a Modify type operation [iNSERT INTO tblCallLog (telephone_number,dnis,line,name,mailbox) VALUES ('3607351900','',2,'',8100)]

111148.53 2 db Modify operation returned OK

111148.53 2 rv add [update Call Log_RowCount]{1}

111148.53 2 next module is [Get Last Record Number] (idx=44)

111148.53 2 RunModule start [Database Query,[Get Last Record Number],44,,]

111148.53 2 timer clear bForceClear=False

111148.53 2 state [Get Last Record Number] DB Query

111148.55 2 db ODBC mode used name:[tret_local] connect:[ODBC;UID=voiceguide;PWD=vgsbrm69]

111153.63 2 db About to execute a Retrieve type operation [sELECT Max(ID) AS LastRecordNumber FROM tblCallLog;]

111153.63 2 db [Get Last Record Number] row count=1

111153.63 2 rv add [Get Last Record Number_RowCount]{1}

111153.63 2 db get RecordsetGetRowsMax

111153.63 2 db get 999 records. (row count=1)

111153.64 2 db update RVs

111153.64 2 db about to close dbDbqDatabase

111153.64 2 db going down path [True]

111153.64 2 next module is [Database Query 1] (idx=38)

111153.64 2 RunModule start [Database Query,[Database Query 1],38,,]

111153.64 2 timer clear bForceClear=False

111153.64 2 state [Database Query 1] DB Query

111153.66 2 db ODBC mode used name:[tret_local] connect:[ODBC;UID=voiceguide;PWD=vgsbrm69]

111158.72 2 rv replace start (strlen>1000)

111158.72 2 rvns [PathSysVoice]{C:\Program Files\VoiceGuide\system\voice\}[PathApp]{C:\Program Files\VoiceGuide\}[PathDataVm]{C:\Program Files\VoiceGuide\data\}[PathVgSys]{C:\Program Files\VoiceGuide\system\}[$RV_STARTTIME]{4/10/2009 11:11:34 AM}[$RV_DEVICEID]{2}[DlgcNetworkResource]{dxxxB1C2}[DlgcVoiceResource]{dxxxB1C2}

[$RV_CIDNAME]{}[PathApp]{C:\Program Files\VoiceGuide\}[scriptsPath]{C:\Program Files\VoiceGuide\Scripts\TRET4\}[scriptPath]{C:\Program Files\VoiceGuide\Scripts\TRET4\}[$RV_CIDNUMBER]{3607351900}[system Welcome]{8100}[system Welcome_PathTaken]{success}[update Call Log_RowCount]{1}[Get Last Record Number_RowCount]{1}[Get Last Record Number_1_1]{2624}

111158.73 2 db About to execute a Retrieve type operation [sELECT tbl_vm_new.mailbox, tbl_vm_new.mailbox_greeting_wavfile, tbl_vm_new.property_address_wavfile, tbl_vm_new.property_description_wavfile, tbl_vm_new.SendNumberEmail, tblwebmap.financing_link, tblwebmap.prequal_link, tblwebmap.CryptKey, tblwebmap.property_type, tblwebmap.property_address, tblwebmap.property_city, tblwebmap.property_state, tblwebmap.property_zip, tblwebmap.offering_price, tblwebmap.info_link, tblwebmap.property_name, tblwebmap.date_added, tbl_tret_users.rp_first_name, tbl_tret_users.rp_last_name, tbl_tret_users.rp_description, IF(tbl_tret_users.rp_description="FSBO","http://www.therealestatetour.net/documents/TRETBrochure.pdf",IF(tbl_tret_users.rp_description="Realtor","http://www.therealestatetour.net/documents/RETourRealtors.pdf","")) AS brochure, tbl_tret_users.rp_email, tbl_tret_loan_officers.lo_first_name, tbl_tret_loan_officers.lo_last_name, tbl_tret_loan_officers.txt_lo_title, tbl_tret_loan_officers.txtCompany, tbl_tret_loan_officers.txtAddress, tbl_tret_loan_officers.txtCity, tbl_tret_loan_officers.txtState, tbl_tret_loan_officers.txtZip, tbl_tret_loan_officers.txtlo_email, tbl_tret_loan_officers.txtwebsite, tbl_tret_loan_officers.lo_telephone1, tbl_tret_loan_officers.lo_telephone1_type, tbl_tret_loan_officers.lo_telephone2, tbl_tret_loan_officers.lo_telephone2_type, tbl_tret_users.rp_txtmessage_email, tbl_vm_new.property_price_wavfile, tbl_tret_loan_officers.txtlo_display_email, tblwebmap.group_name, tbl_vm_new.property_price_wavfile, tbl_vm_new.rp_vm_email,tbl_vm_new.rp_vm_text,tbl_vm_new.rp_info_accessed_email,t

bl_vm_new.rp_info_accessed_text,tbl_vm_new.lo_vm_email, tbl_vm_new.lo_vm_text,tbl_vm_new.lo_info_accessed_email, tbl_vm_new.lo_info_accessed_text,IF(tbl_vm_new.rp_vm_email=-1,tbl_tret_users.rp_email,"") AS rp_vm_email_address,IF(tbl_vm_new.rp_vm_text=-1,tbl_tret_users.rp_txtmessage_email,"") AS rp_txt_message_email_address,IF(tbl_vm_new.rp_info_accessed_email=-1,tbl_tret_users.rp_email,"") AS rp_info_accessed_email_address,IF(tbl_vm_new.rp_info_accessed_text=-1,tbl_tret_users.rp_txtmessage_email,"") AS rp_info_accessed_text_address,IF(tbl_vm_new.lo_vm_email=-1,tbl_tret_loan_officers.txtlo_email,"") AS lo_vm_email_address, IF(tbl_vm_new.lo_vm_text=-1,tbl_tret_loan_officers.txtlo_textmessage_email,"") AS lo_vm_text_address, IF(tbl_vm_new.lo_info_accessed_email=-1,tbl_tret_loan_officers.txtlo_email,"") AS lo_info_accessed_email_address,IF(tbl_vm_new.lo_info_accessed_text=-1,tbl_tret_loan_officers.txtlo_textmessage_email,"") AS lo_info_accessed_text_address,tblwebmap.info_link2,tblwebmap.info_link_label2, tbl_tret_users.UserCryptKey, tblwebmap.offering_price_comment, tbl_tret_users.id_tret_user FROM ((tbl_vm_new LEFT JOIN tblwebmap ON tbl_vm_new.mailbox = tblwebmap.mailbox) INNER JOIN tbl_tret_loan_officers ON tbl_vm_new.id_tret_loan_officer = tbl_tret_loan_officers.id_tret_loan_officer) INNER JOIN tbl_tret_users ON tbl_vm_new.id_tret_user = tbl_tret_users.id_tret_user WHERE tbl_vm_new.mailbox=8100]

111158.75 2 db [Database Query 1] row count=1

111158.75 2 rv add [Database Query 1_RowCount]{1}

111158.75 2 db get RecordsetGetRowsMax

111158.75 2 db get 999 records. (row count=1)

111158.77 2 db update RVs

111158.81 2 ERROR 6.0.3386 RunModule line=5940, 13:Type mismatch:VoiceGuide

111158.81 2 HangupCall start (RunModule Error line=5940)

111158.81 2 rv add [Hangup Time]{4/10/2009 11:11:58 AM}

111158.81 2 state Hanging up call... [RunModule Error line=5940]

 

[bill-r]

Problem fixed! A field, tblwebmap.info_link is treated as a memo field in Access. In MySQL it was mapped as medium text. So when the MySQL table is linked in Access it still gets translated as a memo field in DAO. But when ODBC uses the field it is medium text. Changing the field type to varchar fixed the problem.

[SupportTeam]

So when the MySQL table is linked in Access it still gets translated as a memo field in DAO. But when ODBC uses the field it is medium text. Changing the field type to varchar fixed the problem.

Thanks for letting us know that this issue was fixed and details of what the problem and the fix was.