I set up a task that issues a SQL call to an Oracle database. The output of the call is a list of email address that I wish to send the output of the job to.
My subsequent task is to email the output of the job to these addresses.
I use the 'PrevTask,stdout' in the 'to' field of the email.
The task was/is working perfectly on 6.0.6 version of VC, but is giving me an error on 6.0.9.
The error I get is: "77777" and the message "Exception in Task: Unaccepted server reply for command RSET (error code is 502)"

The weird thing is, if I copy the output of the SQL call and paste it into the 'to' field of the email, the task runs perfectly.

I tried writing the output to a file and then reading it into the 'file' in the 'to' field of the email but it gave me some other error.

Any suggestions?

Could you create a File write Task and use the same Variable and write the output to a file and then attach it here? Then we can test with the exact same content.

---

After some more testing. I found that the 6.0.6 client did NOT send out the email like I had thought.
I tried running it again and it is giving me an 'Exception in Task: Mail message assembly failed(error code 1)'
I looked at the file in hex it has a the standard layout with the standard '0d0a' terminators.

Do you use Variables from output in recipient as well?

---

yes. I was thinking that I should be able to use the prevtask,stdout in the 'To...' field of the recipients window.

Seems that you do not use 6.0.9. or latest version of it. This should have been fixed. Please re-install.

---

We're on version 6.1.1.
So, after letting my colleagues know this function was now fixed I proceeded to use it one of our new scripts and lo and behold..it's still not working.
This is what I've tried so far:
1. "Manual" entry with one address(I put the address in the box) ---> works fine
2. "Manual" entry point to a file with the address in it --->"Exception in Task: Unaccepted server reply
for command RSET (error code is 502)"
3. "Manual" entry using variable which I've filled with the same address from step 1 ---> same error as above

4. "File" entry using same email as in step 1 --> "Exception in task: ..." same as error from step2.

the error log:

8/29/2012 12:48:22 PM Debug Job (667) was added to processlist: Test: Process Droplist (monthly) File.
8/29/2012 12:48:22 PM Debug Next action: ActionContinue
8/29/2012 12:48:22 PM Debug Next Task is: Prod: Send email to appropriate people when this job completes successfully.
8/29/2012 12:48:22 PM Debug Calling StartTaskProcess() with Task: Prod: Send email to appropriate people when this job completes successfully. (0)
8/29/2012 12:48:22 PM Debug Task (1947) was added to processlist: Prod: Send email to appropriate people when this job completes successfully.
8/29/2012 12:48:22 PM Info Task started: Prod: Send email to appropriate people when this job completes successfully. (1947)
8/29/2012 12:48:22 PM Debug Entering wait loop. Prod: Send email to appropriate people when this job completes successfully. (1947)
8/29/2012 12:48:22 PM Err Exception in Task: Unaccepted server reply for command RSET (error code is 502)
8/29/2012 12:48:22 PM Info Task completed: Prod: Send email to appropriate people when this job completes successfully. (1947)
8/29/2012 12:48:22 PM Debug Process status - About to RemoveTaskProcess (1947)
8/29/2012 12:48:22 PM Debug Setting previous task in TaskProcessCompleted: Prod: Send email to appropriate people when this job completes successfully. (b4e096cd-29aa-4540-b04b-28823c74e6e7) in job: Test: Process Droplist (monthly) File.
8/29/2012 12:48:22 PM Debug Process status - About to SendTaskProcess (1947)
8/29/2012 12:48:22 PM Debug Process status - About to RemoveTaskProcess (1947)
8/29/2012 12:48:22 PM Debug Task (1947) was removed from processlist: Prod: Send email to appropriate people when this job completes successfully.
8/29/2012 12:48:22 PM Debug Running File Notification: 'Prod: Append to task output to job log.'
8/29/2012 12:48:22 PM Debug Sleep ended because Task ended.Prod: Send email to appropriate people when this job completes successfully. (1947)
8/29/2012 12:48:22 PM Debug TaskWaitQueue.Dequeued.Prod: Send email to appropriate people when this job completes successfully. (1947)
8/29/2012 12:48:22 PM Debug Next Task is: Prod: Job Failed: Write output to Logfile.
8/29/2012 12:48:22 PM Debug Calling StartTaskProcess() with Task: Prod: Job Failed: Write output to Logfile. (0)
8/29/2012 12:48:22 PM Debug Task (1948) was added to processlist: Prod: Job Failed: Write output to Logfile.
8/29/2012 12:48:22 PM Debug Entering wait loop. Prod: Job Failed: Write output to Logfile. (1948)
8/29/2012 12:48:22 PM Info Task started: Prod: Job Failed: Write output to Logfile. (1948)
8/29/2012 12:48:22 PM Debug Impersonation result 1: <ImpersonationResultClass xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><LoggedOn>true</LoggedOn><ProfileLoaded>false</ProfileLoaded><UsingLocalLogon>false</UsingLocalLogon><ImpersonatedAs>NT AUTHORITY\SYSTEM</ImpersonatedAs><ErrorOccured>false</ErrorOccured><ErrorString /></ImpersonationResultClass>
8/29/2012 12:48:22 PM Info Impersonation result 2: True
8/29/2012 12:48:22 PM Info Task completed: Prod: Job Failed: Write output to Logfile. (1948)
8/29/2012 12:48:22 PM Debug Process status - About to RemoveTaskProcess (1948)
8/29/2012 12:48:22 PM Debug Setting previous task in TaskProcessCompleted: Prod: Job Failed: Write output to Logfile. (b60e2801-66b1-448a-b96f-fef1fdade7bb) in job: Test: Process Droplist (monthly) File.
8/29/2012 12:48:22 PM Debug Process status - About to SendTaskProcess (1948)
8/29/2012 12:48:22 PM Debug Process status - About to RemoveTaskProcess (1948)
8/29/2012 12:48:22 PM Debug Task (1948) was removed from processlist: Prod: Job Failed: Write output to Logfile.
8/29/2012 12:48:22 PM Debug Running File Notification: 'Prod: Append to task output to job log.'
8/29/2012 12:48:22 PM Debug Sleep ended because Task ended.Prod: Job Failed: Write output to Logfile. (1948)
8/29/2012 12:48:22 PM Debug TaskWaitQueue.Dequeued.Prod: Job Failed: Write output to Logfile. (1948)
8/29/2012 12:48:22 PM Debug Else (1)Prod: Job Failed: Write output to Logfile. (1948)
8/29/2012 12:48:22 PM Debug End of loop - iterating again.Prod: Job Failed: Write output to Logfile. (1948)
8/29/2012 12:48:22 PM Debug Running Email Notification: 'Test email failure'
8/29/2012 12:48:22 PM Debug Running Email Notification: 'Test email failure'
8/29/2012 12:48:22 PM Debug Next execution (2) for job 'Test: Process Droplist (monthly) File.' is: 9/3/2012 9:07:07 AM
8/29/2012 12:48:22 PM Info Job completed: Test: Process Droplist (monthly) File.

I just tried to do it from the notifications window using a variable and it gave me the following

So I read the emails in a task, then selected 'manual' and used the stdout of previous task in the email task and it worked.
Seems like it does not work with reading from a file and user variables.
It would be nice if we could use files and variables as input.

Right, this is a bug in a email component we use. We have been waiting to upgrade as it is currently in a beta version. Hopefully we will upgrade for next version.

---