Guest srusse01 Report post Posted 02/26/2004 02:28 AM 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! Share this post Link to post
SupportTeam Report post Posted 02/26/2004 04:02 AM "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 Share this post Link to post
Guest Sarah Report post Posted 02/26/2004 11:30 AM 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? Share this post Link to post
SupportTeam Report post Posted 02/26/2004 12:09 PM It shouldn't, but lets see what the trace shows. Are you using v5.1.8 of VoiceGuide? Share this post Link to post
Guest sarah Report post Posted 03/01/2004 05:19 AM 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 Share this post Link to post
SupportTeam Report post Posted 03/01/2004 05:33 AM 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?) Share this post Link to post
Guest Guest Report post Posted 03/01/2004 10:44 PM 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) Share this post Link to post
SupportTeam Report post Posted 03/02/2004 12:40 AM 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. Share this post Link to post
Guest Sarah Report post Posted 03/09/2004 01:59 AM 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 Share this post Link to post
Guest Sarah Report post Posted 03/09/2004 02:01 AM 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? Share this post Link to post
Guest Sarah Report post Posted 03/09/2004 02:20 AM 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) Share this post Link to post
SupportTeam Report post Posted 03/09/2004 04:44 AM 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 Share this post Link to post
Guest Sarah Report post Posted 03/09/2004 05:33 AM No, the database problems as illlustrated in the event log that I sent you, are still happening. Any clues? Share this post Link to post
SupportTeam Report post Posted 03/09/2004 06:08 AM (edited) 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 Share this post Link to post
Guest Sarah Report post Posted 03/09/2004 07:12 AM 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] Share this post Link to post
Guest Sarah Report post Posted 03/09/2004 07:13 AM 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. Share this post Link to post
SupportTeam Report post Posted 03/09/2004 07:32 AM 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. Share this post Link to post
Guest Sarah Report post Posted 03/09/2004 11:05 PM 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 Share this post Link to post
SupportTeam Report post Posted 03/10/2004 01:20 AM 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) Share this post Link to post
Guest Sarah Report post Posted 03/10/2004 10:28 PM 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 Share this post Link to post
SupportTeam Report post Posted 03/10/2004 10:54 PM 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...) Share this post Link to post
Guest Sarah Report post Posted 03/11/2004 11:53 PM Thanks that has worked. Now, how do I get rid of the extra debugging code that appears in the *vgtm.txt file? Share this post Link to post
SupportTeam Report post Posted 03/12/2004 12:07 AM 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. Share this post Link to post
Guest Sarah Report post Posted 03/12/2004 12:28 AM 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 Share this post Link to post
SupportTeam Report post Posted 03/12/2004 12:38 AM Please see: http://voiceguide.com/forums/index.php?showtopic=1227 Instructions for resolving that problem are at the bottom of that thread. Share this post Link to post
