I have been having BCP fail on existing jobs that are scheduled via Maestro.
"SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Unable to open BCP host data-file"
is the error message. FTP log show normal entry and exit for the sender of the the incoming file. There are no other applications that use the file beside the batch update.
System backups run hours before or after the failure. In short no activity other then the sending and call to BCP are taking place. These jobs run normal 90% of the time and then fial but with no pattern I can see. For example one jobs runs 4 times a day
2:00 am 11:30 am 3:30 pm and 5:30 pm ..anyone of them can fail. and the rest are fine.
If I request a re-run after the failure...it works!
Anyone seen this before?