Oracle Analytics Cloud and Server

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

"No Log Found" error while viewing logs in Manage Sessions

Received Response
536
Views
3
Comments

Hi,

OBIEE 11.1.1.7.160119

I am struggling with a strange issue.  We have 5 OBI instances.  In 2 instances, I am getting this "No Log Found" error message when I try to view log for an OBIEE report via Administration -> Manage Sessions -> View Log.  I am able to view the log in remaining 3 OBI instances.  All these instances have been setup the same way (as far as I know) for approx 2 years now.  While checking the performance for a report, we noticed this strange behavior.

So I compared all the 5 instances and all the below settings are consistent across all the instances.

Repository - Logging level is set to 0.  I see lot of links suggesting to set this to 2 minimum.  I have no idea why it is working for us in certain instances.

RPD_Logging_Level 2017-05-24_16-17-00.png

Enterprise Manager - FMC - logging level is set to Info.

EM_FMC 2017-05-24_16-16-36.png

List of values for Log Level

EM_FMC 2017-05-24_16-17-46.png

If I set the log level for individual report by adding the below text to the report -> Advanced Tab -> Prefix text box, I can view the log.

SET VARIABLE LOGLEVEL=2,DISABLE_CACHE_HIT=1;

Since all the settings are same across all the instances and it is working for some and not for others is more confusing/bothering.  How can I go about troubleshooting this issue?

Thanks in advance.

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 7 - Analytics Coach

    What about user level logging in all the environments, is there anything specifically set?

  • Rank 6 - Analytics Lead

    Could you also check below points:

    1. Open repository RPD in online mode in BI Administrator as the Administrator user.

    2. Then choose -> Manage -> Identity Manager-> Locate if User exists here -> Check out individual user and check there log level.

    3. Then choose Manage -> Variables -> Expand Session Variables -> Locate variable called LOGLEVEL -> Check what value is set here.

  • Rank 2 - Community Beginner
    skull wrote:Repository - Logging level is set to 0

    ^--- This is why there's no query logs

    skull wrote:I have no idea why it is working for us in certain instances....SET VARIABLE LOGLEVEL=2,

    ^--- This is why you have some logs.

    So you have an inconsistent setup. With only some explicit analyses logging their stuff. Logging to 0 is a bad idea. No troubleshooting, no possibility to see what has happened.  Set it to minimum 2 for everything.

    Also: If someone tells you "logging costs performance" .... basically get rid of that person. They don't know what they're talking about

Welcome!

It looks like you're new here. Sign in or register to get started.