Cases pages time-out when opening, seeing really slow performance on specific pages (Article # 306)
View products that this article applies to.
Problem:
Case pages fail to load, and a time-out error occurs.
The log file shows the following query timed out before completion.
SELECT count(*) FROM table_case WHERE case_victim2case = 272803084
With a large number of case records, not having an index on the case_victim2case relation would cause this query to time-out.
Resolution:
Two possible resolutions:
If Parent-Child cases are in use, add the index for the case_victim2case relation on the case table.
If Parent-Child cases are not in use, turn off the web commands for Parent/Child cases in DovetailAdmin.
Information about queries that take a long to to execute can be found in the largequery.log. This log can be configured by editting the agebt_logging.config file, in the LargeQueryAppender section.
Applies To: