Intermittent Problem Dialing Out

[pdpk]

Further to our earlier thread, topic 1758 (when phone number is not unique), we have started testing the application with a larger number of records in our database (up to approx 300 at a time instead of 1 or 2 records) and an intermittent problem has shown up.

 

Sometimes, when a call is made, VoiceGuide will hangup when the person answers the phone. Looking at our log files, this seems to have been caused by the first module, which is a database query, failing to find any records that match the criteria in our SQL statement.

 

We have checked our database, and a record that matches the criteria DOES definitely exist! One observation that we have made, however, is that the log from VoiceGuide does not show the $RVCALLEDNUMBER variable being added, in those cases where the call fails.

 

Please find attached two of our logs - 0712VGM_1.txt is where a call has been made sucessfully to a mobile phone. 0712VGM_4.txt shows the log where a call has been made to a mobile, falsely detected as an answermachine, and then failed to find any records that match our Database Query critera.

 

Also included in the zip is a copy of each of our Outgoing and Outgoing_AnswerMachine scripts: ogs1.vgs and ogs1_am.vgs.

 

Could you have a look at these two logs and give us any clues as to why its not working and any suggestions on anything that we can change to make it work consistently?

pdpk120704.zip

[SupportTeam]

Looking through the 0712VGM_4.txt trace we can see that the $RV_CALLEDNUMBER was correctly replaced by the actual dialed number:

110845.69  0 [GetCallInfo] DB Query

 

110846.06  0 RVreplace start: [sELECT AutomatedCalls.AirlineName, AutomatedCalls.PaxName, AutomatedCalls.ETA, AutomatedCalls.FirstText, AutomatedCalls.SecText, AutomatedCalls.Internal_Comments, AutomatedCalls.Internal_Comments1, AutomatedCalls.DelDate, AutomatedCalls.ID FROM AutomatedCalls, CallQue WHERE AutomatedCalls.Phone = '$RV_CALLEDNUMBER' AND AutomatedCalls.ID = $RV[MyCallID]]

 

110846.06  0 db    About to execute a Retrieve type operation [sELECT AutomatedCalls.AirlineName, AutomatedCalls.PaxName, AutomatedCalls.ETA, AutomatedCalls.FirstText, AutomatedCalls.SecText, AutomatedCalls.Internal_Comments, AutomatedCalls.Internal_Comments1, AutomatedCalls.DelDate, AutomatedCalls.ID FROM AutomatedCalls, CallQue WHERE AutomatedCalls.Phone = '07836756992' AND AutomatedCalls.ID = 152]

 

110846.66  0 db    [GetCallInfo] no records found.

maybe there is something else about the SQL statement that is incorrect or results in no rows being returned?

[pdpk]

But surely if there was a problem with the SQL statement, it wouldn't work the other times?

 

In the log for the call that failed, (0712vgm_4.txt) at line 45 it reads "callstate DISCONNECTED..." and then, if you compare it with the same area in the log for the call that succeeded (0712vgm_1.txt) you'll notice that the following lines do not appear:

 

110013.11 0 rv add [MyCallId]{151}

110013.11 0 rv add [OutDial_RetriesLeft]{9}

110013.11 0 rv add [$RV_STARTTIME]{12/07/04 11:00:13}

110013.11 0 rv add [$RV_DEVICEID]{0}

110013.11 0 rv add [$RV_CIDNAME]{}

110013.11 0 AddRVns [PathApp]{D:\software\VoiceGuide\}

110013.11 0 rv add [$RV_CALLEDNUMBER]{07836756992}

 

does this mean that VoiceGuide does not have the $RV values available to it?

[SupportTeam]

Which version of VG are you running?
I've had a look at v5.2.3 and there are some changes in this area made in that version. Could you please try uninstalling your current VG install (backup any files you need !) and then install and try with v5.2.3. You can download v5.2.3 here:
[old link removed]