Hi,

I have a job with 5 tasks:

1. Query to a SQL database
   
2. Write header to a new file
   
3. Loop trough all the lines of task 1 and add them as data lines in the file from task 2
   
4. Copy the file to location A
   
5. Copy the file to location B

This job runs every two hours.

When I trigger this job manually, task 3 will not always copy all the data to the file. It just stops half way. When this happens, tasks 4 and 5 are not started, so it looks there is an error of some kind. The task/job icon is still green though.

The output of the 1st task gives me 309 rows and a header row.

The number of lines in the result file are different, 247 rows, 302 row, ... every run a different amount.

When the row amount is correct in the file, task 4 and 5 are triggered, so that's good.

In the logs I can't find a message telling the loop failed, so what else could it be. A bug perhaps?

Regards
Erik

---

Hi,

and is it a bug??

Regards
Erik

---

Do you have any error in the log file? Is it possible to create a small Job that can reproduce this?

---

Sorry for my late reaction.

There is no error in the log at all. The loop task stopping during the itteration and no next tasks are runned. So the complete job just stops.

I recreated the job, a SQL query task and two file write tasks. I left out the copy jobs. This recreated job is working every time. The other 'failing' job is created in a previous version and I updated to 6.0.4

Looks like something in the job is different for both... Maybe the loop task is corrupted during the upgrade.

I'll send you a backup of the two jobs so you might see the difference.

Regards,
Erik

---

When I recreate the job in 6.0.4 no problem, so it's solved.
Hoped I did not have to recreate the job though.

Topic closed.

Regards,
Erik

---