How to debug/troubleshoot issue related to NQSGETUSERS in OBIEE 12c ? — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

How to debug/troubleshoot issue related to NQSGETUSERS in OBIEE 12c ?

Received Response
51
Views
7
Comments
3064279
3064279 Rank 4 - Community Specialist
edited Aug 13, 2024 5:45PM in Oracle Analytics Cloud and Server

We are facing issue related to OBIEE 12c login after looking into the log, we found

     UserPopulation: GetUsers took 5 seconds for SQL {call NQSGetUsers

Now, we are not sure about the flow of this method execution, in other word where to look or debug ? What might be causing NQSGetUsers execution longer. We don't see any documentation about this method and what are related components.

So, anyone has any idea on what NQSGETUSERS does ? and how to debug this method (in other word, what are all components/layers I should verify)?

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    Have you searched the forum for similar threads?

  • 3064279
    3064279 Rank 4 - Community Specialist

    Yes, of course. I don't see this post answer anyway what I asked. My question is very specific to how  NQSGetUsers works and what are related component/layer I should check ?

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

    1.) Which "12c" version? We are standing at nineteen (19!) "12c" versions?

    2.)

    3064279 wrote:We don't see any documentation about this method and what are related components.

    And you won't because it's one of the internal ODBC calls used inside the OBI Server.

    3,) Looking at the other thread - this change here didn't affect you at all?

    4.) Did you check the responsiveness of the RCU DB and tables?

    5.) Did you do the testing with the init blocks which are also mentioned in the other thread?

  • 3064279
    3064279 Rank 4 - Community Specialist

    1.) To be very specific, it is 12.2.1.3.0

    3.) Not exactly

    4.) You mean, directly connecting them through some SQL client and check their performance ?

    5. ) So, I should check/test all the init blocks ? There are 25-30 in my case.

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

    3.) Adam said that using SIDs instead of service names eliminated a lot of issues - personally I'd at least *look* at this

    4.) Yes

    5.) Yes

    Performance issues aren't something where you can set GO_FASTER=true. They do actually require work and effort on your part.

  • 3064279
    3064279 Rank 4 - Community Specialist

    Just to mention, we have more than 5 machines and all of them are using service_name instead SID, but we are having this issue in 2 machine. I checked your other suggestion, where you mentioned about bad RCU, I would like to know what do you mean by bad RCU ?

    Also, right now we are debugging this issue by disabling and enabling init block to see, if init block has anything to do here. 

  • Michael Verzijl
    Michael Verzijl Rank 6 - Analytics Lead

    You can also enable the tracking of initblocks in Usage tracking table s_nq_initblock.

    See Welcome to OBIEE12c - Set-up Usage Tracking – Part 1 - Red Stack Tech  for an example.