Stonefield Query SDK
Stonefield Query for AccountMate
Stonefield Query for ACT!
Stonefield Query for Alere
Stonefield Query for GoldMine
Stonefield Query for HEAT
Stonefield Query for Sage 300 ERP
Stonefield Query for Sage Pro
There are many reasons why a scheduled report may not run. The first thing to do is open the Windows Task Scheduler, find the scheduled task, and check whether the task started. If not, perhaps the schedule hasn't been set up properly: wrong user account information, incorrect schedule time, etc.
If the task did start, make a note of the error code and look it up in the Running from Other Applications topic. That may point you in the right direction. If not, create a support ticket and mention the error code so we can help you resolve the problem.
Note: in Stonefield Query version 5.1 and later, you can use the Scheduled Tasks function in the Tools menu to see information about your scheduled reports.
One reason why scheduled reports may fail is when there are too many files in your temporary files folder (a folder such as C: Users\UserName\AppData\Local\Temp. Try deleting the files in this folder (some may give an error if they're currently in use; no harm done in that case) and checking if that resolves the problem.
Another reason is that the Windows Task Scheduler doesn't support mapped drives. So, if you specify an output file like J:\SomeFolder\SomeFile.xls in your scheduled report, or if the database Stonefield Query connects to is on a mapped drive, that drive won't be available to Stonefield Query when run as a scheduled task, and it'll fail.
Another reason is that Stonefield Query may not have terminated properly the last time it was run. Ensure Stonefield Query isn't running, then open the Windows Task Manager (taskman.exe) and look for "sfquery.exe" in the Processes tab. If you find it, end the process.
If the problem is that emails aren't being sent, the problem may be that you've configured Stonefield Query to send emails using MAPI, a Windows technology for communicating with mail servers. Unfortunately, MAPI doesn't seem to be very reliable when used from scheduled tasks. We recommend choosing Options from the Stonefield Query Tools menu, selecting the Email page, and choosing SMTP for sending emails instead.
Some people had problems with Microsoft Exchange SMTP servers that they weren't able to overcome. In that case, a workaround was found using Gmail to use with scheduled tasks, which appears to work consistently. It might be worthwhile to test with Gmail to help rule out SMTP server specific problems. To use Gmail with Stonefield Query, use the following settings:
Mail Server Address: smtp.gmail.comSMTP Port: 587Use SSL/TLS: CheckedMy email server requires authentication: checked
For username, use the gmail email address, and the google password
If the test doesn't work, you may need to turn on less secure sign in access. To do that, navigate to www.google.com/settings/security/lesssecureapps
« Go back