That error is a red herring, and is not the cause of this issues, you'd see that error being posted in most operations, however its not critical, not a show stopper, hence not being posted to the EV event logs.
Also when you start the job, don't you get an option of how often it will update the TXT file?
If you find somewhere where we can download the DTrace, we can see where the bottleneck is, it could be sql, the source or the centera, but only the dtrace will tell us that