Vbs Fail Errors

[Guest tylerrehm]

As requested in http://voiceguide.com/forums/index.php?showtopic=11850:

We added the below code to our config file as instructed

[systemRunScript]
Engine=WScript

But now we are facing new vbs errors as seen below:

132133.346   4  25   9 ERROR v7.4.5424.20898 (07-Nov-14 11:36:37.32) VBScriptRun_FileRvReplaceAndRun_TestingobjVbsOrExeProcess : Process has exited, so the requested information is not available.


   at System.Diagnostics.Process.EnsureState(State state)
   at System.Diagnostics.Process.get_WorkingSet()
   at (Object )
   at ..(Int32 iLineId, String sVbsInFname, String sVbsOutFname, String sAddedVbs, Int32 iVbsTimeoutSec)
132133.346   4  25   9       VBScriptRun_FileRvReplaceAndRun returned error -5

125540.146   7 104  35       callstate crn_event=2880032 2137|GCEV_RELEASECALL state=0|Error calldirection=0 gcCallState=0 [GCST_NULL||], ScriptState=LS_NULL_AWAITINGCALLS

We need these issues resolved ASAP,

Thank you,

Tyler Rehm

[SupportTeam]

Can you please post the vgEngine trace that captures the execution of that module or call.

 

We can then see what has happened on the system.

 

Please .ZIP up all files before posting them.

[Guest tylerrehm]

Please see attached .zip.

193818.691  15   4   2 ERROR v7.4.5424.20898 (07-Nov-14 11:36:37.32) VBScriptRun_FileRvReplaceAndRun_TestingobjVbsOrExeProcess : Process has exited, so the requested information is not available.


   at System.Diagnostics.Process.EnsureState(State state)
   at System.Diagnostics.Process.get_WorkingSet()
   at (Object )
   at ..(Int32 iLineId, String sVbsInFname, String sVbsOutFname, String sAddedVbs, Int32 iVbsTimeoutSec)
193818.691  15   4   2       VBScriptRun_FileRvReplaceAndRun returned error -5

0224_1938_vgEngine.zip

[SupportTeam]

The VBScript module here runs as a part of VoiceGuide script that is ran after an outgoing call is answered.

 

The "[systemRunScript] Engine=WScript" does not affect the modules ran as part of the script.

 

To confirm that you can just remove the [systemRunScript] section from VG.INI, restart VoiceGuide, and compare.

 

 

It does however look like the VBScript in the module [confirm] is not running.

 

That VBScript could have stopped running as it could not connect to database, or for a number of other reasons.

 

Time could be spent debugging why it failed or on which line of the script the problem occurred, but as the function of this VBScript can be performed by a 'Database Query" module and an "Evaluate Expression" module, then we'd recommend just altering the script in that way.

The SQL query can be ran by the Database Query module, and the setting to $RV can be done by the Evaluate Expression module.

 

 

This system was configured to run VBScript modules using the "WSH/WScript" instead of the default ClearScript.

 

In general, if WSH/Wscript is used to run VBScripts on system then the number of 'Run VBScript' modules on the system should be limited. WSH/Wscript has problems when large number of simultaneous tasks are ran. This is why the switch to ClearScript was made.

193818.649  15   4   2 state [confirm] type: Script_VBScript, iRunWait=0
193818.649  15   4   2       rv    replace start
------------------------------
Set rs = CreateObject("ADODB.Recordset")
rsConn = "Driver={MySQL ODBC 5.1 Driver};Server=127.0.0.2;Database=db2;Uid=user2;Pwd=ps12345;"
rs.ActiveConnection = rsConn
strSQL = "UPDATE status SET status = 'Confirmed' WHERE accountid = '$RV[accountid]' AND callid = '$RV[callid]'"
rs.Open strSQL


set vg = CreateObject("vgServices.CommandLink")
vg.RvSet $RV_LINEID, "outcome", "Confirmed"
set vg = Nothing
------------------------------
193818.649  15   4   2       rv    replace end   [Set rs = CreateObject("ADODB.Recordset")
rsConn = "Driver={MySQL ODBC 5.1 Driver};Server=127.0.0.2;Database=db2;Uid=user2;Pwd=ps12345;"
rs.ActiveConnection = rsConn
strSQL = "UPDATE status SET status = 'Confirmed' WHERE accountid = '19622' AND callid = '9F17BE16-7A27-4F5D-C369-3A6D0148F1A2'"
rs.Open strSQL


set vg = CreateObject("vgServices.CommandLink")
vg.RvSet 4, "outcome", "Confirmed"
set vg = Nothing]
193818.650  15   4   2       script will be ran from file: C:\voiceguide\temp\vbs_4_2.vbs
193818.650  15   4   2       on_hold_file=, iModuleIdx=2710
193818.650  15   4   2       delete existing: C:\voiceguide\temp\vbs_4_2.vbs
193818.650  15   4   2       current objVbsOrExeProcess (vbsrun) : id=65396, handle=87856, hash=13979514, hasExited=True, startTime=2/24/2015 7:37:29 PM, exitTime=2/24/2015 7:37:29 PM
193818.650  15   4   2       strIni_systemRunScript_Engine=[WScript]
193818.650  15   4   2       RunVBScriptFile [WScript][cscript][C:\voiceguide\temp\vbs_4_2.vbs][] timeout=60 (vbsPath=C:\voiceguide\temp), start (new Process)
193818.650  15   4   2       objProcess.Start call
193818.665  19   4   2 ev    PlayEnd 4 -695804 [38256:38256:86613]
193818.665  19   4   2       play  end   id=-695804 (current id)
193818.665  19   4   2       rvns  add   confirmResched_LastPos|4782
193818.665  19   4   2       rvns  add   confirmResched_PosMax|4782
193818.665  19   4   2       rvns  add   confirmResched_SoundFileLength|10826
193818.665  19   4   2       q_scr +     evScriptEvent 8001 EV_PLAY_FINISHED
193818.665   7   4   2       q_scr run   evScriptEvent sCode=[EV_PLAY_FINISHED] iActionID=0, crn=0 [-695804|0|0|0|0][|||||] 00:00:00 max:4|00:00:00.0110006
193818.665   7   4   2       se    EV_PLAY_FINISHED 8001  -695804|0|0  || LineState=LS_RUN_WAITTILLFINISHED
193818.665   7   4   2       LsRunWaitTillFinished EV_PLAY_FINISHED lCode2Str=EV_PLAY_FINISHED
193818.665   7   4   2       path {EV_PLAY_FINISHED} not found
193818.665   7   4   2       LsRunWaitTillFinished play  end   id=-695804, iRunWait_MohPlayWasStarted=0. ignoring
193818.675  15   4   2       objProcess.Start returned. handle=88048, id=65012, hash=65332679, starttime=2/24/2015 7:38:18 PM, HasExited=False
193818.691  15   4   2 ERROR v7.4.5424.20898 (07-Nov-14 11:36:37.32) VBScriptRun_FileRvReplaceAndRun_TestingobjVbsOrExeProcess : Process has exited, so the requested information is not available.

   at System.Diagnostics.Process.EnsureState(State state)
   at System.Diagnostics.Process.get_WorkingSet()
   at (Object )
   at ..(Int32 iLineId, String sVbsInFname, String sVbsOutFname, String sAddedVbs, Int32 iVbsTimeoutSec)
193818.691  15   4   2       VBScriptRun_FileRvReplaceAndRun returned error -5
193818.691  15   4   2       FindNextVgmTitleInPathList: next module title is=[confirmok]
193818.691  15   4   2 t     timer clear (force=False)