You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Facing SQl time out Error for Performance Document report

Received Response
7
Views
1
Comments
edited Jul 19, 2021 10:54AM in Performance Management 1 comment

Content

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

 ,(SELECT to_char(SUBSTR(regexp_replace(NVL(qr.answer_text, qa.long_text), '<[^>]+>|\&(nbsp;)|(amp;)', ''),1,2000))
    FROM hra_evaluations he,
        hra_eval_participants ep,
        hrq_qstnr_participants qp,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!