VoiceGuide IVR Software Main Page
Jump to content

Voiceguide Hangs On Get Numbers Module

Recommended Posts

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

Share this post


Link to post

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

Share this post


Link to post

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

Share this post


Link to post

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

Share this post


Link to post

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.

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
×