Custom BI report fails intermittently with SQL query time exceeds the limit (2400 sec).
There are multiple custom reports which sometimes runs successfully within 2 mins and sometimes for the same set of data/parameters fails with below error:
SQL query time exceeds the limit (2400 sec). Stopped processing.
[INSTANCE_ID=bip.bi_serverHA]
If we clear Bi cache , it works but user came back asking for permanent fix as they cannot every-time keep on clearing Bi cache as the reports started failing more frequently.
Could you please suggest any solution for the custom BI reports for such issues?