Db Updates Failing

[Guest tylerrehm]

We are experiencing a recent failure in database updates on call delivery.

The database updates are failing whether the calls are being answered by a Human or Machine.

This issue is causing repeated calls as we recall appointments that are still 'In Cue'.

 

Attached is the .zip vgEngin trace.

 

Examples of failures:

CallId AB7538AC-693B-6134-DAF6-C0F8D99889A4 - Human but still In Cue

CallId C9F21BC2-7826-D28A-1653-FAD6FB39BB5A - Machine but still In Cue

 

Examples of successes:

CallId A49E6424-80B9-BF79-0467-AE265662F1D6 - Human, Confirmed

CallId C61B3077-AB99-C51F-59B7-B22E3852DB63 - Human, Cancelled

CallIId 346ECCB3-A3E9-C7B0-9458-8CE42B4DD087 - Machine

 

I have scrubbed the log file to purge any sensitive information.

 

Please let me know what the issue is and how we can go about correcting ASAP.

0215_0203_vgEngine.zip

[SupportTeam]

The AB7538AC-693B-6134-DAF6-C0F8D99889A4 call had the entry of ID 3815968 in the MySQL's callque table.

 

Trace shows that the "DELETE FROM callque WHERE ID=@iID;" SQL command was issued to the database for that call at 210015.494, and system reported that that command completed successfully at 210015.510, so looks like that call entry in callque table has been deleted successfully.

 

BTW. That call was answered by an answering machine, but then call was hung up on before the answering machine message finished (maybe it was just some sort of announcement after which the call was hung up?), so no script ever got a chance to run.

    Line 394449: 210001.263  11               dial  3815968,,18314447807,2/15/2015 12:00:00 AM,,priority=2,live=c:\voiceguide\Scripts\human19901c.vgs,am=c:\voiceguide\Scripts\machine19901c.vgs,fax=,na=,exhausted=,100,count=1,delay=90,[accountid]{19901}[callid]{AB7538AC-693B-6134-DAF6-C0F8D99889A4}

    Line 395025: 210002.953  19  55  19 state Dialing (auto) 18314447807 ...
...
    Line 395456: 210012.260  19  55  19 ev    CallState GCEV_CONNECTED, crn=2800272, iEvent=0 ,256,2,4, s1:, s2:, s3:]. build_date: 07-Nov-14 11:36:37.32
...
    Line 395464: 210012.261   7  55  19 state Dialing (auto) 18314447807 ... connected
    Line 395465: 210012.261   7  55  19       LineEvCallState_Connected_OutBound crn=2800272, L2script=Running_Dialing
    Line 395466: 210012.261   7  55  19      setting dateThisCallAnswerTime in CDRCallOutcomeSet
    Line 395467: 210012.261   7  55  19       rvns  add   OutDial_Result|ANSWERED
    Line 395468: 210012.261   7  55  19       L2_set Running_Normal  (called from LineEvCallState_Connected_OutBound)
    Line 395469: 210012.261   7  55  19       dial  wait as LineState().sCallProgressOption=[DX_PAMDOPTEN]
    Line 395470: 210012.261   7  55  19 state Dialing (auto) 18314447807 ... connected, doing answer detection... (DX_PAMDOPTEN)
    Line 395471: 210012.261   7  55  19       rvns  add   OutDial_Result|ANSWERED_UNDETERMINED
    Line 395871: 210015.491  19  55  19 ev    Dialogic 133,TDX_CALLP, crn=2800272, 10,4,0,CR_CNCT,CON_PAMD,
    Line 395872: 210015.491  19  55  19       q_scr +     evScriptEvent 133 CON_PAMD
    Line 395873: 210015.491   7  55  19       q_scr run   evScriptEvent sCode=[CON_PAMD] iActionID=0, crn=2800272 [10|4|0|0|0][CR_CNCT|CON_PAMD||||] 00:00:00 max:1|00:00:00.0050003
    Line 395874: 210015.491   7  55  19       se    CON_PAMD 133  10|4|0  CR_CNCT|CON_PAMD| LineState=LS_WAITAFTERDIALINGOUT
    Line 395875: 210015.491   7  55  19       LsWaitAfterDialingOut : 133,2800272,CON_PAMD,10,4,0,CR_CNCT,CON_PAMD,
    Line 395876: 210015.491  19  55  19       q_scr +     evScriptEvent 133 TDX_CALLP
    Line 395877: 210015.491   7  55  19       q_scr run   evScriptEvent sCode=[TDX_CALLP] iActionID=0, crn=2800272 [10|4|0|0|0][CR_CNCT|CON_PAMD||||] 00:00:00 max:1|00:00:00.0050003
    Line 395878: 210015.491   7  55  19       se    TDX_CALLP 133  10|4|0  CR_CNCT|CON_PAMD| LineState=LS_WAITAFTERDIALINGOUT
    Line 395879: 210015.491   7  55  19       LsWaitAfterDialingOut : 133,2800272,TDX_CALLP,10,4,0,CR_CNCT,CON_PAMD,
    Line 395880: 210015.491   7  55  19       L2_set Running_Normal  (called from CR_CNCT on outbound call)
    Line 395881: 210015.491   7  55  19       rvns  add   OutDial_Result|ANSWERED_MACHINE
    Line 395882: 210015.492   7  55  19       OnOutboundCallAnswered_Start_AnsweringMachine_Option entry 10,4,0
...
    Line 395895: 210015.493   7  55  19       dial  DeleteFromOutDialQue ID=3815968
    Line 395896: 210015.493   7  55  19 state Answering Machine, wait for end of welcome message
    Line 395897: 210015.493   7  55  19       dial  awaiting end of answering machine message (lvl:15 for 20)
    Line 395898: 210015.493   7  55  19       q_tel +     cmd_SilenceDetectSet 0 [20,15,0,0,0][||||]
    Line 395899: 210015.493   7  55  19       q_tel +     cmd_RecordFileStart 582753 C:\voiceguide\temp\Rec Am_55.wav [<CallerId>1234567890</CallerId>]
    Line 395900: 210015.493   7  55  19       RecSoundStart [C:\voiceguide\temp\Rec Am_55.wav] ok
    Line 395901: 210015.493   7  55  19 t     timer set   120 sec : EV_TIMEOUT_HANGUP
    Line 395902: 210015.493   8  55  19       q_tel run   cmd_SilenceDetectSet 0 00:00:00 max:2|00:00:00
    Line 395903: 210015.493   8  55  19       q_tel run   cmd_RecordFileStart 0 00:00:00 max:2|00:00:00
    Line 396996: 210022.241  19  55  19 ev    CallState GCEV_DISCONNECTED, crn=2800272, iEvent=0 ,16384,0,64, s1:, s2:, s3:]. build_date: 07-Nov-14 11:36:37.32

    Line 394450: 210001.263  11               dial  callque update id/guid=3815968/00000000-0000-0000-0000-000000000000 nextActivateTime=2/15/2015 10:30:01 PM, retriesLeft=0, iRelatedPortNumber=19
    Line 394459: 210001.275  11               dial  callque update id/guid=3815968/00000000-0000-0000-0000-000000000000 nextActivateTime=2/15/2015 10:30:01 PM, retriesLeft=0, iRelatedPortNumber=19 : completed ok
    Line 394460: 210001.276  11  55  19       dial  call found (autodialer) ID/GUID=3815968/00000000-0000-0000-0000-000000000000, tel=18314447807, SinceTaskLoaded=00:00:00.0180011, SinceWorkOnTaskStarted=00:00:00.0180011, S1=00:00:00.0040003 (210001.262-210001.258), S2=00:00:00.0010000 (210001.263-210001.262), RetrUpdt=00:00:00.0130008 (210001.276-210001.263)
    Line 394463: 210001.276   7  55  19       dial  StartOutgoingCall start tel[18314447807] live[c:\voiceguide\Scripts\human19901c.vgs] am[c:\voiceguide\Scripts\machine19901c.vgs] fax[] onNotAnswered[] onRetriesEnd[] rv[[accountid]{19901}[callid]{AB7538AC-693B-6134-DAF6-C0F8D99889A4}[dname]{All Health Care}[pname]{John Smith}[xfernumber]{1234567890}[appdate]{Tuesday February 17}[appdateSP]{Martes Febrero 17}[apptime]{9:30 AM}[officephone]{one, two, three, four, five, six, seven, eight, nine, nine,}[officephoneSP]{uno, dos, tres, quatro, cinco, seis, siete, ocho, nueve, nueve,}[provideraudio]{C:\voiceguide\Sounds\19901\EnglishV2\maitland.wav}[provideraudioSP]{C:\voiceguide\Sounds\19901\SpanishV2\maitland_spanish.wav}[greeting1]{}[specialaudio]{}[locationaudio]{C:\voiceguide\Sounds\19901\EnglishV2\upcoming_appointment_scheduled_for.wav}[locationaudioSP]{C:\voiceguide\Sounds\19901\SpanishV2\appointment_scheduled_for_spanish.wav}[specialaudios]{}[ttslocation]{at our DEFAULT location}[ttslocationSP]{en nuestra...
    Line 394496: 210001.280   7  55  19       rv    add   OutDial_ID|3815968
    Line 394498: 210001.281   7  55  19       dial  making call LineState settings: tel[18314447807] live[c:\voiceguide\Scripts\human19901c.vgs] am[c:\voiceguide\Scripts\machine19901c.vgs] fax[] noAnswer[] retriesEnd[] OnHangup[C:\voiceguide\Scripts\outcomeHuman.vgs] rv[[accountid]{19901}[callid]{AB7538AC-693B-6134-DAF6-C0F8D99889A4}[dname]{All Health Care}[pname]{John Smith}[xfernumber]{1234567890}[appdate]{Tuesday February 17}[appdateSP]{Martes Febrero 17}[apptime]{9:30 AM}[officephone]{one, two, three, four, five, six, seven, eight, nine, nine,}[officephoneSP]{uno, dos, tres, quatro, cinco, seis, siete, ocho, nueve, nueve,}[provideraudio]{C:\voiceguide\Sounds\19901\EnglishV2\maitland.wav}[provideraudioSP]{C:\voiceguide\Sounds\19901\SpanishV2\maitland_spanish.wav}[greeting1]{}[specialaudio]{}[locationaudio]{C:\voiceguide\Sounds\19901\EnglishV2\upcoming_appointment_scheduled_for.wav}[locationaudioSP]{C:\voiceguide\Sounds\19901\SpanishV2\appointment_scheduled_for_spanish.wav}[specialaudios]{}[ttslocation]{...
    Line 395895: 210015.493   7  55  19       dial  DeleteFromOutDialQue ID=3815968
    Line 395904: 210015.494  11               dial  Db_Delete_Entry begin id=3815968 guid=00000000-0000-0000-0000-000000000000 linkField=ID, sql=[DELETE FROM callque WHERE ID=@iID; DELETE FROM porttouse WHERE CallID=@iID;]
    Line 395905: 210015.510  11               dial  Db_Delete_Entry end id=3815968 guid=00000000-0000-0000-0000-000000000000

[Guest tylerrehm]

The calls are deleted from callque correctly but we have a process running on the status table that checks status.status and when status.status = 'In Cue', we reload the call. The update on status.status is failing and causing the process to reload the call every evening. It looks like on those failed updates, the db update is never run, even though it is working for other calls with that script. The DB update is the first module in the script before any message is delivered. Please see the below lines from the attached file for an example of when the update is working.

 

Please let me know if there is any other information I can provide to resolve.

 

 

 

210013.381   7   2   1       rv    replace end   [UPDATE status SET status = 'Delivered' WHERE accountid = '19901' AND callid = 'A49E6424-80B9-BF79-0467-AE265662F1D6'
]


210013.393  63   2   1       db    odbc  m_strSQL=[UPDATE status SET status = 'Delivered' WHERE accountid = '19901' AND callid = 'A49E6424-80B9-BF79-0467-AE265662F1D6'
]


210048.030   7   2   1       rv    replace end   [UPDATE status SET status = 'Confirmed' WHERE accountid = '19901' AND callid = 'A49E6424-80B9-BF79-0467-AE265662F1D6'
]


210048.052  69   2   1       db    odbc  m_strSQL=[UPDATE status SET status = 'Confirmed' WHERE accountid = '19901' AND callid = 'A49E6424-80B9-BF79-0467-AE265662F1D6'
]

[SupportTeam]

This "status" table is not a VoiceGuide system table, and is not managed internally by VoiceGuide software.,

 

So looks like your question is about some database call that updates your own database, right?

 

Are you saying that sometimes this update does not get done?

 

Had a quick look through the log supplied and there is a number (9) of these "UPDATE status SET status = 'Confirmed' ..." calls made from Database Query modules [dbUpdateConfirm] and [dbUpdateConfirmSP]:

    Line 401934: 210048.030   7   2   1       rv    replace end   [UPDATE status SET status = 'Confirmed' WHERE accountid = '19901' AND callid = 'A49E6424-80B9-BF79-0467-AE265662F1D6'
    Line 402319: 210049.423   7  10   4       rv    replace end   [UPDATE status SET status = 'Confirmed' WHERE accountid = '19901' AND callid = '1B9877A7-AE0F-231C-C062-DB0FC07FD278'
    Line 402751: 210051.234   7   7   3       rv    replace end   [UPDATE status SET status = 'Confirmed' WHERE accountid = '19901' AND callid = 'EC9EBB74-EAAC-D607-0518-E65834C03E7B'
    Line 404160: 210055.661   7  22   8       rv    replace end   [UPDATE status SET status = 'Confirmed' WHERE accountid = '19901' AND callid = '60F1E44D-310D-F9B2-2834-E0D70D9A1A72'
    Line 412263: 210141.737   7  10   4       rv    replace end   [UPDATE status SET status = 'Confirmed' WHERE accountid = '19901' AND callid = 'D8848FA9-D921-695F-F42B-39E56842E84C'
    Line 415773: 210159.708   7   7   3       rv    replace end   [UPDATE status SET status = 'Confirmed' WHERE accountid = '19901' AND callid = '0F02B35D-1E89-1129-5E43-4A121325A832'
    Line 420159: 210234.126   7  64  22       rv    replace end   [UPDATE status SET status = 'Confirmed' WHERE accountid = '19901' AND callid = '072066A9-FC48-2906-7427-22452CEE534B'
    Line 424232: 210314.661   7   7   3       rv    replace end   [UPDATE status SET status = 'Confirmed' WHERE accountid = '19901' AND callid = 'F5A5F2F8-5E90-1377-1A57-7F9C1723D4F2'
    Line 428034: 210400.927   7  64  22       rv    replace end   [UPDATE status SET status = 'Confirmed' WHERE accountid = '19901' AND callid = 'E64AAF0A-3A2F-6CF2-BD3B-DD2A1DD7ADDF'

and your MySQL database replied that all these calls were processed successfully:

    Line 401981: 210048.052  69   2   1       db    completed.  SqlQueryType=NONQUERY, RowsCount=1, sRv=[dbUpdateConfirm_RowCount]{1}
    Line 402374: 210049.434  56  10   4       db    completed.  SqlQueryType=NONQUERY, RowsCount=1, sRv=[dbUpdateConfirm_RowCount]{1}
    Line 402798: 210051.258  63   7   3       db    completed.  SqlQueryType=NONQUERY, RowsCount=1, sRv=[dbUpdateConfirm_RowCount]{1}
    Line 404206: 210055.666  63  22   8       db    completed.  SqlQueryType=NONQUERY, RowsCount=1, sRv=[dbUpdateConfirm_RowCount]{1}
    Line 412310: 210141.748  66  10   4       db    completed.  SqlQueryType=NONQUERY, RowsCount=1, sRv=[dbUpdateConfirm_RowCount]{1}
    Line 415820: 210159.729  67   7   3       db    completed.  SqlQueryType=NONQUERY, RowsCount=1, sRv=[dbUpdateConfirm_RowCount]{1}
    Line 420206: 210234.149  63  64  22       db    completed.  SqlQueryType=NONQUERY, RowsCount=1, sRv=[dbUpdateConfirmSP_RowCount]{1}
    Line 424279: 210314.683  56   7   3       db    completed.  SqlQueryType=NONQUERY, RowsCount=1, sRv=[dbUpdateConfirmSP_RowCount]{1}
    Line 428081: 210400.947  59  64  22       db    completed.  SqlQueryType=NONQUERY, RowsCount=1, sRv=[dbUpdateConfirm_RowCount]{1}

[Guest tylerrehm]

This is correct but it is not occurring for calls such as AB7538AC-693B-6134-DAF6-C0F8D99889A4 and C9F21BC2-7826-D28A-1653-FAD6FB39BB5A.

The calls are from the same scripts and update completed via the Database Query module, as in the successful updates above.

 

My question is why the Database Query module is not executing for some calls while working for others.

The Database Query module is the first module in the individual call script as is the starting point for the said script.

Attached are the scripts in question but the same methodology is used for others that are also failing in the same respect.

 

Please let me know,

Thank you so much,

Tyler Rehm

scripts.zip

[SupportTeam]

AB7538AC-693B-6134-DAF6-C0F8D99889A4 call was answered by an answering machine, but then call was hung up on before the answering machine message finished.

 

The VoiceGuide script was never ran as the call ended while VoiceGuide was waiting for the answering machine message to finish. Looks like call was hung up immediately after finishing playing the message.

210002.953  19  55  19 state Dialing (auto) 18314447807 ...

210012.260  19  55  19 ev    CallState GCEV_CONNECTED, crn=2800272
210012.261   7  55  19 state Dialing (auto) 18314447807 ... connected

210015.491  19  55  19 ev    Dialogic 133,TDX_CALLP, crn=2800272, 10,4,0,CR_CNCT,CON_PAMD,
210015.493   7  55  19 state Answering Machine, wait for end of welcome message

210022.241  19  55  19 ev    CallState GCEV_DISCONNECTED, crn=2800272

[Guest tylerrehm]

There is no indication as to why the call was hung up? It does not make any sense as to how a machine can hang up on a call...

After looking at the call details for this call it appears the billsec for this call was 21 seconds, outcome was Machine yet AnswerType was Human.

 

This also does not address the human answer issue.

 

If there is any other information we can provide to resolve, please let me know as this is critical to get fixed.

We had never had this issue until about a week or two ago. Nothing configuration wise has changed,

 

Thank you,
Tyler Rehm

[SupportTeam]

The remote end hung up the call. It was a normal hangup. Maybe machine was set to not record any messages?

 

CDR shows that call was categorized as ANSWERED_MACHINE

 

CDR shows that 'duration' was 21 seconds, and 'billsec' was 7 seconds (which looking at the trace should really be 10 - we'll need to look at that)

210022.283   7  55  19       CDR (out) : "","18317578124","18314447807","","","","","c:\voiceguide\Scripts\machine19901c.vgs","<accountid>19901</accountid><callid>AB7538AC-693B-6134-DAF6-C0F8D99889A4</callid><dname>All Health Care</dname><pname>John Smith</pname><xfernumber>1234567890</xfernumber><appdate>Tuesday February 17</appdate><appdateSP>Martes Febrero 17</appdateSP><apptime>9:30 AM</apptime><officephone>one, two, three, four, five, six, seven, eight, nine, nine,</officephone><officephoneSP>uno, dos, tres, quatro, cinco, seis, siete, ocho, nueve, nueve,</officephoneSP><provideraudio>C:\voiceguide\Sounds\19901\EnglishV2\maitland.wav</provideraudio><provideraudioSP>C:\voiceguide\Sounds\19901\SpanishV2\maitland_spanish.wav</provideraudioSP><greeting1></greeting1><specialaudio></specialaudio><locationaudio>C:\voiceguide\Sounds\19901\EnglishV2\upcoming_appointment_scheduled_for.wav</locationaudio><locationaudioSP>C:\voiceguide\Sounds\19901\SpanishV2\appointment_scheduled_for_spanish.wav</locationaudioSP><specialaudios></specialaudios><ttslocation>at our DEFAULT location</ttslocation><ttslocationSP>en nuestra DEFAULT  localidad</ttslocationSP><ttsprovider>with Doctor MAITLAND</ttsprovider><ttsproviderSP>con el doctor MAITLAND</ttsproviderSP><special></special><specialSP></specialSP><ttsAddress></ttsAddress><ttsAddressSP></ttsAddressSP><OutDial_RetriesLeft>1</OutDial_RetriesLeft><OutDial_CampaignName></OutDial_CampaignName><OutDial_ID>3815968</OutDial_ID><OutDial_GUID>00000000-0000-0000-0000-000000000000</OutDial_GUID><STARTTIME>2015-02-15 21:00:15</STARTTIME><DEVICEID>55</DEVICEID><DlgcVoice>dxxxB5C3</DlgcVoice><DlgcNetwork>dtiB1T19</DlgcNetwork><CIDNAME></CIDNAME><DNIS></DNIS><ISDN_SETUP></ISDN_SETUP><DIALEDNUMBER>18314447807</DIALEDNUMBER><Hangup Source>LineEvCallState_DISCONNECTED</Hangup Source><Hangup Source>Hangup Module</Hangup Source><DropCall_Source>Hangup</DropCall_Source><CallHangupTime>2015-02-15 21:00:22</CallHangupTime>","'2015-02-15 21:00:01'","'2015-02-15 21:00:15'","'2015-02-15 21:00:22'",21,7,"ANSWERED_MACHINE","","" => C:\voiceguide\cdr\CDR_20150215_out.txt , C:\voiceguide\cdr\CDR_20150215_out_ANSWERED_MACHINE.txt

[Guest tylerrehm]

So no part of 19901c.vgs was ever reached during the outbound call?

 

And please let me know what I can do about the variation in billsec.

 

Thank you,

Tyler

[SupportTeam]

Correct. That call did not reach the point at which the script gets started.

 

The billsec should be fixed in this version:

 

[old link removed]

 

Please update system to version above and make a test call that is answered by answering machine, and post traces in a new support forum thread to verify the billsec.

 

To change from one release of VoiceGuide v7 to another:

 

1. Stop VoiceGuide service and exit all VoiceGuide programs. (eg Script Designer, Voicemail Manager, etc) and all other programs.

2. Run the VoiceGuide install and install into same directory as existing installation. (Do NOT uninstall the previous VoiceGuide installation).

3. Start VoiceGuide service.

 

Running a VoiceGuide install over the top of an existing install will NOT overwrite existing configuration or license files (Config.xml, ConfigLine.xml, VG.INI, VmBoxList.xml, userinfo.lic) and will not remove any of users script or sound files, and will not remove any log files etc.

Please note however that the local SQLite outdial database will be re-initialized. If you are using the local SQLite outdial database and have any queued outgoing calls that you would like to keep then this database should be backed up first.

[Guest tylerrehm]

Okay will do this evening.

 

However, we never addressed the failed Human call AB7538AC-693B-6134-DAF6-C0F8D99889A4. Could you please advise?

 

Thank you,

Tyler

[SupportTeam]

C9F21BC2-7826-D28A-1653-FAD6FB39BB5A is similar:

Line 394292: 210001.209   7  43  15       dial  making call LineState settings: tel[18315408217] live[c:\voiceguide\Scripts\human19901c.vgs] am[c:\voiceguide\Scripts\machine19901c.vgs] fax[] noAnswer[] retriesEnd[] OnHangup[C:\voiceguide\Scripts\outcomeMachine.vgs] rv[[accountid]{19901}[callid]{C9F21BC2-7826-D28A-1653-FAD6FB39BB5A}[dname]{All Health Care}[pname]{John Smith}[xfernumber]{1234567890}[appdate]{Tuesday February 17}[appdateSP]{Martes Febrero 17}[apptime]{10:30 AM}[officephone]{one, two, three, four, five, six, seven, eight, nine, nine,}[officephoneSP]{uno, dos, tres, quatro, cinco, seis, siete, ocho, nueve, nueve,}[provideraudio]{C:\voiceguide\Sounds\19901\EnglishV2\lim.wav}[provideraudioSP]{C:\voiceguide\Sounds\19901\SpanishV2\lim_spanish.wav}[greeting1]{}[specialaudio]{}[locationaudio]{C:\voiceguide\Sounds\19901\EnglishV2\upcoming_appointment_scheduled_for.wav}[locationaudioSP]{C:\voiceguide\Sounds\19901\SpanishV2\appointment_scheduled_for_spanish.wav}[specialaudios]{}[ttslocation]{at our ...

Line 395957: 210016.001  19  43  15 ev    CallState GCEV_CONNECTED, crn=280026f,

Line 396252: 210019.226  19  43  15 ev    Dialogic 133,TDX_CALLP, crn=280026f, 10,4,0,CR_CNCT,CON_PAMD,

Line 396277: 210019.228   7  43  15 state Answering Machine, wait for end of welcome message

Line 398416: 210029.927  19  43  15 ev    CallState GCEV_DISCONNECTED, crn=280026f, iEvent=0 ,16384,0,64, s1:, s2:, s3:]. build_date: 07-Nov-14 11:36:37.32

( AB7538AC-693B-6134-DAF6-C0F8D99889A4 call was the call covered in previous posts )

[SupportTeam]

Looks like currently this system has been set to execute the RunVBscript modules using WSH/Wscript instead of using the default ClearScript interpreter.

Which is achieved using this VG.INI setting:

[moduleRunScript]
Engine=WScript

In the version that is installed on this system, if you want to use WSH, then you also need to set this in VG.INI file:

[systemRunScript]
Engine=WScript

(systemRunScript instead of moduleRunScript)

[Guest tylerrehm]

I currently have moduleRunScript but no entry for [systemRunScript] in vg.ini as seen below:

[moduleRunScript]
Engine=WScript

Should I add in addition to or replace?

[systemRunScript]
Engine=WScript

Further more, would this issue be related to the following error:

132048.435 52 28 10 ERROR v7.4.5424.20898 (07-Nov-14 11:36:37.32) VBScript objVbsOrExeProcess not set.

For more details, see attached .zip file.

0223_1121_vgEngine.zip

[SupportTeam]

both [systemRunScript] and [systemRunScript] entries need to be present.

The "VBScript objVbsOrExeProcess not set." is not really an error - that should just be an informational message.

[Guest tylerrehm]

Okay will modify the systemRunScript.

In regards to the other error, the complete snip is causing the machine script to fail delivering the other modules in the script as it defaults to hang up after failure.

Now we have added a failure path to continue even on failure but we need to ensure this VBS update works to update the status of the call internally (delivered, machine, etc.) or else we have a process that will attempt calling again.

 

205702.613 159 64 22 rv replace end [Function GetFileContents(sFileName)

Dim FSO, ScriptFile

Set FSO = CreateObject("Scripting.FileSystemObject")

Set ScriptFile = FSO.OpenTextFile(sFilename,1)

GetFileContents = ScriptFile.ReadAll

Set ScriptFile = Nothing

Set FSO = Nothing

End Function

ExecuteGlobal GetFileContents("C:\voiceguide\include\dbApplication.vbs")

strSQL = "call SaveOutcome('19675', 'OutFl2', '110485B1-4D14-BFF7-78CD-77D6F5B63775', '49', 'Confirmed', 'Human', '')"

rs.Open strSQL

Set rs = Nothing]

205702.613 159 64 22 script will be ran from file: C:\voiceguide\temp\vbs_64_3.vbs

205702.613 159 64 22 on_hold_file=, iModuleIdx=239

205702.613 159 64 22 delete existing: C:\voiceguide\temp\vbs_64_3.vbs

205702.613 159 64 22 current objVbsOrExeProcess (vbsrun) is null

205702.613 159 64 22 strIni_systemRunScript_Engine=[ClearScriptV8]

205702.613 159 64 22 QueueUserWorkItem scrmod_RunVbs.RunModule call

205702.614 159 64 22 ERROR v7.4.5424.20898 (07-Nov-14 11:36:37.32) VBScript objVbsOrExeProcess not set.

205702.614 159 64 22 RunModule_Script_AfterScriptStarted start

205702.614 224 64 22 runutilscr new VBScriptEngine call

205702.614 159 64 22 script run failed. objVbsOrExeProcess Is Nothing, Shell parameter = [C:\voiceguide\temp\vbs_64_3.vbs]

205702.614 159 64 22 FindNextVgmTitleInPathList: next module title is=[Hangup]

[SupportTeam]

Please set the [systemRunScript] entry and if you still encounter any issues with VBScritps then make a a new thread post on that topic.