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 rotate the obis1-query log

Received Response
11
Views
5
Comments
BOG
BOG Rank 1 - Community Starter
edited Aug 13, 2024 5:35PM in Oracle Analytics Cloud and Server

We are troubleshooting some queries in OBIEE and our obis1-query.log is reaching 100MB.  Is there a way to archive/rotate this log manually?

thanks

Dan

University of Pittsburgh

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi Dan,

    I'm quite sure the file is rotated automatically like all other logs in OBIEE.

    Did you change something in your system to override the default log rotation settings?

  • Joel
    Joel Rank 8 - Analytics Strategist

    Should all be configured in Enterprise Manager:

    pastedImage_0.png

  • BOG
    BOG Rank 1 - Community Starter

    Gianni - They are automatic but we'd like to archive/rotate the current ones. Notepad++ is erroring out because they are too large.

  • BOG
    BOG Rank 1 - Community Starter

    Thanks!   This worked.

  • BOG
    BOG Rank 1 - Community Starter

    one more on this.  If I'm looking at my EM Consol, I see this it has a max log age as 3 days but clearly, my logs are going back a few months?

    [2018-08-27T08:59:43.373-04:00] [OBIS] [TRACE:5] [] [] [ecid: ] [sik: ssi] [tid: 17a8] [messageid: USER-80] [requestid: 79740026] [sessionid: 79740000] [username: xxxxxx] -------------------- Number of temp files generated internally for this logical request hash 46364001 : 0 . Temporary file info: no temp file

    Oracle_Question.jpg