I have setup a SQL connection that lets me log task progress.
I have it installed on several machines (all running 8.2.3) and it works beautifully. When the task completes, it logs either the OUTPUT or STDERR to my database and I can do everything I want.
EXCEPT in this one case. the task is a copy files task. In this case it's failing because the file is locked for use (this will happen from time to time and is not the issue)
But logging never occurs. SQL Profiler (SQL Server in user here) shows that no call to my SQL is ever made.
Drilling down to the variables, if I look at {TASK(Active,StdErr)} I get
TranslateVariables -> Unhandled error: Object reference not set to an instance of an object. on string {TASK(do88f4b0-13e6-4733-bfcb-63e7a4c59c75, StdErr)]
But the task log does properly show the error. Please advise.
Thanks.
(unfortunately this is a client machine behind a firewall and VM so I can't cut/paste so any typos are mine.