VoiceGuide IVR Software Main Page
Jump to content

Type Mismatch On Db Query

By Guest Gabe, in General

Recommended Posts

Guest Gabe   

Posted

Hi, I've just set up VoiceGuide and have it connecting to a remote MySQL database. If I query a numeric field and enter the RV in the 'Text to Speak' field everything works fine. However, if I query a field containing text I get the below 'type mismatch' error. I've tried putting the RV in double quotes and single quotes with no luck. By the way, text to speech works fine if I just type in the text, but not from the RV. Thanks for your help!

 

232232.06  0 [Access Query] DB Query
232232.06  0 db    ODBC mode used 
232253.52  0 rv    replace start: [SELECT pr_description FROM property WHERE pr_property_id='$RV[Get Product Code]']
232253.52  0 rv    ns [PathSysVoice]{}[PathApp]{C:\Program Files\VoiceGuide\}[PathDataVm]{C:\Program Files\VoiceGuide\data\}[PathVgSys]{C:\Program Files\VoiceGuide\system\}[ScriptsPath]{C:\Program Files\VoiceGuide\Scripts\Customer Enquiry\}[ScriptPath]{C:\Program Files\VoiceGuide\Scripts\Customer Enquiry}[$RV_STARTTIME]{9/7/2004 11:22:19 PM}[$RV_DEVICEID]{0}[$RV_CIDNAME]{}[PathApp]{C:\Program Files\VoiceGuide\}[$RV_CIDNUMBER]{}[Select Query]{1}[Get Product Code]{5}[Get Product Code_PathTaken]{success}
232253.52  0 rv    replace end: [SELECT pr_description FROM property WHERE pr_property_id='5']
232253.52  0 db    About to execute a Retrieve type operation [SELECT pr_description FROM property WHERE pr_property_id='5']
232253.59  0 db    [Access Query] row count=1
232253.59  0 rv    add [Access Query_RowCount]{1}
232253.59  0 db    get RecordsetGetRowsMax
232253.61  0 db    get 999 records. (row count=1)
232253.61  0 db    update RVs
232253.61  0 ERROR 5.2.3018 RunModule:0:13:Type mismatch:VoiceGuide
232253.61  0 rv    add [Hangup Time]{9/7/2004 11:22:53 PM}
232253.61  0 Hanging up call... [RunModule Error]

Share this post

Link to post

Guest jusedawg   

Posted

If pr_property_id is numeric in the database, then the quotes around the ID will cause your type mismatch.

Share this post

Link to post

Guest Gabe   

Posted

Hi, thanks for your response. I've tried it both ways and the results are the same. This problem seems almost identical to this post. Like this user, I am also using MySQL with the ODBC driver from the MySQL website. Any other ideas? I've tried everything I can think of...

Share this post

Link to post

Guest jusedawg   

Posted

What version of the database are you using?

 

What version of the ODBC driver are you using?

 

If you could post the code it might be easier to debug the situation.

 

From dealing with mySQL on other projects, it has done some little quarky things like this.

Share this post

Link to post

Guest Gabe   

Posted

MySQL Version: 4.0.20

ODBC Driver Version: 3.51.9

 

I'll post the code as soon as I can, as I'm not in front the right computer at the moment.

 

A couple other notes, the field type of pr_description is varchar. I tried casting it as a char ( CAST(pr_description AS CHAR) ) with no luck. I'm going to try other column types and see what works and what doesn't. So far:

 

decimal: works

varchar: type mismatch

 

 

Thanks for your help...

Share this post

Link to post

Guest Gabe   

Posted

Ok, here is some more information and one correction from my previous post - varchar does work, text doesn't. See below:

 

MySQL Version: 4.0.20

ODBC Driver Version: 3.51.9

 

The MySQL column types I've tested so far:

TEXT - ERROR 5.2.3018 RunModule:0:13:Type mismatch:VoiceGuide

MEDIUMTEXT - ERROR 5.2.3018 RunModule:0:13:Type mismatch:VoiceGuide

DECIMAL - works

VARCHAR - works

ENUM - works

CHAR - works

MEDIUMINT - works

 

Following are my VGS, vgm.txt, and tw.txt files. Thanks for any help or insight into this problem.

 

VGS:

Version=5.0
DefaultModuleDisplayHeight=
StartModule=GetListingID
RunAtHangup=
StartWithoutAnswer=0
CtmAsiName=

[GetListingID]
Type=Get Numbers
DispSize=69
Txt=Get the listing id
PlayFile1=C:\_ Files\VG_sound_files\enter_listing_id.wav
Replay=0,0
GetNbrLen_Min=0
GetNbrLen_Max=0
Confirm=OFF
VbScript=
VbsHoldPlay=
on {Success} goto [MySQLQuery]

Position=226,55

[ReadDescription]
Type=Play
DispSize=69
Txt=Play a sound file, then await a response...
Replay=2,5
strTtsText=The following is the description of the listing ID that you requested $RV[MySQLQuery_1_1].  Press one to enter another listing ID.  Press 2 to end this call.
on {1} goto [GetListingID]
on {2} goto [HangupCall]

Position=250,363

[HangupCall]
Type=Hangup the Call
DispSize=69
Txt=Hangup the call.

Position=251,505

[MySQLQuery]
Type=Database Query
DispSize=69
Txt=Query the database
DbDatabase=MichiganEhomes
DbUser=
DbConnectString=ODBC;DSN=MichiganEhomes;UID=MYUID;PWD=MYPASS;SRVR=t:machine:p66;
DbSql=SELECT pr_description FROM property WHERE pr_property_id=$RV[GetListingID]
on {success} goto [ReadDescription]

Position=241,212

 

 

vgm.txt: (error at 111250.44)

111200.38  0 ApiMode=[TAPI]
111200.39  0 Tapi device 8 is: H323 Line
111200.41  0 Tapi device 7 is: IPCONF LINE
111200.41  0 Tapi device 6 is: LPT1T
111200.41  0 Tapi device 5 is: WAN Miniport (L2TP)
111200.41  0 Tapi device 4 is: WAN Miniport (ATW) 2
111200.41  0 Tapi device 3 is: WAN Miniport (ATW) 1
111200.41  0 Tapi device 2 is: RAS VPN Line 0
111200.41  0 Tapi device 1 is: RAS PPPoE Line0000
111200.41  0 Tapi device 0 is: Conexant HSF V92 56K RTAD Speakerphone PCI Modem
111200.42  0 init  vgmulti ver 5.2.3018
111200.45  0 Inband Signaling Config file not specified
111200.45  0 Loading VMB data begin
111200.45  0 Loading VMB data - about to delete old entries
111200.47  0 Loading VMB data - sorting/ordering
111200.47  0 Loading VMB data end
111200.53  0 init  clear settings on 1 devices.
111200.53  0 Initialising...
111200.53  0 init  attach vgs on 1 devices.
111200.53  0 Script Load C:\_ Files\VG_scripts\get_description.vgs
111200.53  0 init  lineopen on 1 devices.
111200.53  0 Calling .lineOpen on device 1
111201.09  0 lineOpen(0)=>
111201.09  0 Calling .GetLineHandle on LineId 0
111201.09  0 hLine=66239
111201.09  0 Calling .GetProviderInfo on LineId 0
111201.09  0 tapi  ProviderInfo: Windows Telephony Service Provider for Universal Modem Driver
111201.09  0       set provider type: PROVTYPE_MODEM
111201.09  0 Calling lineSetNumRings on lLineHandle 66239
111201.09  0 Waiting for a call...
111212.55  0 callstate OFFERING 66188 0 4
111212.55  0 ring 1
111218.58  0 ring 2
111218.58  0 Answer the call at 9/11/2004 11:12:18 AM
111218.58  0 lineAnswer(66188) => 66171
111218.58  0 callstate ACCEPTED 66188 0 0
111218.64  0 tapi  Reply (LineEvReply) ok 66171 0
111218.64  0 callstate CONNECTED 66188 0 0
111218.64  0 callstate CONNECTED 66188,0,0
111218.64  0 WorkingModeTAPI@Connected=
111218.64  0 WorkingModeScript@Connected=
111218.64  0 Inband detection not enabled
111218.64  0 StartLoadedVgs at 9/11/2004 11:12:18 AM
111218.64  0 AddRVns [ScriptsPath]{C:\_ Files\VG_scripts\}
111218.64  0 AddRVns [ScriptPath]{C:\_ Files\VG_scripts}
111218.64  0 rv    add [$RV_STARTTIME]{9/11/2004 11:12:18 AM}
111218.66  0 rv    add [$RV_DEVICEID]{0}
111218.66  0 rv    add [$RV_CIDNAME]{}
111218.66  0 AddRVns [PathApp]{C:\Program Files\VoiceGuide\}
111218.66  0 rv    add [$RV_CIDNUMBER]{}
111218.66  0 timer clear
111218.66  0 [GetListingID] Number Input
111218.66  0 [GetListingID] Playing (C:\_ Files\VG_sound_files\enter_listing_id.wav)
111218.66  0 play set playid=790265
111218.69  0 PlaySoundStart ok [C:\_ Files\VG_sound_files\enter_listing_id.wav]
111218.70  0 timer clear
111218.70  0 wa(4109,79026500)
111221.86  0 dtmf 5   (66188,53,2)
111221.86  0 ScriptEventCode 53 iLineState=1300
111221.86  0 LsGetNbrsPlayWelcMsg 5
111222.44  0 PlaySoundStop err=0
111222.44  0 [GetListingID] Number Input 5
111222.44  0 path {5} not found
111222.44  0 timer set 6  EV_TIMEOUT_ENTERDATA
111228.89  0 timer fired EV_TIMEOUT_ENTERDATA
111228.89  0 ScriptEventCode 9006 iLineState=1301
111228.89  0 LsGetNbrsRxDigits EV_TIMEOUT_ENTERDATA
111228.89  0 timer clear
111228.89  0 rv    add [GetListingID]{5}
111228.89  0 path {5} not found
111228.89  0 AddRVns [GetListingID_PathTaken]{success}
111228.89  0 timer clear
111228.89  0 [MySQLQuery] DB Query
111228.89  0 db    ODBC mode used 
111250.34  0 rv    replace start: [SELECT pr_description FROM property WHERE pr_property_id=$RV[GetListingID]]
111250.34  0 rv    ns [PathSysVoice]{}[PathApp]{C:\Program Files\VoiceGuide\}[PathDataVm]{C:\Program Files\VoiceGuide\data\}[PathVgSys]{C:\Program Files\VoiceGuide\system\}[ScriptsPath]{C:\_ Files\VG_scripts\}[ScriptPath]{C:\_ Files\VG_scripts}[$RV_STARTTIME]{9/11/2004 11:12:18 AM}[$RV_DEVICEID]{0}[$RV_CIDNAME]{}[PathApp]{C:\Program Files\VoiceGuide\}[$RV_CIDNUMBER]{}[GetListingID]{5}[GetListingID_PathTaken]{success}
111250.34  0 rv    replace end: [SELECT pr_description FROM property WHERE pr_property_id=5]
111250.34  0 db    About to execute a Retrieve type operation [SELECT pr_description FROM property WHERE pr_property_id=5]
111250.42  0 db    [MySQLQuery] row count=1
111250.42  0 rv    add [MySQLQuery_RowCount]{1}
111250.42  0 db    get RecordsetGetRowsMax
111250.44  0 db    get 999 records. (row count=1)
111250.44  0 db    update RVs
111250.44  0 ERROR 5.2.3018 RunModule:0:13:Type mismatch:VoiceGuide
111250.44  0 rv    add [Hangup Time]{9/11/2004 11:12:50 AM}
111250.44  0 Hanging up call... [RunModule Error]
111250.44  0 RecSoundStop ok
111250.44  0 PlaySoundStop err=0
111250.44  0 timer set 2  EV_TIMEOUT_WAITFORIDLEAFTERLINEDROP
111250.44  0 fnHangupCall end
111250.66  0 callstate DISCONNECTED 66188 1 0
111250.66  0 ScriptEventCode 9250 iLineState=900
111250.66  0 LsAwaitingCalls EV_REMOTEPARTY_DISCONNECT
111250.66  0 rv    add [Hangup Time]{9/11/2004 11:12:50 AM}
111250.66  0 Hanging up call...
111250.66  0 RecSoundStop ok
111250.66  0 PlaySoundStop err=0
111250.66  0 timer set 2  EV_TIMEOUT_WAITFORIDLEAFTERLINEDROP
111250.66  0 fnHangupCall end
111250.66  0 callstate IDLE 66188 0 0
111250.66  0 WorkingMode@Idle=
111250.66  0 timer clear
111250.66  0 timer set 1  EV_TIMEOUT_TIMETOREINITLINE
111250.66  0 tapi  Reply (LineEvReply) ok 66137 0
111250.67  0 tapi  Reply (LineEvReply) ok 66154 0
111251.72  0 timer fired EV_TIMEOUT_TIMETOREINITLINE
111251.72  0 ScriptEventCode 9008 iLineState=900
111251.72  0 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE
111251.72  0 ReinitTelephony due to IDLE
111251.72  0 tapic lineDeallocateCall(MainCall:66188) 0
111251.97  0 lineOpen(0)=>
111251.97  0 Waiting for a call...
111251.97  0 LineHandle=66120
111251.97  0 timer set 3  EV_TIMEOUT_ATERIDLE_ALLOWOUT
111252.34  0 dial  start any summary:|0:rdy=0|
111253.34  0 dial  start any summary:|0:rdy=0|
111254.34  0 dial  start any summary:|0:rdy=0|
111255.30  0 timer fired EV_TIMEOUT_ATERIDLE_ALLOWOUT
111255.30  0 ScriptEventCode 9013 iLineState=900
111256.33  0 Unloading Main Window

 

 

tw.txt:

111200.328 ocxfn LogLevels 10,C:\Program Files\VoiceGuide\log\,tw.txt,,(null)
111200.328 ------------------------------------------------------------------------------
111200.328 TAPIWrap OCX v1.84.0, May 20 2004 14:56:28 [For Pure Tapi]
111200.328 Started at 0911 111200.328
111200.328 ------------------------------------------------------------------------------
111200.343 linec lineInitialize(0x94a668, 0x2d00000, 0x2d099e0, TapiWrap, 0x94a66c) => 0x0
111200.343 tapic lineNegotiateAPIVersion(0x800003ff, 0, 0x10003, 0x20001, 0x1916b8, 0x12c6e0)
111200.343 tapic lineGetDevCaps(0x800003ff, 0, 0x10004, 0, 0x19e8b0) call
111200.343 tapic lineGetDevCaps(0x800003ff, 0, 0x10004, 0, 0x19e8b0) => NO_ERROR (0)
111200.343 tapic lineGetIcon(0, 0, 0x1916c0)
111200.343 tapic lineNegotiateAPIVersion(0x800003ff, 1, 0x10003, 0x20001, 0x1a19e0, 0x12c6e0)
111200.343 tapic lineGetDevCaps(0x800003ff, 1, 0x10003, 0, 0x1aebd8) call
111200.343 tapic lineGetDevCaps(0x800003ff, 1, 0x10003, 0, 0x1aebd8) => NO_ERROR (0)
111200.343 tapic lineGetIcon(1, 0, 0x1a19e8)
111200.343 tapic lineNegotiateAPIVersion(0x800003ff, 2, 0x10003, 0x20001, 0x1aebe8, 0x12c6e0)
111200.343 tapic lineGetDevCaps(0x800003ff, 2, 0x10003, 0, 0x1bbde0) call
111200.343 tapic lineGetDevCaps(0x800003ff, 2, 0x10003, 0, 0x1bbde0) => NO_ERROR (0)
111200.343 tapic lineGetIcon(2, 0, 0x1aebf0)
111200.359 tapic lineNegotiateAPIVersion(0x800003ff, 3, 0x10003, 0x20001, 0x1bbdf0, 0x12c6e0)
111200.359 tapic lineGetDevCaps(0x800003ff, 3, 0x10003, 0, 0x1c8fe8) call
111200.359 tapic lineGetDevCaps(0x800003ff, 3, 0x10003, 0, 0x1c8fe8) => NO_ERROR (0)
111200.359 tapic lineGetIcon(3, 0, 0x1bbdf8)
111200.359 tapic lineNegotiateAPIVersion(0x800003ff, 4, 0x10003, 0x20001, 0x1c8ff8, 0x12c6e0)
111200.359 tapic lineGetDevCaps(0x800003ff, 4, 0x10003, 0, 0x1d61f0) call
111200.359 tapic lineGetDevCaps(0x800003ff, 4, 0x10003, 0, 0x1d61f0) => NO_ERROR (0)
111200.359 tapic lineGetIcon(4, 0, 0x1c9000)
111200.359 tapic lineNegotiateAPIVersion(0x800003ff, 5, 0x10003, 0x20001, 0x1d6200, 0x12c6e0)
111200.359 tapic lineGetDevCaps(0x800003ff, 5, 0x10004, 0, 0x1e33f8) call
111200.359 tapic lineGetDevCaps(0x800003ff, 5, 0x10004, 0, 0x1e33f8) => NO_ERROR (0)
111200.359 tapic lineGetIcon(5, 0, 0x1d6208)
111200.359 tapic lineNegotiateAPIVersion(0x800003ff, 6, 0x10003, 0x20001, 0x1e3408, 0x12c6e0)
111200.359 tapic lineGetDevCaps(0x800003ff, 6, 0x10004, 0, 0x1f0600) call
111200.359 tapic lineGetDevCaps(0x800003ff, 6, 0x10004, 0, 0x1f0600) => NO_ERROR (0)
111200.359 tapic lineGetIcon(6, 0, 0x1e3410)
111200.359 tapic lineNegotiateAPIVersion(0x800003ff, 7, 0x10003, 0x20001, 0x1f0610, 0x12c6e0)
111200.359 tapic lineGetDevCaps(0x800003ff, 7, 0x10004, 0, 0x1fd808) call
111200.359 tapic lineGetDevCaps(0x800003ff, 7, 0x10004, 0, 0x1fd808) => NO_ERROR (0)
111200.359 tapic lineGetIcon(7, 0, 0x1f0618)
111200.359 fn    TAPI_ERR:LINEERR_OPERATIONUNAVAIL
111200.359 tapic lineNegotiateAPIVersion(0x800003ff, 8, 0x10003, 0x20001, 0x1fd818, 0x12c6e0)
111200.359 tapic lineGetDevCaps(0x800003ff, 8, 0x10004, 0, 0x20aa10) call
111200.359 tapic lineGetDevCaps(0x800003ff, 8, 0x10004, 0, 0x20aa10) => NO_ERROR (0)
111200.359 tapic lineGetIcon(8, 0, 0x1fd820)
111200.390 ocxfn GetLineCount()
111200.390 ocxfn GetLineName(sLineId=8)
111200.390 tapic lineGetDevCaps(0x800003ff, 8, 0x10004, 0, 0x210638) call
111200.390 tapic lineGetDevCaps(0x800003ff, 8, 0x10004, 0, 0x210638) => NO_ERROR (0)
111200.390 ocxfn GetLineName(sLineId=7)
111200.390 tapic lineGetDevCaps(0x800003ff, 7, 0x10004, 0, 0x211770) call
111200.406 tapic lineGetDevCaps(0x800003ff, 7, 0x10004, 0, 0x211770) => NO_ERROR (0)
111200.406 ocxfn GetLineName(sLineId=6)
111200.406 tapic lineGetDevCaps(0x800003ff, 6, 0x10004, 0, 0x211770) call
111200.406 tapic lineGetDevCaps(0x800003ff, 6, 0x10004, 0, 0x211770) => NO_ERROR (0)
111200.406 ocxfn GetLineName(sLineId=5)
111200.406 tapic lineGetDevCaps(0x800003ff, 5, 0x10004, 0, 0x211770) call
111200.406 tapic lineGetDevCaps(0x800003ff, 5, 0x10004, 0, 0x211770) => NO_ERROR (0)
111200.406 ocxfn GetLineName(sLineId=4)
111200.406 tapic lineGetDevCaps(0x800003ff, 4, 0x10003, 0, 0x211770) call
111200.406 tapic lineGetDevCaps(0x800003ff, 4, 0x10003, 0, 0x211770) => NO_ERROR (0)
111200.406 ocxfn GetLineName(sLineId=3)
111200.406 tapic lineGetDevCaps(0x800003ff, 3, 0x10003, 0, 0x211770) call
111200.406 tapic lineGetDevCaps(0x800003ff, 3, 0x10003, 0, 0x211770) => NO_ERROR (0)
111200.406 ocxfn GetLineName(sLineId=2)
111200.406 tapic lineGetDevCaps(0x800003ff, 2, 0x10003, 0, 0x211770) call
111200.406 tapic lineGetDevCaps(0x800003ff, 2, 0x10003, 0, 0x211770) => NO_ERROR (0)
111200.406 ocxfn GetLineName(sLineId=1)
111200.406 tapic lineGetDevCaps(0x800003ff, 1, 0x10003, 0, 0x211770) call
111200.406 tapic lineGetDevCaps(0x800003ff, 1, 0x10003, 0, 0x211770) => NO_ERROR (0)
111200.406 ocxfn GetLineName(sLineId=0)
111200.406 tapic lineGetDevCaps(0x800003ff, 0, 0x10004, 0, 0x211770) call
111200.406 tapic lineGetDevCaps(0x800003ff, 0, 0x10004, 0, 0x211770) => NO_ERROR (0)
111200.531 ocxfn LineOpen(sLineId=0)
111200.531 tapic lineNegotiateAPIVersion(0x800003ff, 0, 0x10003, 0x20001, 0x1916b8, 0x12dfec)
111200.531 tapic lineGetDevCaps(0x800003ff, 0, 0x10004, 0, 0x241590) call
111200.546 tapic lineGetDevCaps(0x800003ff, 0, 0x10004, 0, 0x241590) => NO_ERROR (0)
111200.546 tapic lineGetIcon(0, 0, 0x1916c0)
111200.546 tapic lineGetDevCaps(0x800003ff, 0, 0x10004, 0, 0x241590) call
111200.546 tapic lineGetDevCaps(0x800003ff, 0, 0x10004, 0, 0x241590) => NO_ERROR (0)
111200.546 tapic lineOpen(0x800003ff, 0, 0x1916b4, 0x10004, 0, 0x1916a8, 0x4, LINEMEDIAMODE_INTERACTIVEVOICE | LINEMEDIAMODE_AUTOMATEDVOICE, 0)
111200.812 tapic lineGetID(0x102bf, 0, 0, 0x1, 0x7fd0008, wave/in) LINECALLSELECT_LINE hLineInfo
111201.078 tapic lineGetID(0x102bf, 0, 0, 0x1, 0x7fd0008, wave/in) => 0x0 
111201.078 tapic lineGetID => 1
111201.078 tapic lineGetID(0x102bf, 0, 0, 0x1, 0x7fd0008, wave/out) LINECALLSELECT_LINE hLineInfo
111201.078 tapic lineGetID(0x102bf, 0, 0, 0x1, 0x7fd0008, wave/out) => 0x0 
111201.078 tapic lineGetID => 1
111201.078 ocxfn GetLineName(sLineId=0)
111201.078 tapic lineGetDevCaps(0x800003ff, 0, 0x10004, 0, 0x243378) call
111201.078 tapic lineGetDevCaps(0x800003ff, 0, 0x10004, 0, 0x243378) => NO_ERROR (0)
111201.093 wavec waveInGetDevCaps(0x1, 0x12e050, 0x30) => 0
111201.093 wavec waveOutGetDevCaps(0x1, 0x12e01c, 0x34) => 0
111201.093 wave  IN:[Modem #1 Line Record v80.0 format=0x0, channels=0x1] OUT:[Modem #1 Line Playback v80.0 format=0x0, channels=0x1, support=0x0]
111201.093 ocxfn LineOpen(0, 0, 0, , )
111201.093 tapic lineGetID(0x102bf, 0, 0, 0x1, 0x7fd0008, wave/in) LINECALLSELECT_LINE hLineInfo
111201.093 tapic lineGetID(0x102bf, 0, 0, 0x1, 0x7fd0008, wave/in) => 0x0 
111201.093 tapic lineGetID => 1
111201.093 tapic lineGetID(0x102bf, 0, 0, 0x1, 0x7fd0008, wave/out) LINECALLSELECT_LINE hLineInfo
111201.093 tapic lineGetID(0x102bf, 0, 0, 0x1, 0x7fd0008, wave/out) => 0x0 
111201.093 tapic lineGetID => 1
111201.093 ocxfn GetLineName(sLineId=0)
111201.093 tapic lineGetDevCaps(0x800003ff, 0, 0x10004, 0, 0x243378) call
111201.093 tapic lineGetDevCaps(0x800003ff, 0, 0x10004, 0, 0x243378) => NO_ERROR (0)
111201.093 wavec waveInGetDevCaps(0x1, 0x12dfb4, 0x30) => 0
111201.093 wavec waveOutGetDevCaps(0x1, 0x12df80, 0x34) => 0
111201.093 wave  IN:[Modem #1 Line Record v80.0 format=0x0, channels=0x1] OUT:[Modem #1 Line Playback v80.0 format=0x0, channels=0x1, support=0x0]
111201.093 ocxfn GetProviderInfo(sLineId=0)
111201.093 tapic lineGetDevCaps(0x800003ff, 0, 0x10004, 0, 0x243448) call
111201.093 tapic lineGetDevCaps(0x800003ff, 0, 0x10004, 0, 0x243448) => NO_ERROR (0)
111201.093 fn    GetProviderInfo => UnimodemV
111201.093 ocxfn SilenceDetectSet(sLineId=0, sTimeLen=0, sVolumeLevel=0)
111212.546 tapie LINE_CALLSTATE(0, 0x1028c, 0x2, 0x0, 0x4)
111212.546 tapic lineMonitorDigits(0x1028c, 0x2) => 0x0
111212.546 tapic lineMonitorMedia(0x1028c, 0xfc) => -2147483601
111212.546 fn    TAPI_ERR:LINEERR_INVALMEDIAMODE
111212.546 tapic lineGetCallInfo(0x1028c, 0x246ed8)
111212.546 eng   No CallerId info available at this time
111212.546 tapie LINE_LINEDEVSTATE(0, 0x102bf, 0x2, 0x1, 0x1)
111218.562 tapie LINE_LINEDEVSTATE(0, 0x102bf, 0x2, 0x1, 0x2)
111218.578 tapie LINE_CALLSTATE(0, 0x1028c, 0x4, 0x0, 0x0)
111218.640 tapie LINE_REPLY(0, 0x0, 0x1027b, 0x0)
111218.640 tapie LINE_CALLSTATE(0, 0x1028c, 0x100, 0x0, 0x0)
111218.640 tapic lineGetID(0x102bf, 0, 0, 0x1, 0x248368, wave/in) LINECALLSELECT_LINE hLineInfo
111218.640 tapic lineGetID(0x102bf, 0, 0, 0x1, 0x248368, wave/in) => 0x0 
111218.640 tapic lineGetID => 1
111218.640 tapic lineGetID(0x102bf, 0, 0, 0x1, 0x248368, wave/out) LINECALLSELECT_LINE hLineInfo
111218.640 tapic lineGetID(0x102bf, 0, 0, 0x1, 0x248368, wave/out) => 0x0 
111218.640 tapic lineGetID => 1
111218.640 info  This device does not support Volume control, dwSupport=0x0
111218.656 ocxfn PlayMultiDelimited(sLineId=0, strFile1=C:\_ Files\VG_sound_files\enter_listing_id.wav, lPlayId=0xc0ef9, lOptions=0x0, strOptions=)
111218.656 tr    5 ResetWavOutAndContinuePlay start
111218.656 play  FileMmioOpenAndAscend start C:\_ Files\VG_sound_files\enter_listing_id.wav
111218.656 play  FileMmioOpenAndAscend end
111218.656 fn    play  wav format: wFormatTag=0x1, nChannels=1, nSamplesPerSec=8000, nAvgBytesPerSec=16000, nBlockAlign=2, wBitsPerSample=16, cbSize=0
111218.656 wavec waveOutOpen(0x0, 0x1, 0x1916d0, 0x0, 0x0, 0x1) => 0 (MMSYSERR_OK) - format query
111218.687 wavec waveOutOpen(0x191704, 0x1, 0x1916d0, 0x1e016c, 0x1916a8, 0x10002) => 0 (MMSYSERR_OK) ... hli->hWaveOut=0x248c58
111218.687 wavec waveOutReset(0x248c58) => 0(MMSYSERR_OK) fn:PlaySoundStart
111218.687 tapic lineMonitorDigits(0x1028c, 0x2) => 0x0
111218.687 tapic lineMonitorMedia(0x1028c, 0x7c) => -2147483601
111218.687 fn    TAPI_ERR:LINEERR_INVALMEDIAMODE
111218.687 play  FileMmioOpenAndAscend start C:\_ Files\VG_sound_files\enter_listing_id.wav
111218.687 play  FileMmioOpenAndAscend end
111218.687 play  LoadCurrFileToPlay start
111218.687 play  FileMmioOpenAndAscend start C:\_ Files\VG_sound_files\enter_listing_id.wav
111218.687 play  FileMmioOpenAndAscend end
111218.687       iPlayListIdxCurr 0 wav format: wFormatTag=0x1, nChannels=1, nSamplesPerSec=8000, nAvgBytesPerSec=16000, nBlockAlign=2, wBitsPerSample=16, cbSize=0
111218.687 wavec waveOutWrite HeapAllocs bytes: DataToPlay=65756, WaveHdr=32, UserData=12 
111218.687       wavehdr: lpData=0x7fb0ff8, dwBufferLength=65756, dwBytesRecorded=0, dwUser=0x2481e8, dwFlags=0x0, dwLoops=0x0, lpNext=0x0, reserved=0x0
111218.687 wavec waveOutPrepareHeader(0x248c58, 0x24b108, 0x20) => 0
111218.687 wavec waveOutWrite(0x248c58, 0x24b108, 0x20) => 0
111218.687 play  LoadCurrFileToPlay end
111218.687 tr    fn ResetWavOutAndContinuePlay LoadCurrFileToPlay returned
111218.687 tr    fn  PostMessage WM_FIRE_PLAY_WDOG_SET_EVENT (linked buffers) params: 0 79026500
111218.703 fn    OnFirePlayPlayWdogSetEvent start
111218.703 ocxev PlayWdogSet(dwLineId=0, dwPlayId=0x4b5d944, LenMsecs=4109)
111221.859 tapie LINE_MONITORDIGITS(0, 0x1028c, 0x35)
111221.859 ocxfn PlayStop(sLineId=0)
111221.859 fn    PlaySoundStop start
111221.859 tr    fn PlaySoundStop calling PostMessage WM_FIRE_PLAY_WDOG_CLEAR_EVENT
111221.859 wavec waveOutReset(0x248c58) call, caller: PlaySoundStop
111221.859 wavec waveOutReset(0x248c58) => 0 (MMSYSERR_OK), caller: PlaySoundStop
111221.859 wavec waveOutClose(0x248c58) call, caller: PlaySoundStop
111222.437 wavec waveOutClose(0x248c58) => 0 (MMSYSERR_OK), caller: PlaySoundStop
111222.437 fn    OnFirePlayPlayWdogClearEvent start
111222.437 ocxev PlayWdogClear(dwLineId=0, dwPlayId=0x4b5d944)
111222.437 wavee WOM_DONE(0x248c58, 0x24b108) (callback window message)
111222.437 wavee WOM_DONE(0x248c58, 0x3bd, 0x1916a8, 0x24b108, 0x0) psch
111222.437 fn    psch  hwo(0x248c58) != hli->hWaveOut(0x0)
111222.437 fn    psch  lpUserData=0x2481e8 : dwPlayId=790265, hli=0x1916a8, iFileIdx=0x0
111222.437 fn    psch  hli=0x1916a8 : dwPlayId=790265, iPlayListIdxCurr=0xfffffffe
111222.437 fn    psch  not clearing watchdog
111222.437 wavec waveOutUnprepareHeader(0x248c58, 0x24b108, 0x20) call unimodem
111222.437 wavec waveOutUnprepareHeader(0x248c58, 0x24b108, 0x20) => 5 (MMSYSERR_INVALHANDLE) unimodem
111250.437 ocxfn RecStop(sLineId:0)
111250.437 wavec waveInReset(0x0) => 5
111250.437 linec lineMonitorTones(0x1028c, 0x0, 1) => 0x8000003c (disabling monitoring for silence/tones)
111250.437 ocxfn PlayStop(sLineId=0)
111250.437 fn    PlaySoundStop start
111250.437 fn    PlaySoundStop line not playing a sound file. 0x0
111250.437 ocxfn LineDrop(sLineId=0, sOpt=0)
111250.437 tapic lineDrop(0x1028c, , 0) call in ocxfn_LineDrop
111250.437 tapic lineDrop(0x1028c, , 0) => async:66137 (66137)
111250.656 tapie LINE_CALLSTATE(0, 0x1028c, 0x4000, 0x1, 0x0)
111250.656 ocxfn RecStop(sLineId:0)
111250.656 wavec waveInReset(0x0) => 5
111250.656 linec lineMonitorTones(0x1028c, 0x0, 1) => 0x8000003c (disabling monitoring for silence/tones)
111250.656 ocxfn PlayStop(sLineId=0)
111250.656 fn    PlaySoundStop start
111250.656 fn    PlaySoundStop line not playing a sound file. 0x0
111250.656 ocxfn LineDrop(sLineId=0, sOpt=0)
111250.656 tapic lineDrop(0x1028c, , 0) call in ocxfn_LineDrop
111250.656 tapic lineDrop(0x1028c, , 0) => async:66154 (66154)
111250.656 tapie LINE_CALLSTATE(0, 0x1028c, 0x1, 0x0, 0x0)
111250.656 tapie LINE_REPLY(0, 0x0, 0x10259, 0x0)
111250.656 tapie LINE_REPLY(0, 0x0, 0x1026a, 0x0)
111251.718 ocxfn LineClose(sLineId:0)
111251.718 tapic lineNegotiateAPIVersion(0x800003ff, 0, 0x10003, 0x20001, 0x1916b8, 0x12f110)
111251.718 tapic lineGetDevCaps(0x800003ff, 0, 0x10004, 0, 0x7fb1890) call
111251.718 tapic lineGetDevCaps(0x800003ff, 0, 0x10004, 0, 0x7fb1890) => NO_ERROR (0)
111251.718 tapic lineGetIcon(0, 0, 0x1916c0)
111251.718 ocxfn LineOpen(0, 0, 0, , )
111251.718 tapic lineNegotiateAPIVersion(0x800003ff, 0, 0x10003, 0x20001, 0x1916b8, 0x12e450)
111251.718 tapic lineGetDevCaps(0x800003ff, 0, 0x10004, 0, 0x7fb1890) call
111251.718 tapic lineGetDevCaps(0x800003ff, 0, 0x10004, 0, 0x7fb1890) => NO_ERROR (0)
111251.718 tapic lineGetIcon(0, 0, 0x1916c0)
111251.718 tapic lineGetDevCaps(0x800003ff, 0, 0x10004, 0, 0x7fb1890) call
111251.718 tapic lineGetDevCaps(0x800003ff, 0, 0x10004, 0, 0x7fb1890) => NO_ERROR (0)
111251.718 tapic lineOpen(0x800003ff, 0, 0x1916b4, 0x10004, 0, 0x1916a8, 0x4, LINEMEDIAMODE_INTERACTIVEVOICE | LINEMEDIAMODE_AUTOMATEDVOICE, 0)
111251.968 tapic lineGetID(0x10248, 0, 0, 0x1, 0x2490f8, wave/in) LINECALLSELECT_LINE hLineInfo
111251.968 tapic lineGetID(0x10248, 0, 0, 0x1, 0x2490f8, wave/in) => 0x0 
111251.968 tapic lineGetID => 1
111251.968 tapic lineGetID(0x10248, 0, 0, 0x1, 0x2490f8, wave/out) LINECALLSELECT_LINE hLineInfo
111251.968 tapic lineGetID(0x10248, 0, 0, 0x1, 0x2490f8, wave/out) => 0x0 
111251.968 tapic lineGetID => 1
111251.968 ocxfn GetLineName(sLineId=0)
111251.968 tapic lineGetDevCaps(0x800003ff, 0, 0x10004, 0, 0x7fb1890) call
111251.968 tapic lineGetDevCaps(0x800003ff, 0, 0x10004, 0, 0x7fb1890) => NO_ERROR (0)
111251.968 wavec waveInGetDevCaps(0x1, 0x12e4b8, 0x30) => 0
111251.968 wavec waveOutGetDevCaps(0x1, 0x12e484, 0x34) => 0
111251.968 wave  IN:[Modem #1 Line Record v80.0 format=0x0, channels=0x1] OUT:[Modem #1 Line Playback v80.0 format=0x0, channels=0x1, support=0x0]
111251.968 ocxfn SilenceDetectSet(sLineId=0, sTimeLen=30, sVolumeLevel=10)
111256.218 tapic lineNegotiateAPIVersion(0x800003ff, 0, 0x10003, 0x20001, 0x1916b8, 0x12ee30)
111256.218 tapic lineGetDevCaps(0x800003ff, 0, 0x10004, 0, 0x7fb1890) call
111256.218 tapic lineGetDevCaps(0x800003ff, 0, 0x10004, 0, 0x7fb1890) => NO_ERROR (0)
111256.218 tapic lineGetIcon(0, 0, 0x1916c0)
111256.234 linec lineShutdown(0x800003ff) => 0x0

Share this post

Link to post

SupportTeam   

Posted

Please update your VG v5.2.3 install with the .exe attached below and run the test against a TEXT or MEDIUMTEXT type field, then post the relevant section of the MMDDvgm.txt log file - this should give us info on exactly where the error is occurring.

VgMulti_5.2.3030.zip

Share this post

Link to post

Guest Gabe   

Posted

I've replaced the VGMulti.exe file and the following is from the MMDDvgm.txt file after testing on a TEXT column:

 

023231.16  0 AddRVns [GetListingID_PathTaken]{success}
023231.16  0 timer clear
023231.16  0 [MySQLQuery] DB Query
023231.16  0 db    ODBC mode used 
023252.73  0 rv    replace start: [SELECT pr_description FROM property WHERE pr_property_id=$RV[GetListingID]]
023252.73  0 rv    ns [PathSysVoice]{}[PathApp]{C:\Program Files\VoiceGuide\}[PathDataVm]{C:\Program Files\VoiceGuide\data\}[PathVgSys]{C:\Program Files\VoiceGuide\system\}[ScriptsPath]{C:\_ Files\VG_scripts\}[ScriptPath]{C:\_ Files\VG_scripts}[$RV_STARTTIME]{9/12/2004 2:32:17 AM}[$RV_DEVICEID]{0}[$RV_CIDNAME]{}[PathApp]{C:\Program Files\VoiceGuide\}[$RV_CIDNUMBER]{}[GetListingID]{5}[GetListingID_PathTaken]{success}
023252.73  0 rv    replace end: [SELECT pr_description FROM property WHERE pr_property_id=5]
023252.75  0 db    About to execute a Retrieve type operation [SELECT pr_description FROM property WHERE pr_property_id=5]
023252.86  0 db    [MySQLQuery] row count=1
023252.86  0 rv    add [MySQLQuery_RowCount]{1}
023252.86  0 db    get RecordsetGetRowsMax
023252.86  0 db    get 999 records. (row count=1)
023252.86  0 db    update RVs 1
023252.86  0 db    update RVs 2 cols=0 rows=0
023252.88  0 ERROR 5.2.3030 RunModule 5450 13:Type mismatch (VoiceGuide)
023252.88  0 rv    add [Hangup Time]{9/12/2004 2:32:52 AM}
023252.89  0 Hanging up call... [RunModule Error]
023252.89  0 RecSoundStop ok
023252.89  0 PlaySoundStop err=0
023252.89  0 timer set 2  EV_TIMEOUT_WAITFORIDLEAFTERLINEDROP
023252.89  0 fnHangupCall end

Share this post

Link to post

SupportTeam   

Posted

OK, we now can see where the error is occurring but cannot yet tell why - can you please update with this .exe and run the query again.

 

The script will now not hang up after query but you probably will not see anything returned in RV - the entries in MMDDvgm.txt trace should give us more info now - please post the trace again after running your test.

VgMulti_5.2.3032.zip

Share this post

Link to post

Guest Gabe   

Posted

Ok, below are the results:

 

110753.39  0 db    [MySQLQuery] row count=1
110753.39  0 rv    add [MySQLQuery_RowCount]{1}
110753.39  0 db    get RecordsetGetRowsMax
110753.39  0 db    get 999 records. (row count=1)
110753.39  0 db    update RVs start
110753.39  0 db    update RVs cols=1 rows=1
110753.42  0 db    test CStr(vRetData(0, 0))=Error 40035
110753.42  0 db    about to close dbDbqDatabase
110753.42  0 db    going down path [True]
110753.42  0 timer clear
110753.42  0 [ReadDescription] Playing

Share this post

Link to post

SupportTeam   

Posted

Looks like the ODBC Driver itself is returning this error so there is nothing that can be done by VoiceGuide to fix this.

 

The only solution is to change the database to use VARCHAR fields instead of TEXT or MEDIUMTEXT.

Share this post

Link to post

Guest jmiller808   

Posted

i am actually getting the same type mismatch error using sql server. i found what was causing it for me. it looks like voice guide has a problem with columns defined as varchar(8000).

Share this post

Link to post

Guest Derek   

Posted

I'm getting this same problem. Is the problem here the ODBC driver or a problem in Voiceguide? What's the workarround?

 

110753.39 0 db [MySQLQuery] row count=1

110753.39 0 rv add [MySQLQuery_RowCount]{1}

110753.39 0 db get RecordsetGetRowsMax

110753.39 0 db get 999 records. (row count=1)

110753.39 0 db update RVs start

110753.39 0 db update RVs cols=1 rows=1

110753.42 0 db test CStr(vRetData(0, 0))=Error 40035

110753.42 0 db about to close dbDbqDatabase

110753.42 0 db going down path [True]

110753.42 0 timer clear

110753.42 0 [ReadDescription] Playing

Share this post

Link to post

SupportTeam   

Posted

Have you tried changing around the DB field defintions as per prior posts in this thread?

Share this post

Link to post

Guest Derek   

Posted

No not yet. This is easier said than done in this case. If this is the only workaround I'll try it. Is it known why this happens? Is it the odbc driver or Voiceguide? Thanks.

Share this post

Link to post

SupportTeam   

Posted

Apparently it's the ODBC driver - but it could be the way MDAC (which VG uses) interacts with the ODBC driver...

 

Either way, right now the solution for such problems seems to be to alter the DB table definition.

Share this post

Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Go To Topic Listing General
×