Send Emails

[Guest srusse01]

I have set up the email to be sent, but I was wondering how the "retries" works. Is this only if they haven't been sent or what. I have it set at the default of 3 and even though it has sent the email, it continues to send it another 2 times. If I set this to 0 then would this stop...but if the server was down, then it wouldn't send it again when it was up, would it....Totally confused now!

[SupportTeam]

"retries" is the max number of times VG will try to send the email message.

 

Once the email message has been sent successfully then it is not sent again.

 

Maybe your SMTP server after accepting the email is not acknowledging back to VG that it has received email successfully and that is causing VG to send email up to "retries" number of time?

 

Maybe you have the same recipient mentioned again in CC or BCC fields?

 

Which version of VG are you using?

 

Could you please post us the trace file MMDDes.txt which should be getting created in VoiceGuide's \log\ subdirectory, this will let us see what is happening when VG sends the email.

 

Here are the traces from a test we done with v5.1.8 on our system just now, confirming that only one email gets sent:

 

\log\MMDDvgm.txt file:

145426.52  9 [send Email 2] Send Email

145426.52  9 AddRVall [send Email 2]{emailtest@katalina.com.au}

145426.52  9 AddRVall [send Email 2_Subject]{test}

145426.52  9 AddRVall [send Email 2_Message]{test}

145426.52  9 AddRVall [send Email 2_Attachment]{}

145426.52  9 AddRVall [send Email 2_Cc]{}

145426.52  9 AddRVall [send Email 2_Bcc]{}

145426.52  9 Que email to: emailtest@katalina.com.au

\log\MMDDes.txt file:

145427.16  0 eng   prog start 14:54:27 26 Feb

145427.27  0 que   found 1/1

145427.31  0 smtp  Status Connecting to SMTP Server ( ... deleted... )...

145428.42  0 smtp  Status Initializing Communications...

145428.45  0 eng   smtp send start To:emailtest@katalina.com.au, Cc:, Bcc:

145428.45  0 smtp  Status Sending Sender Information...

145428.45  0 smtp  Progress 13%

145428.50  0 smtp  Status Sending Recipient Information...

145428.50  0 smtp  Progress 25%

145428.53  0 smtp  Status Sending Message...

145428.53  0 smtp  Progress 27%

145428.58  0 smtp  Progress 100%

145428.86  0 smtp  Progress 100%

145428.86  0 smtp  Status Transmission Complete...

145428.86  0 smtp  SendSuccesful

145428.86  0 que   delete ID=2

145428.86  0 eng   smtp send end

145428.86  0 smtp  Status Closing Connection...

145428.89  0 eng   send attempt 1 result = success

145429.00  0 eng   prog end   14:54:29 26 Feb

[Guest Sarah]

I am using a MAPI connection as the server is using Microsoft Mail rather than Exchange. I will check the code and post it tomorrow.

 

Does using MAPI make a difference?

[SupportTeam]

It shouldn't, but lets see what the trace shows.

 

Are you using v5.1.8 of VoiceGuide?

[Guest sarah]

I am using version 5.1.8 and here is the event log from the Send email module. This has sent two copies to me, and if it goes on previous form, it will send at least another.

 

Any help would be appreciated.

 

 

53555.55 7 [send Email test] Send Email

153555.55 7 RVreplace start: [test message for TEST SESSION - DINO New Recruit $RV[GetStudyId_1_1]]

153555.55 7 RVreplace end: [test message for TEST SESSION - DINO New Recruit 612349]

153555.55 7 RVreplace start: [This is an automatic message generated when VoiceGuide has randomised a woman into the DINO Trial - $RV[GetStudyId_1_1]

 

Hospital Code = $RV[Enter Hospital Code]

Patient UR = $RV[EnterUR]

Mother's DOB = $RV[MDOB_DAY]/$RV[MDOB_MONTH]/$RV[MDOB_YEAR]

Multiple Birth = $RV[MultipleBirth]

BirthWeight (1 = <1250gms, 2 = >=1250gms) = $RV[birthWeight]

Strata = $RV[GetStrata_1_1]

DateRand = $RV[Date]

Time Rand = $RV[Time]

StudyID = $RV[GetStudyId_1_1]

AllocGroup = $RV[GetStudyId_2_1]

]

153555.56 7 Que email to: cnrctrials@mail.wch.sa.gov.au

153555.56 7 [Log results] Running VB Script...

153555.56 7 RVreplace start (strlen>500)

153555.59 7 Run Script waiting... (shellid=1884, process=1496)

153556.70 7 LsRunWaitTillFinished EV_TIMEOUT_CHECKONSTATE

153556.70 7 task completed (shellid=1884, process=1496)

153556.70 7 No information returned from program to VG (no VGRUNRESULT_7.TXT or SHLRESLT.TXT)

153556.70 7 Hanging up call... [WaitTillFinished - next module not specified]

153556.72 7 HangupCall_Common Mode=AfterHangupRun

153556.72 7 ReinitTelephony due to IDLE

153556.73 7 tapic lineDeallocateCall(MainCall:65587) 0

153556.89 7 lineOpen(7) => 0

153556.89 7 Waiting for a call...

153556.89 7 LineHandle=65536

154046.64 0 Script Load C:\Program Files\VoiceGuide\Randomisation\RandomisationDINO.vgs

154046.70 0 Loaded Script Id 2: C:\Program Files\VoiceGuide\Randomisation\RandomisationDINO.vgs

154046.72 0 Erasing Script (new loaded) Id 1

154416.02 0 sys cleanup Start

154416.02 0 sys cleanup End

[SupportTeam]

Could you please post us the trace file MMDDes.txt which should be getting created in VoiceGuide's \log\ subdirectory, this will let us see what is happening when VG sends the email.

 

(Do you have an SMTP server set up anywhere they you can let VG connect to directly instead of having VG use MAPI and Outlook to send the emails?)

[Guest Guest]

MMDDes.txt is not being created anywhere.

 

Also, I believe the company that I am writing this for, only has Microsoft Mail server, and as such does not have a SMTP address. (am I correct in assuming no SMTP if only using Microsoft Mail)

[SupportTeam]

In VG.INI file please check that in the section [EmailSender] the TraceLevel entry is set to 5 or higher.

 

If that does not help:

 

Can you please update to v5.2 and then make sure that in VG.INI file, in section [Log] the EmailSender entry is set to 10.

 

The log file will then be created.

[Guest Sarah]

Well I have uninstalled the previous version and installed v5.2 and now I get the following error message and the script stops.

 

121701.38 7 RVreplace end: [sELECT Strata FROM tblStrata WHERE (BirthWt = 2 and Gender = 2)]

121701.38 7 db About to execute a Retrieve type operation [sELECT Strata FROM tblStrata WHERE (BirthWt = 2 and Gender = 2)]

121701.38 7 db DBEngine.Error 3021:No current record.:DAO.Recordset

121701.38 7 db [GetStrata] row count=1

121701.39 7 rv add [GetStrata_RowCount]{1}

121701.39 7 ERROR 5.2.1005 RunModule:0:3001:Invalid argument.:DAO.Recordset

121701.41 7 rv add [Hangup Time]{09/03/2004 12:17:01}

121701.41 7 Hanging up call... [RunModule Error]

 

Can you please tell me what is going on here, and how I can fix it. Obviously something is happening in this new version that didn't in the previous.

 

This is quite urgent now, as I thought it was all ready to finalize and now I feel like I have taken a step backwards.

 

Thanks

 

Sarah

[Guest Sarah]

This is a copy of what is in the vg.ini file relating to emailsend

 

 

[Log]

;Automated "log-to-file" logging.

;To turn OFF logging for a particular application set it's entry to 0

;To turn ON all logging for a particular application set it's entry to 10

;all log files are saved in VoiceGuide's \log\ subdirectory

;log files are names as following:

;VoiceGuide: MMDDvgm.txt

;NumberLoader: MMDDtnl.txt

;EmailSender: MMSSes.txt

;TapiWrapOcx: MMDDtw.txt

;SapiWrapOcx: MMDDsw.txt

 

VoiceGuide=0

NumberLoader=0

EmailSender=10

TapiWrapOcx=0

SapiWrapOcx=0

 

 

As you can see the emailsender is now called MMSSes.txt

 

However, this is not being created even though I have set the EmailSender to 10.

Do I need to do any other settings?

[Guest Sarah]

Here is the text from the 0309es.txt file (I just worked out that MMDD must stand for month and day!)

114140.45 0 eng prog start 11:41:40 09 Mar

114140.56 0 que found 1/30

114140.58 0 SendEmailMapi 2

114140.58 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

114140.83 0 SendEmailMapi returned

114140.83 0 eng send attempt 1 result = success

114140.95 0 eng prog end 11:41:40 09 Mar

114142.50 0 eng prog start 11:41:42 09 Mar

114142.61 0 eng prog end 11:41:42 09 Mar

114430.77 0 eng prog start 11:44:30 09 Mar

114430.88 0 que found 1/30

114430.88 0 SendEmailMapi 2

114430.89 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

114431.14 0 SendEmailMapi returned

114431.16 0 eng send attempt 1 result = success

114431.27 0 eng prog end 11:44:31 09 Mar

114555.03 0 eng prog start 11:45:55 09 Mar

114555.14 0 que found 1/30

114555.16 0 SendEmailMapi 2

114555.16 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

114555.28 0 SendEmailMapi returned

114555.28 0 eng send attempt 1 result = success

114555.39 0 eng prog end 11:45:55 09 Mar

114557.08 0 eng prog start 11:45:57 09 Mar

114557.19 0 eng prog end 11:45:57 09 Mar

114813.25 0 eng prog start 11:48:13 09 Mar

114813.36 0 que found 1/30

114813.38 0 SendEmailMapi 2

114813.38 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

114813.69 0 SendEmailMapi returned

114813.70 0 eng send attempt 1 result = success

114813.81 0 eng prog end 11:48:13 09 Mar

114815.30 0 eng prog start 11:48:15 09 Mar

114815.41 0 eng prog end 11:48:15 09 Mar

114817.34 0 eng prog start 11:48:17 09 Mar

114817.47 0 eng prog end 11:48:17 09 Mar

115015.92 0 eng prog start 11:50:15 09 Mar

115016.05 0 que found 1/30

115016.06 0 SendEmailMapi 2

115016.06 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

115016.33 0 SendEmailMapi returned

115016.33 0 eng send attempt 1 result = success

115016.45 0 eng prog end 11:50:16 09 Mar

115102.06 0 eng prog start 11:51:02 09 Mar

115102.19 0 que found 1/30

115102.20 0 SendEmailMapi 2

115102.20 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

115102.56 0 SendEmailMapi returned

115102.56 0 eng send attempt 1 result = success

115102.67 0 eng prog end 11:51:02 09 Mar

115104.13 0 eng prog start 11:51:04 09 Mar

115104.25 0 eng prog end 11:51:04 09 Mar

115106.20 0 eng prog start 11:51:06 09 Mar

115106.31 0 eng prog end 11:51:06 09 Mar

115146.77 0 eng prog start 11:51:46 09 Mar

115146.88 0 que found 1/30

115146.89 0 SendEmailMapi 2

115146.89 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

115147.08 0 SendEmailMapi returned

115147.08 0 eng send attempt 1 result = success

115147.19 0 eng prog end 11:51:47 09 Mar

115315.33 0 eng prog start 11:53:15 09 Mar

115315.44 0 que found 1/30

115315.45 0 SendEmailMapi 2

115315.45 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

115315.63 0 SendEmailMapi returned

115315.63 0 eng send attempt 1 result = success

115315.73 0 eng prog end 11:53:15 09 Mar

115317.38 0 eng prog start 11:53:17 09 Mar

115317.48 0 eng prog end 11:53:17 09 Mar

115401.45 0 eng prog start 11:54:01 09 Mar

115401.56 0 que found 1/30

115401.56 0 SendEmailMapi 2

115401.56 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

115401.89 0 SendEmailMapi returned

115401.89 0 eng send attempt 1 result = success

115402.00 0 eng prog end 11:54:02 09 Mar

115501.89 0 eng prog start 11:55:01 09 Mar

115502.00 0 que found 1/30

115502.02 0 SendEmailMapi 2

115502.02 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

115502.14 0 SendEmailMapi returned

115502.14 0 eng send attempt 1 result = success

115502.25 0 eng prog end 11:55:02 09 Mar

115507.95 0 eng prog start 11:55:07 09 Mar

115508.06 0 que found 1/30

115508.06 0 SendEmailMapi 2

115508.08 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

115508.14 0 SendEmailMapi returned

115508.14 0 eng send attempt 1 result = success

115508.25 0 eng prog end 11:55:08 09 Mar

115510.00 0 eng prog start 11:55:10 09 Mar

115510.11 0 eng prog end 11:55:10 09 Mar

115512.09 0 eng prog start 11:55:12 09 Mar

115512.22 0 eng prog end 11:55:12 09 Mar

115642.31 0 eng prog start 11:56:42 09 Mar

115642.42 0 que found 1/30

115642.44 0 SendEmailMapi 2

115642.44 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

115642.64 0 SendEmailMapi returned

115642.64 0 eng send attempt 1 result = success

115642.75 0 eng prog end 11:56:42 09 Mar

115644.36 0 eng prog start 11:56:44 09 Mar

115644.47 0 eng prog end 11:56:44 09 Mar

115646.41 0 eng prog start 11:56:46 09 Mar

115646.52 0 eng prog end 11:56:46 09 Mar

115800.47 0 eng prog start 11:58:00 09 Mar

115800.58 0 que found 1/30

115800.58 0 SendEmailMapi 2

115800.59 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

115800.91 0 SendEmailMapi returned

115800.91 0 eng send attempt 1 result = success

115801.03 0 eng prog end 11:58:01 09 Mar

115802.52 0 eng prog start 11:58:02 09 Mar

115802.66 0 eng prog end 11:58:02 09 Mar

115854.66 0 eng prog start 11:58:54 09 Mar

115854.78 0 que found 1/30

115854.80 0 SendEmailMapi 2

115854.80 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

115854.91 0 SendEmailMapi returned

115854.91 0 eng send attempt 1 result = success

115855.02 0 eng prog end 11:58:55 09 Mar

115856.73 0 eng prog start 11:58:56 09 Mar

115856.84 0 eng prog end 11:58:56 09 Mar

120000.92 0 eng prog start 12:00:00 09 Mar

120001.03 0 que found 1/30

120001.05 0 SendEmailMapi 2

120001.05 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

120001.66 0 SendEmailMapi returned

120001.66 0 eng send attempt 1 result = success

120001.77 0 eng prog end 12:00:01 09 Mar

120029.05 0 eng prog start 12:00:29 09 Mar

120029.16 0 que found 1/30

120029.17 0 SendEmailMapi 2

120029.17 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

120029.41 0 SendEmailMapi returned

120029.42 0 eng send attempt 1 result = success

120029.53 0 eng prog end 12:00:29 09 Mar

120031.13 0 eng prog start 12:00:31 09 Mar

120031.23 0 eng prog end 12:00:31 09 Mar

120101.17 0 eng prog start 12:01:01 09 Mar

120101.28 0 que found 2/31

120101.28 0 SendEmailMapi 2

120101.30 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

120101.42 0 SendEmailMapi returned

120101.42 0 eng send attempt 1 result = success

120101.53 0 que found 1/30

120101.53 0 SendEmailMapi 2

120101.53 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

120101.67 0 SendEmailMapi returned

120101.67 0 eng send attempt 1 result = success

120101.78 0 eng prog end 12:01:01 09 Mar

121702.30 0 eng prog start 12:17:02 09 Mar

121702.41 0 que found 1/30

121702.42 0 SendEmailMapi 2

121702.42 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

121702.58 0 SendEmailMapi returned

121702.58 0 eng send attempt 1 result = success

121702.69 0 eng prog end 12:17:02 09 Mar

121900.38 0 eng prog start 12:19:00 09 Mar

121900.48 0 que found 5/34

121900.48 0 SendEmailMapi 2

121900.50 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

121900.77 0 SendEmailMapi returned

121900.77 0 eng send attempt 1 result = success

121900.88 0 que found 4/33

121900.88 0 SendEmailMapi 2

121900.88 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

121901.02 0 SendEmailMapi returned

121901.02 0 eng send attempt 1 result = success

121901.13 0 que found 3/32

121901.13 0 SendEmailMapi 2

121901.14 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

121901.27 0 SendEmailMapi returned

121901.27 0 eng send attempt 1 result = success

121901.38 0 que found 2/31

121901.38 0 SendEmailMapi 2

121901.38 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

121901.52 0 SendEmailMapi returned

121901.52 0 eng send attempt 1 result = success

121901.63 0 que found 1/30

121901.63 0 SendEmailMapi 2

121901.63 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

121901.77 0 SendEmailMapi returned

121901.77 0 eng send attempt 1 result = success

121901.88 0 eng prog end 12:19:01 09 Mar

121902.42 0 eng prog start 12:19:02 09 Mar

121902.53 0 eng prog end 12:19:02 09 Mar

122000.47 0 eng prog start 12:20:00 09 Mar

122000.58 0 que found 4/33

122000.59 0 SendEmailMapi 2

122000.59 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

122000.77 0 SendEmailMapi returned

122000.77 0 eng send attempt 1 result = success

122000.88 0 que found 3/32

122000.88 0 SendEmailMapi 2

122000.89 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

122001.02 0 SendEmailMapi returned

122001.02 0 eng send attempt 1 result = success

122001.13 0 que found 2/31

122001.13 0 SendEmailMapi 2

122001.13 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

122001.25 0 SendEmailMapi returned

122001.27 0 eng send attempt 1 result = success

122001.38 0 que found 1/30

122001.38 0 SendEmailMapi 2

122001.38 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

122001.52 0 SendEmailMapi returned

122001.53 0 eng send attempt 1 result = success

122001.64 0 eng prog end 12:20:01 09 Mar

122002.52 0 eng prog start 12:20:02 09 Mar

122002.63 0 eng prog end 12:20:02 09 Mar

122100.56 0 eng prog start 12:21:00 09 Mar

122100.69 0 que found 1/31

122100.69 0 SendEmailMapi 2

122100.70 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

122100.77 0 SendEmailMapi returned

122100.77 0 eng send attempt 1 result = success

122100.88 0 eng prog end 12:21:00 09 Mar

122102.63 0 eng prog start 12:21:02 09 Mar

122102.73 0 eng prog end 12:21:02 09 Mar

122700.81 0 eng prog start 12:27:00 09 Mar

122700.92 0 que found 1/31

122700.94 0 SendEmailMapi 2

122700.94 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

122701.19 0 SendEmailMapi returned

122701.19 0 eng send attempt 1 result = success

122701.30 0 eng prog end 12:27:01 09 Mar

122702.86 0 eng prog start 12:27:02 09 Mar

122702.97 0 eng prog end 12:27:02 09 Mar

122901.05 0 eng prog start 12:29:01 09 Mar

122901.16 0 que found 4/35

122901.17 0 SendEmailMapi 2

122901.17 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

122901.44 0 SendEmailMapi returned

122901.44 0 eng send attempt 1 result = success

122901.56 0 que found 3/34

122901.56 0 SendEmailMapi 2

122901.58 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

122901.69 0 SendEmailMapi returned

122901.69 0 eng send attempt 1 result = success

122901.81 0 que found 2/33

122901.81 0 SendEmailMapi 2

122901.81 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

122901.94 0 SendEmailMapi returned

122901.94 0 eng send attempt 1 result = success

122902.05 0 que found 1/32

122902.05 0 SendEmailMapi 2

122902.06 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

122902.20 0 SendEmailMapi returned

122902.20 0 eng send attempt 1 result = success

122902.34 0 eng prog end 12:29:02 09 Mar

123001.11 0 eng prog start 12:30:01 09 Mar

123001.22 0 que found 1/35

123001.22 0 SendEmailMapi 2

123001.22 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

123001.34 0 SendEmailMapi returned

123001.34 0 eng send attempt 1 result = success

123001.45 0 eng prog end 12:30:01 09 Mar

123701.55 0 eng prog start 12:37:01 09 Mar

123701.66 0 que found 1/36

123701.67 0 SendEmailMapi 2

123701.67 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

123701.86 0 SendEmailMapi returned

123701.86 0 eng send attempt 1 result = success

123701.97 0 eng prog end 12:37:01 09 Mar

124129.98 0 eng prog start 12:41:29 09 Mar

124130.09 0 que found 1/41

124130.11 0 SendEmailMapi 2

124130.11 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

124130.14 0 SendEmailMapi returned

124130.14 0 eng send attempt 1 result = MAPI_E_LOGIN_FAILURE

124130.14 0 SendEmailMapi 2

124130.14 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

124130.16 0 SendEmailMapi returned

124130.16 0 eng send attempt 2 result = MAPI_E_LOGIN_FAILURE

124130.27 0 eng prog end 12:41:30 09 Mar

124132.03 0 eng prog start 12:41:32 09 Mar

124132.14 0 eng prog end 12:41:32 09 Mar

124528.38 0 eng prog start 12:45:28 09 Mar

124528.50 0 que found 1/41

124528.52 0 SendEmailMapi 2

124528.52 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

124528.55 0 SendEmailMapi returned

124528.55 0 eng send attempt 1 result = MAPI_E_LOGIN_FAILURE

124528.55 0 SendEmailMapi 2

124528.55 0 SendEmailMapi about to send to cnrctrials@mail.wch.sa.gov.au

124528.56 0 SendEmailMapi returned

124528.56 0 eng send attempt 2 result = MAPI_E_LOGIN_FAILURE

124528.67 0 eng prog end 12:45:28 09 Mar

124530.44 0 eng prog start 12:45:30 09 Mar

124530.55 0 eng prog end 12:45:30 09 Mar

124532.48 0 eng prog start 12:45:32 09 Mar

124532.59 0 eng prog end 12:45:32 09 Mar

 

Please can you have a look at this and see if you can determine why the emails are being sent 4 times each in total (ie once plus 3 retries)

[SupportTeam]

Thanks for the trace. Think we found why same email was sent multiple times if MAPI was used.

Please place attached .exe in VG's 5.2.1 directory and try again, posting trace if problem still persists.

 

PS.

Are the database problems you were having initially all sorted out?

VgEmailSender_5.2.1001.zip

[Guest Sarah]

No, the database problems as illlustrated in the event log that I sent you, are still happening. Any clues?

[SupportTeam]

Added more debugging around the area where error occurs. Please update v5.2.1 directory with this .exe and post trace.

 

What is the Database used?

 

Can you post the script and sample database so that we may reproduce the error?

 

How is the MAPI email send going after updating with new EmailSender.exe ?

 

[posted .EXE removed]

Edited 03/10/2004 10:54 PM by SupportTeam

[Guest Sarah]

The database is an Access 2000 database and it worked perfectly with the earlier version 5.1.8 of Voiceguide. I am not at work now, so I have not been able to test the .exe file you sent me. I will do it tomorrow morning. Here is an example of the database and the script for the module used.

 

[GetStrata]

Type=Database Query

DispSize=69

Txt=Using Birthweight, determine strata

DbDatabase=C:\VoiceGuide\Scripts\Randomisation\ACTORDSrand.mdb

DbUser=

DbConnectString=

DbSql=SELECT Strata FROM tblStrata WHERE (BirthWt = $RV[birthWt] and Gender = $RV[Gender])

on {Timeout 15} goto [ineligGA]

on {Fail} goto [ineligGA]

on {Success} goto [EntryCriteria]

[Guest Sarah]

What did you mean by this line:

 

Added more debugging around the area where error occurs. Please update v5.2.1 directory with this .exe and post trace

 

Was this in relation to the email sender .exe file. If not, then you didn't attach another file.

[SupportTeam]

The "Added more debugging around the area where error occurs. Please update v5.2.1 directory with this .exe and post trace" comment was related to the database problems you are having - the extra logging is in the vgmult.exe which was attached in same message.

 

New EmailSender.exe was posted in the previous post - please update your directory with both files and .zip and post both traces.

[Guest Sarah]

I have installed the files you gave me into the Voiceguide folder and have tried on 2 occasions to run the program. Attached are the .txt files it created.

 

I look forward to your response.

Trace_logs.zip

[SupportTeam]

Looks like the sending of email is OK now....

Trace shows first send attempt did not work due to logon failure as but next send attempt was OK and no more attempts after that were made.

 

We've determined cause of database problem.

In VG.INI file, section [moduleDBQuery] change:

 

RecordsetGetRowsMax=0

 

to

 

RecordsetGetRowsMax=1000

 

(or some other high value)

[Guest Sarah]

Well that has fixed the problem of retrieving the information from the database, but now it will not say the digits for the study number. As I have said before, I have not changed the scripts since upgrading to v5.2.1 and all these other things keep happening now.

 

Can you please have a look at the script that I have attached with particular notice to this module. It is meant to say the numbers after the voice file: Your number is: and followed by Please press 1 to confirm or 2 to hear the number again. It is playing the two voice files but not the numbers.

 

[say StudyID]

Type=Say Numbers

DispSize=69

Txt=Say the Study Number

PlayFile1=Voice Files\YourRandNoIs.wav

PlayFile2=$RV[GetStudyID_1_1]

PlayFile3=Voice Files\ProceedNoAgain.wav

Replay=0,0

SayNbrType=Digits

on {Timeout 9} goto [Print StudyID]

on {1} goto [Print StudyID]

on {2} goto [say StudyID]

 

Thanks

0311vgm.txt

[SupportTeam]

The patch version had a bug...

Please see: http://voiceguide.com/forums/index.php?showtopic=1247

and download the .exe in the last post from that thread.

 

(BTW: the current download from our WWW has all these issues addressed and there are no such bugs in the main download - this bug was in the 'special patch' version which was posted in a couple of threads. I will now remove the .exe with the bug from previous post...)

[Guest Sarah]

Thanks that has worked.

Now, how do I get rid of the extra debugging code that appears in the *vgtm.txt file?

[SupportTeam]

To reduce amount of data logged to file set the entries in VG.INI file section [Log] to a lower number (0 to turn off).

 

For log files which are to be supplied for us to look at we will need the tracing to be set to 10 (max value). otherwise log files do not have enough info in them for us to be able to diagnose problems.

[Guest Sarah]

Spoke too soon.

 

There is now a runtime error '6' overflow that is being created. I have attached the log file that may help.

 

Sarah

0312vgm.txt

[SupportTeam]

Please see:

 

http://voiceguide.com/forums/index.php?showtopic=1227

 

Instructions for resolving that problem are at the bottom of that thread.