Dashboard drop down is taking more than 2 mins to load — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Dashboard drop down is taking more than 2 mins to load

Received Response
11
Views
5
Comments
User_AV9GR
User_AV9GR Rank 1 - Community Starter

Hi All,

Currently we are using OBIEE 11.1.1.7.140715

Once we logon to analytics link using SSO and click on "Dashboards" drop down, its taking more time to load. Can anyone suggest what could be the cause and best solution for that?

Sometimes its very fast. Not sure of cause for this inconsistent behaviour

pastedImage_0.png

Thanks in advance.

Raja

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    3269969 wrote:Sometimes its very fast. Not sure of cause for this inconsistent behaviour 

    That doesn't sound like you did a lot of investigation in to "What actually causes this?".

    So with regards to your question "Can anyone suggest what could be the cause and best solution for that?":

    1.) The cause can be pretty much anything. Most likely people will throw random things at you in this thread which you will the randomly try out without reflection on why this could be the solution for a problem you have not researched.

    2.) The best solution is always: "It depends."

    Seriously: Have you looked at any log files like the nqqery.log? If yes, which ones and what do the log files say? It can be (CAN be - I'm not saying it IS that!) that you're simply hitting a total performance bottleneck while thr prompt fires off its query in the background.

    What kind of analysis and investigation have you done so far in general (apart from the obvious log files above)? WHERE are you losing performance because of WHAT?

    In all honesty it is impossible to solve issues like this by just asking a question and then - again - randomly starting to push buttons and turn knobs.

    As we keep saying in here and Robin has so nicely pointed out: Evidence based design and diagnostics!

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    @3269969 Did you abandon this question? Is it still open?

  • User_AV9GR
    User_AV9GR Rank 1 - Community Starter

    Hi There,

    Yes, i did not do much investigation to identify the exact root cause.

    We have access to dev servers and we didnt face similar issue in dev. This is identified in production and we are requested to find the cause for it. Unfortunately i do not have access to the production server and not sure of where to check on it.

    I posted this query to see if anyone else in the Oracle community had similar issue and did anything to resolve it.

    Because for these inconsistent issues, Oracle suggested to post in community where we get answers to most of the unanswered questions.

    Please let me know in case if we are not allowed to post without actually knowing the root case. And if i had known how to debug it, i would have not posted the query itself.

    Thanks

    Raja

  • Daniel Willis
    Daniel Willis Rank 4 - Community Specialist

    You can view most of the logs in Enterprise Manager in the log viewer if you can access it. The reality is you're not going to be able to do much without the access.. hopefully you can get into EM.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    3269969 wrote:I posted this query to see if anyone else in the Oracle community had similar issue and did anything to resolve it.

    In IT problems are a dime a dozen and performance issues are a cent a thousand :-) Plus: There are literally hundreds of potential factors influencing this.

    You are allowed to post anyhting. But without any context or explanation as you delivered them in this last update our responses will potentially be as useless as the initial post in terms of a qualified question ;-)

    Jokes aside: How does anybody expect you to solve an issue without access? Ask you management / client / whoever whether they also want to get invasive surgery without having been examined before. Just a thought...