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

OBIEE 12c User level logging in RPD

Received Response
63
Views
1
Comments
OracleUser_MUC6U
OracleUser_MUC6U Rank 5 - Community Champion
edited Aug 13, 2024 7:05PM in Oracle Analytics Cloud and Server

Hi,

I'm trying to utilize the user level logging in the RPD where the query's physical SQL is wrote to the nquery.log - I think the file is called $OBIEE_HOME /user_projects/domains/<domain>/servers/obis1/logs/obis1-query.log now in 12c, however I'm unable to get any queries logged.  I've went through setting the user logging to level 2 via the Admin Tool but its not logging anything.  Is obis1-query.log the correct file to look for this logging or is there another configuration step that's required in 12c?

Regards

Adrian

Answers

  • OracleUser_MUC6U
    OracleUser_MUC6U Rank 5 - Community Champion

    In the Analysis add the following to the prefix box on the Advance tab

    Set Variable LOGLEVEL=2;

    Not sure why the RPD server setting doesn't work.