Page History: Report Timeout Error
Compare Page Revisions
Page Revision: Wed, 24 Sep 2014 17:01
These are some steps you can take to resolve timeout errors:
1) Restart the business tier service
This is the easiest and simplest solution, though it does not always resolve the error.
- Locate and open the CW Admin.exe (Right-click and Run as Administrator)
- Click Stop Server
- Click Start Server
2) Increase the Command and Query values
These are located in the businessTierSettings.XML and can be easily accessed via the CW Admin utility.
- Locate and open the CW Admin.exe (Right-click and Run as Administrator)
- Click Stop Server
- Change the Table Name in the upper right corner to LocalNumberStorage
- Highlight the Command and click Edit
- Double the current value then click Save
- Highlight the Query and click Edit
- Double the current value then click Save
- Click Start Server
3) Increase the report timeout value
Increasing the timeout values would reduce the likelihood of these sites from encountering a timeout error when completing a report or finding a client.
To increase the report timeout value:
- Go to the business tier directory (Default location: C:\Program Files\CAREWare\RW CAREWare Business Tier\)
- Open the CW Admin.exe (You may need to right-click and Run As Administrator)
- Click Stop Server
- Click on the Common Storage Settings tab
- Click the column header cmm_st_pk to sort the column alphabetically
- Find the PK value labeled as ReportTimeout
- Double the ReportTimeout value in the cmm_st_number field (default value is 180)
- Click on a different column and row to save the change
- Click on the Server Settings tab
4) Check the message queue is not 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. Checking and deleting full message queues is slightly different
on each operating system. I've included the steps below for the Windows
Server 2008 OS.
- Open Computer Management
- In the console tree, expand
Computer Management>Services and Applications>Message
Queuing>Private Queues>eurngenerator - Right click on Queue Messages and select All Tasks , and then click Purge
- Click Yes to confirm that you want to delete all messages in the queue
- Repeat the same steps for the eurns message queue. After purging both queues restart the business tier service
5) Turn off PII encryption
PII enctyption is enabled by default within CAREWare and encrypts
the cw_client table fields for Personally Identifiable Information
(PII). In large databases and/or older systems the encryption/decryption
of the fields can cause to occur.
Note: This is a security feature and disabling PII
encryption will allow for PII information to be displayed on the
cw_client table.
To turn off the client encryption in version 5:
- Open the CW Admin.exe found in the business tier directory (Default
location: C:\Program Files\CAREWare\RW CAREWare Business Tier) - In the top right choose LocalNumberStorage
- Find the entry for EncryptPIIFields and set the value to 0 (that's a zero)
- Restart the Business Tier
If the entry for EncryptPIIFields is not on the list:
- Double check that you have LocalNumberStorage selected
- Click Add
- In the Tag box enter EncryptPIIFields (note that spelling is very important!)
- In the Setting box enter 0 (that's a zero)
- Click save
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:
- Start SQL Server Enterprise Manager (or SQL Management Studio)
- Double-click Microsoft SQL Servers, double-click SQL Server Group, (Local), and then double-click Databases
- Right-click each database, and then click Properties
- Click the Options tab
- Under Recovery, set the model to Simple
- 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.
- Connect to the CAREWare instance using a SQL Management tool, such as SQL Management Studio
- Expand the Databases, right-click on CW_Data and choose Properties
- Choose Files. This will show the auto-growth settings. This is also where the auto-growth settings can be changed