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

Does any one know if there is any way we can limit long running BI reports in Weblogic?

Accepted answer
21
Views
5
Comments
User_27DEY
User_27DEY Rank 6 - Analytics Lead
in Oracle Analytics Cloud and Server

Hello, our reports have been running more than 3 hours, but we would like to kill these long run report, does any one know if there is any way we can limit long running BI reports in Weblogic? like weblogic console parameters setting etc? thanks !!

Best Answers

  • SteveF-Oracle
    SteveF-Oracle Mod
    Answer ✓

    Hi Jzhen,

    Since you mentioned Weblogic, I will assume you are using an on-prem product, such as Oracle Business Intelligence or Oracle Analytics Server.

    I am not sure if you are referring to classic answers analysis, publisher reports, or data visualization workbooks.
    I am also assuming you may be talking about "rogue" queries by users and not curated queries that are running 3 hours.

    Here is some general information from the documentation, to start.

    Set Query Limits

    Work With Query Limits

    Data Model Properties

    Memory Guard Properties

    It may help the community to understand more detail about the product and specific area you are referring to as "reports", how they are developed, etc., to guide you more precisely .

  • SteveF-Oracle
    SteveF-Oracle Mod
    Answer ✓

    Weblogic has the concept of network filters, but this won't help you in this case.
    Is there a reason you do not want to use the built in query governor feature?

    You need to look at the drivers you are using (ODBC/JDBC/SQL*Net) for your datasource connection type, or someting like what @Tim Ouimet mentioned if he is willing to share more details.

Answers

  • Tim Ouimet
    Tim Ouimet Rank 3 - Community Apprentice

    We're on-prem. Using MS SQL server - we have reporting that periodically checks open running queries. First threshold alerts and the second terminates. It is a process running outside OAS stack.

    OBIEE 10g, 11g & 12c and OAS

  • User_27DEY
    User_27DEY Rank 6 - Analytics Lead

    Thanks! This is OBIEE 12.2.1.4 on-prem. but we are looking for some options from weblogic console to see if there is any parameter settings that can limit the SQLs run time. thanks

  • User_27DEY
    User_27DEY Rank 6 - Analytics Lead

    Thanks! SQNET will timeout all the sessions which we donot want that since we have other connections like goldengate etc connect to the DB which run for long time … while we only want to terminate the SQL sessions from BI reports. Also, we donot want to make changes to the codes. just check if its possible some of the parameters settings in weblogic console that can accomplish that. thanks!