Guest elSueco Report post Posted 08/22/2006 08:18 AM Hello! I have a VB script inserting a post in the EmailQue database. The receiver receives the email every time, but when I look into the log file <date>.es I see an error all the time. I´ve been looking for a similar error in this forum without any luck. Here is the log: 100845,02 0 eng prog start 10:08:45 22 aug 100845,13 0 ERROR 5.2.2006 EmailDbQueue_FindDueCall [invalid use of Null] 100845,14 0 ERROR 5.2.2006 EmailDbQueue_FindDueCall [invalid use of Null] 100845,14 0 ERROR 5.2.2006 EmailDbQueue_FindDueCall [invalid use of Null] 100845,14 0 ERROR 5.2.2006 EmailDbQueue_FindDueCall [invalid use of Null] 100845,14 0 ERROR 5.2.2006 EmailDbQueue_FindDueCall [invalid use of Null] 100845,14 0 ERROR 5.2.2006 EmailDbQueue_FindDueCall [invalid use of Null] 100845,14 0 que found 1/1 100845,14 0 que current: ID=3 100845,14 0 que update ID=3to SendTime=0608221018 SendRetriesLeft=4 100845,14 0 smtp Status Connecting to SMTP Server (mysmtpserver)... 100845,38 0 smtp Status Initializing Communications... 100845,60 0 eng smtp send start To:someone@somedomain.com, Cc:, Bcc: 100845,60 0 smtp Status Sending Sender Information... 100845,60 0 smtp Progress 9% 100845,80 0 smtp Status Sending Recipient Information... 100845,80 0 smtp Progress 17% 100846,04 0 smtp Status Sending Message... 100846,04 0 smtp Progress 19% 100846,27 0 smtp Progress 100% 100846,49 0 smtp Progress 100% 100846,49 0 smtp Status Transmission Complete... 100846,49 0 smtp SendSuccesful 100846,49 0 que delete ID=3 100846,49 0 eng smtp send end 100846,49 0 smtp Status Closing Connection... 100846,71 0 eng send attempt 1 result = [success] 100846,82 0 eng prog end 10:08:46 22 aug 100847,07 0 eng prog start 10:08:47 22 aug 100847,18 0 eng prog end 10:08:47 22 aug As you can see it sends the email but I get this error. I stopped voiceguide, deleted the EmailQue.mdb database but it didn´t help. Please help! Jose Share this post Link to post
SupportTeam Report post Posted 08/22/2006 08:59 AM I have a VB script inserting a post in the EmailQue database. Why are you using a VBScript instead of using the "Send Email" module? If VBScript is the method of choice then the way to approach this would be to have a look at what entries in EmailQue look like when they are inserted by the "Send Email" module and replicate them. Still, it seems that using your current VBscript insert method the email does seem to be sent successfully despite the errors logged... does the email arrive OK to the recipient? Share this post Link to post
Guest elSueco Report post Posted 08/22/2006 03:24 PM Hello! Why are you using a VBScript instead of using the "Send Email" module? I am not using a vbscript module but a simple script as one of you recommended me in another thread. I have 2 IVR systems so this script will trigger when one IVR system will contact the other one. If VBScript is the method of choice then the way to approach this would be to have a look at what entries in EmailQue look like when they are inserted by the "Send Email" module and replicate them. I found an example in the Send Email tutorial that would insert a post in the EmailQue database. Yes, the email is sent every time. I am just worry about this Error in the log file. What should I do? Ignore the Error message? Thank you! Jose Share this post Link to post
SupportTeam Report post Posted 08/22/2006 09:05 PM If the email is sent and it's all working as intended then at this stage you can just ignore what that error message is. Can you post the VBScript you are using? We'll run a test on one of our systems here and see if this error still occurs with current version of VG. v5.2.2006 is a bit old and you should really update it to current version. If using a Dialogic cards then you should get VG for Dialogic. (your registration code will work) Share this post Link to post
Guest elSueco Report post Posted 08/23/2006 09:53 AM If the email is sent and it's all working as intended then at this stage you can just ignore what that error message is. Ok, I can live with that. Could you guide me what are the needed parameters when inserting a new post in the OutDialQue database? I just copied one record from this OutDialQue file into my script to try to make a call but without any luck; sometimes it says that I´m missing oneor more parameters or that something is worng with my SQL query. Do you have an example that works? Thank you! Jose Share this post Link to post
