Support Article
Opening a data type takes 30 seconds to 1 minute
SA-86817
Summary
User opens a data type. However, 30 seconds to 1 minute is required to display the initial screen on the right side window. This occurs post upgrading to Pega 8.2.2.
Error Messages
Query timed out error message in the log:
936 [http-XXXXXX] [TABTHREAD1] [ ] [onduitSideB] ( rd.queryexec.SqlQueryExecutor) ERROR #####- An error occured on executing the query for the report definition - There was a problem getting a list: code: 0 SQLState: HY008 Message: The query has timed out.
DatabaseException caused by prior exception: The query has timed out.
| SQL Code: 0 | SQL State: HY008
DatabaseException caused by prior exception: The query has timed out.
| SQL Code: 0 | SQL State: HY008
pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: 0 SQLState: HY008 Message: The query has timed out.
DatabaseException caused by prior exception: microsoft.sqlserver.jdbc.SQLServerException: The query has timed out.
| SQL Code: 0 | SQL State: HY008
DatabaseException caused by prior exception: microsoft.sqlserver.jdbc.SQLServerException: The query has timed out.
| SQL Code: 0 | SQL State: HY008
Steps to Reproduce
- Open the Data Type tab
- Double click the data type
Root Cause
A defect or configuration issue in the operating environment. Incorrect Dynamic System Setting (DSS) is used for installation on the Microsoft SQL server.
Resolution
Perform the following local-change:
- Use the below Dynamic System Setting (DSS)
Setting Purpose: reporting/useMergeHintForRRquery
Owning Ruleset: Pega-Reporting
Value: True
- Restart the server
Published December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.