I am attempting to run a simple SQL Query against a MYSQL database, and am receiving the following error message, which doesn't tell me anything:

'Exception in Task: Input string was not in a correct format.'

When I run the same command manually, I get the results I want. How can I debug the issue when that's the only information I get, even in the VisualCron main log.

thanks.

What query do you use? And what version of VisualCron?

---

It sounds like a problem is with a Variable format, maybe a date variable.

---

VisualCron 5.1.8.

Query:
SELECT ID_bescol, FROM_UNIXTIME(LEFT(FileDateTime, 10)) As LocalFileDateTime, bes.MFT_TPRef, bes.LocalFileName As LocalFileNameSource, bes.LocalFile_Destination, FROM_UNIXTIME(LEFT(CopyLog_DateTime, 10)) As CommCopyDateTime
FROM MFT_Audit_CAMKSEBXT005.BES left join MFT_Audit_CAMKSEBXT005.MFT on (BES.MFT_TPRef = MFT.MFT_TPRef)
WHERE ((FileDateTime - 300000) <= FileDateTime) And (MFT.MFT_TPRef IS null) And (bes.Man_validated IS null) ORDER BY LocalFileDateTime DESC;

No VisualCron variables are being used.

Ok, unfortunately it is hard to say with that older version. Is it possible that you could upgrade?

---

We are planning to, but it takes time for all the approvals, scheduling and such. Is there no way to correct/resolve the issue currently as it is a valid working query statement?

If other queries work then there is something specific. Try changing the query to see what's wrong. Start with removing the semicolon in the end.

---

This is my first attempt at a query in VisualCron, I have three queries, two return blank and run successful, which is what I intended from the results. The query that is returning something, is the one failing.

I see. Hard to day really. We tested against MySQL with your query and latest version without a problem. I suggest you try upgrading on one server to test this or just create this specific Task on another server with the latest version.

---