Hi All,

I have a big problem with the SQL Tasks in VisualCron :
Some time, my SQL tasks stops in the middle of their exection without any reason and in success state.
The next SQL Task starts without problems and I haven't any timeout configured on them.
The SQL Task stop generaly after 15-20min.

I don't understand why.

Thanks.

1. Could it be a timeout or similar?
2. Are you able to see what happens at SQL server level?
3. Is it a stored procedure or simple sql text?

---

Hi,

No timeout on the Tasks and on the Jobs.
Because the random nature of the problem, I'm not able the see what happen on the SQL Server
Simple query and stored proc have the same problem

I also tried on multiple SQL server but same problem.

No output in output column?

---

No output and no error

I am not a master at SQL debugging but VisualCron should report an error if something went wrong, either in execution or timeout.

I recommend that you create a copy of that SQL and add some debugging within the SQL. Or, if you can reproduce the error in form of a table and query we could try it here.

---

Hi,

After some test, It's appear that SQL Messages (like "PRINT" statements) are not store in stdout or stderr and If we have multiple results (multiple SELECT), only the first one is store in stdout.

With that, it's pretty hard to debug what's wrong :/

Regards,

What if you divide Tasks into separate selects? Then you may find which select that hangs.

---