Back to series

This video discusses the Database threads configuration in RightFax Enterprise Fax Manager and some common issues you may see if this configuration needs adjustment.

The RightFax Database module can respond to database requests from multiple clients and multiple protocols at the same time. The efficiency of this process depends on the number of database I/O threads available.

Database threads are used when requested by a client, then released to be used by another client. There is not a one-to-one mapping of users and database threads. Even if you have hundreds of users, ten database threads might be sufficient to meet demand.

You can view the current database threads being used by checking the database module service in Enterprise Fax Manager. Right-click the database module, and select Status. (If an error message appears, make sure that you are not using remote desktop.)

View the last active thread to see how many threads are being used.

For example, if you have 15 database threads and thread five is the last active thread, that means only five out of 15 database threads are busy. If most of your database threads are in use, consider incrementally increasing the threads by 5 at a time.

If the threads are being consumed quickly it may indicate that a third-party program is using all of the RightFax resources.

You may also see an "error 231" error message when client utilities such as FaxUtil, Enterprise Fax Manager or any 3rd party applications using the RightFax COM API try to connect to RightFax. This is a sign you may need to increase database threads as we have shown, and also check on other mitigating factors that could be impacting you.

The first issue is Work Requests.

Any RightFax process that issues SQL statements utilizes a database thread. RightFax work requests are stored in the RightFax Microsoft SQL Server database, so a buildup of work requests causes an increased load on the RightFax database module and on SQL Server. Purging the work requests can help to alleviate this load.

You can show work requests in the Enterprise Fax Manager Client application from the Utility Menu and Show Work Requests.

If you need to purge the Work Requests, there is utility in the RightFaxDatabase folder that you can run to clear errant items. Let us know at The Fax Guys if you need help with this process and we can advise what each work request actually pertains to and what you will be clearing out exactly.

Verify periodically that work requests do not build up again. A buildup of work requests can indicate a misconfiguration of your RightFax server.

If you are still seeing the error 231 message, or are experiencing client refresh issues, you can also increase the interval at which the client will refresh it's list of fax information:

From Enterprise Fax Manager open the user account(s) that are being affected, on the "Other" tab, increase the value in the "Update Interval In Seconds".

RightFax client applications refresh their fax information at a frequency that is based on the update interval of the logged-on RightFax account. By default, the update interval is set to 60 seconds, meaning every 60 seconds FaxUtil or Enterprise Fax Manager refreshes the information that appears in the user interface. Increasing the update interval decreases the frequency at which RightFax clients refresh their information, which in turn decreases the load on the server.

Last, you can check for issues with any programs that use the RightFax COM API.

A misconfigured program that uses the RightFax COM API can flood the database module with requests and cause "error code 231" message to appear. Because there is no easy way to tell what source is using the database threads, investigate to find out whether your environment includes third-party programs that use the RightFax COM API. If it does, try disabling the third-party programs temporarily to see if the issue goes away. If it does, you should contact the developer or vendor of the program for further troubleshooting of specific issues with that application.

That's it for this topic regarding the RightFax database threads and some of the common issues you can see with a lack of available database threads for the client applications.

As always, if you have any questions about this topic, or any topic in the world of faxing, let us know at The Fax Guys, we are always happy to help.

This is Jay Campbell with The Fax Guys for RightFax University saying thank you for watching and Please visit us again. The RightFax university is a work under continual progress and we update often.