Welcome Guest, Login

Page History: Report Timeout Error

Compare Page Revisions

21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 Current 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Tue, 10 Apr 2018 15:28

These are some steps you can take to resolve timeout errors:

1) The easiest and simplest solution is to restart the business tier service by following the instructions here.

2) Check for Advanced Indexing Options by following the instructions here.

3) Complete necessary maintenance on the database by following the instructions here.

4) Verify the CAREWare server meets operating requirements by reviewing the performance checklist here.

5) Installing the latest version of SQL can improve performance and security. Here is additional information about CAREWare recommendations for SQL.

Below are settings that can be adjusted to improve performance or give reports more time to complete.

Increase the Command and Query values

1. Go to C:\Program Files\CAREWare Business Tier (Program Files (x86) for CAREWare version 5.0).
2. Scroll to CW Admin.
3. Right-click CW Admin.
4. Click Run as Administrator.
5. Click Stop Server.
6. In the drop down for Table Name select LocalNumberStorage.
7. Click Command Timeout.
8. Click Edit.
9. Double the current value.
10. Click Save.
11. Click query Timeout to highlight it.
12. Click Edit.
13. Double the current value.
14. Click Save.
15. Click Start Server.
    

Increase the report timeout value

1. Go to C:\Program Files\CAREWare Business Tier (Program Files (x86) for CAREWare version 5.0).
2. Scroll to CW Admin.
3. Right-click CW Admin.
4. Click Run as Administrator.
5. Click Stop Server.
6. Click Common Storage Settings.
7. Click the column header cmm_st_pk to sort the column alphabetically.
8. Scroll to report Timeout.
9. Double the ReportTimeout value in the cmm_st_number field (default value is 180).
10. Click on a different column and row to save the change.
11. Click Server Settings.
    

Note: The RSR report has a timeout limit of 120 minutes for build 955 or newer and a timeout limit of 40 minutes for build 954 or earlier. The RSR report timeout limit is programmed into CAREWare as a separate setting.

Check to see if the message queue is full

The message queue is used on 64-bit machines to enable CAREWare to use the 32-bit DLL that generates the client URNs. If the message queue becomes full, then an issue similar to what you've experienced can occur. Here are instructions to purge the message queue.


Turn off PII encryption

PII enctyption is enabled by default within CAREWare and encrypts the cw_client table and cw_map_client_provider fields for Personally Identifiable Information (PII). In large databases and/or older systems the encryption/decryption of the fields can cause timeouts to occur. Here are instructions to turn of PII encryption.

Note: This is a security feature and disabling PII encryption will allow for PII information to be displayed on the cw_client and the cw_map_client_provider tables.

6) Check the Recovery Model is set to Simple and not Full for cw_data and the cw_change_logs. 

By default the CAREWare setup file and any provided scripts from the CAREWare help desk will create a database using the Simple recovery model. We do not suggest users change the recovery model as it will slow SQL Server in most instances and CAREWare does not support nor is it programmed to use point in recovery (Full recovery model).

You can use the following steps to check & change the recovery model of the CAREWare SQL Server instances:

1. Start SQL Server Enterprise Manager (or SQL Management Studio)
2. Double-click Microsoft SQL Servers, double-click SQL Server Group, (Local), and then double-click Databases
3. Right-click each database, and then click Properties
4. Click the Options tab
5. Under Recovery, set the model to Simple
6. Click OK
   

If you have to change the Recovery model from Full to Simple, make a backup after you are done

7) Check the autogrowth settings of the cw_data and cw_change_log_XXXX.

The Auto-growth setting should not be by a percentage (such as By 10%, Unrestricted Growth). Instead choose by X number of MB.

1. Connect to the CAREWare instance using a SQL Management tool, such as SQL Management Studio
2. Expand the Databases, right-click on CW_Data and choose Properties
3. Choose Files. This will show the auto-growth settings. This is also where the auto-growth settings can be changed