Facing SQl time out Error for Performance Document report
We are facing SQL time out error when scheduling the performance document report for 2021 mid year.
Report is not failing when run for few users and also not failing for 2020 or 2019 Performance document filter.
We are trying to fetch questionarie responses(answer texts) as part of this report, when this particular blocks are commented, report is running successfully.
Below is the blocks we are using to fetch answer_texts