Note: If your database is hosted by Blackbaud, please see How to troubleshoot scheduled queues hanging or failing in Blackbaud Hosting Services. The following steps apply only to local installations.
Complete the following steps at the computer where the Queue Service is installed for all The Financial Edge or The Raiser's Edge databases to resolve the issue:
- Make all scheduled queues OnDemand in all databases attached (including Sample database).
- Open the scheduled queue and select the Process tab.
- Select OnDemand from the Frequency drop-down.
- Remove all scheduled queues from the Queue Schedule in all databases (including Sample database):
- Click "Show Scheduled Queues" button.
- Uncheck the "Only show my queues" checkbox.
- Highlight all scheduled queues and Cancel them.
- Delete all queues listed in the Queue schedule.
- Uninstall the Queue Service by clicking the Uninstall Queue Service button.
- Stop and restart the IIS service. (Exiting the Program is not necessary.)
- Re-install the Queue Service by clicking the Install Queue Service button.
- Change all OnDemand queues back to the regular schedule. Ensure that each queue is scheduled with enough time to complete before the next queue will execute.
- If the queue is generating a report, then:
- Verify that a default printer has been set for the specific domain Windows account set up to run the Queue service ("Queue Windows account"). If it has not, log in as the Queue Windows Account and set a physical printer as the default.
- Verify that the Queue Windows account has permissions to the printer selected.
- If the queue is exporting or merging, then:
- Verify that the file path in the File Name field is using the UNC path, rather than a mapped drive, and is valid.
- Verify that the Queue Windows account has read and execute permissions to this UNC path.
a. Verify the number of licensed users that are able to use the software.
• How to find the number of licensed users for Raiser's Edge
b. Verify the number of active users that are connected to the database. If the number of active users connected in the Blackbaud Management Console equals the amount of licenses that were viewed in Step A, then it would be advisable to run the queues after hours when there are no other users logged into the system.
Note: If the queue hangs because too many licenses are being used, you will need to close out of the program on the machine dedicated to running scheduled queues. The program does not fully shut down when trying to log in once the maximum number of licenses has been taken.