Knowledgebase
Stonefield Query Home > Stonefield Help Desk > Knowledgebase

Search help:


Scheduled reports do not run

Solution

Applies to:

  • 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.com
SMTP Port: 587
Use SSL/TLS: Checked
My 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

 
Was this article helpful? yes / no
Related articles Configuring Stonefield Query to Work with GMail
Moving Scheduled Reports to Another Computer
Schedule Wizard cannot create a schedule
Moving Stonefield Query to Another Computer
"Permission denied" error when scheduling a report for a user without a password.
Article details
Article ID: 6
Category: Frequently Asked Questions
Rating (Votes): Article rated 2.9/5.0 (74)

 
« Go back