We have a job that has been working very well for some time, but has since begun failing after loading 8.4.1.
Three Jobs are involved, so I think it's got something to do with kicking off another VC job and it not actually waiting for the 2nd job to finish before moving on.
1st job - Has the file trigger that then kicks off the other two jobs. After the two other jobs are finished, it creates an archive folder and then adds the trigger download file to a Zip archive (with deletion).
2nd job - Just runs an SSIS package that loads the file into SQL
3rd job - Loads the same data file into Cobol using an SSH task
The 1st and 2nd jobs are failing because it can't zip the file and delete because the file is still in use, and the 2nd job fails in VC and SSIS because the file isn't there. It's definitely like they are competing for the file, since it does ultimately get downloaded and archived.
Anyone else run into this?
Edited by moderator
2019-02-19T07:14:18Z
|
Reason: Not specified