Voiceguide Hangs On Get Numbers Module

[sveness]

Hi there

My problem is intermittent and seems to have something to do with the get numbers module verification process. I am verifying a number by checking it against an oracle database.

If no record is returned VoiceGuide plays "Notvaliddelno.wav" else "thankyou.wav" is played.

When the module returns the "verify_failed" result, it plays "notvaliddelno.wav", but occasionally does not play the file and hangs on "112712.68 6 LsGetNbrsPlayWelcMsg EV_TIMEOUT_CHECKONSTATE"

 

Here is the code in get numbers module:

 

set vg = CreateObject("VoiceGuide.CommandLink")

 

sResult = "verify_failed"

 

set cnOracle = CreateObject("ADODB.Connection")

set rsOracle = CreateObject("ADODB.Recordset")

cnOracle.Open "Provider=msdasql;DSN=nctprod;UID=nct;PWD=clone;SERVER=nctprod;"

 

set rsOracle.ActiveConnection = cnOracle

oracleSQL = "SELECT M.DELIVERY_NOTE_NUMBER, D.REFERENCE, M.TO_DPOINT_CODE FROM MOVEMENTS M, DESPATCH_POINTS D WHERE M.DELIVERY_NOTE_NUMBER = $RV_ENTEREDNUMBER AND M.FROM_DPOINT_CODE = D.DPOINT_CODE AND RELEASE_DATE IS NULL"

rsOracle.Open oracleSQL, cnOracle, 3

 

if not rsOracle.EOF then

 

sResult = "verify_passed"

 

End if

 

rsOracle.Close

cnOracle.Close

set cnOracle = Nothing

set rsOracle = Nothing

 

vg.Run_ResultReturn $RV_LINEID, sResult

set vg = Nothing

 

Attached is the event trace log.

 

Thanks

0317vgm.txt

[SupportTeam]

Trace shows the verification script was ran OK and returned "verify_failed".

 

Do you have the path "verify_failed" or "Failed" defined in that module ([GetDelNo]) ?

 

Can you post the script?

 

112711.66  6 eng  copy of verification script ran: vbs_6_1.vbs

112711.75  6 Run Script waiting. iRunWait=1 (shellid=1344, process=1780)

112711.77  6 timer set 1  EV_TIMEOUT_CHECKONSTATE

112711.99  6 cl    Run_ResultReturn >>verify_failed<<

112711.99  6 ScriptEventCode 9220 iLineState=1301

112712.00  6 LsGetNbrsRxDigits EV_UNKNOWN_9220

112712.00  6 eng  GetNbr EV_MODGETNBRS_VERIFY_FAIL

112712.66  6 timer fired EV_TIMEOUT_CHECKONSTATE

112712.66  6 ScriptEventCode 9007 iLineState=1300

112712.68  6 LsGetNbrsPlayWelcMsg EV_TIMEOUT_CHECKONSTATE

[sveness]

submitted the script with original post, definately "verify_failed"

[SupportTeam]

The file attached to the first post in this thread is a trace log, not the script - the script is the .vgs file.

[sveness]

Here it is

nctivr.vgs

[SupportTeam]

Please update your v.5.2.3b install with attached .exe

VgMulti_5.2.3074.zip

[sveness]

Thanks for that quick response, brilliant support!

Please could you explain (in laymans terms!) what was wrong.

 

Thanks

 

Shane Veness

NCT Forestry Co-operative Limited

[SupportTeam]

There was a bug in the way the verify_failed was handled by that module...

 

The 'verify number' functionality was originally designed for the "VoiceGuide for ISDN" and "VoiceGuide for VoIP" product line and was only recently put into the version of VG which you can download from our WWW. Look like it wasn't ported over from that other version properly. This was now fixed.