bill-r Report post Posted 04/09/2009 03:46 PM 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 Share this post Link to post
SupportTeam Report post Posted 04/09/2009 08:40 PM 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. Share this post Link to post
bill-r Report post Posted 04/10/2009 06:19 PM 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 Share this post Link to post
SupportTeam Report post Posted 04/10/2009 10:03 PM 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] Share this post Link to post
bill-r Report post Posted 04/11/2009 01:01 AM 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. Share this post Link to post
SupportTeam Report post Posted 04/11/2009 04:12 AM 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. Share this post Link to post