Error running OTBI report - The user request exceeded the maximum query governing execution time.

Abinaya P

There is an OTBI report which gives results when I run using my ID but the same report is giving error - "The user request exceeded the maximum query governing execution time" when we try to run via another user ID.

We have also added all the respective subject area duty roles.

Please suggest why are we receiving this error.

Shankar-Oracle

Do you have OTBI admin role assigned to your username?

What about the other user?

Arti Gupta-Oracle

I have also faced this issue multiple times, when I run a particular report it gives results quickly(I have admin role) while other users who are not admin, but having required access to fetch the data are facing this error. Could you please help in understanding and resolving the issue.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/73565#Comment_73565

Hi @Arti Gupta-Oracle,

Welcome to the Oracle Analytics Community!

If a report is working fine for Admin User but taking long amount of time for non-admin user, then the security filters that are getting applied for non-admin user is creating performance issue.

You need to generate both queries (Admin & Non-Admin) and compare to see the differences. After analyzing the query, need to see if adding any particular filter or an index column make situation better.

Hope this help.

Thank you.