Agile Studio - Problem to create Story

General
, , ,
1

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

LogPegaSQL (1).txt (15.6 KB)

2

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.