BI Publisher (MOSC)

MOSC Banner

Custom BI report fails intermittently with SQL query time exceeds the limit (2400 sec).

edited Sep 4, 2019 11:02AM in BI Publisher (MOSC) 4 commentsAnswered

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?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center