Question
Bradesco Seguros
BR
Last activity: 9 Feb 2022 7:12 EST
Agile Studio - Problem to create Story
We are using Agile Studio version 8.6.x to manage the Backlog in our project and we identified a bug when creating a Story for planning a sprint.
When clicking on the option to create a story, the processing time is well taken and we verified that the combo that should load the categories to be selected for the story, is not working.
When checking the log, we identified that there is a query being executed that is taking a very long time, which leads to the following error in the Database:
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.
I provide the attached log for more details and where the executed query contains.
We are using a SQL 2019 database.
Rules used:
Data Page - D_GetUserStoryCategory
Report Definition - GetFieldValuesList
Accepted Solution
Bradesco Seguros
BR
We opened an incident and the following procedure was indicated when working with the SQL Server Database
Please set below DSS in the environment. There will be no need to restart. These will cause us to generate the report requests with a query hint to direct the SQL optimizer.
Purpose: reporting/useForceOrderHint Ruleset: Pega-RULES Value: true Purpose: reporting/useForceOrderHintForRRandAC Ruleset : Pega-RULES Value :true Purpose: reporting/useMergeHintForRRquery Ruleset: Pega-Reporting Value: true Purpose: racache/useForceOrderHintForInvalidationQuery Ruleset : Pega-RULES Value :true
After apply this procedure the problem solved.