I know there are a whole range of causes for this message. What I can't find is a reason why a given query would produce this error then run without any problems a minute or two later.
I'm getting it from different queries which run as part of a nightly refresh.
All of these have run hundreds of times in the past and, without any changes being made to them, run with no errors later the same day.
Usually, if something goes from erroring to working in the space of five or ten minutes, it's because the network connections here are somewhat flakey and a connection to a linked table drops out then returns. In the case of this error, though, it even sometimes happens when inserting a record into a local table, so I know that's not the problem.
I'm getting it from different queries which run as part of a nightly refresh.
All of these have run hundreds of times in the past and, without any changes being made to them, run with no errors later the same day.
Usually, if something goes from erroring to working in the space of five or ten minutes, it's because the network connections here are somewhat flakey and a connection to a linked table drops out then returns. In the case of this error, though, it even sometimes happens when inserting a record into a local table, so I know that's not the problem.