Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


Yann
  •  Yann
  • No customer Topic Starter
2010-01-05T15:32:28Z
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.
Sponsor
Forum information
Support
2010-01-05T16:13:38Z
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?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Yann
  •  Yann
  • No customer Topic Starter
2010-01-05T16:21:53Z
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.
Support
2010-01-05T16:22:48Z
No output in output column?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Yann
  •  Yann
  • No customer Topic Starter
2010-01-05T16:24:16Z
Support
2010-01-05T16:26:37Z
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.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Yann
  •  Yann
  • No customer Topic Starter
2010-01-07T09:57:01Z
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,
Support
2010-01-07T10:07:06Z
What if you divide Tasks into separate selects? Then you may find which select that hangs.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top