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 !!
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 .
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.
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.
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
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!
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
Here is my calculation CAST(COUNT(SAAR_ID) AS VARCHAR(50)) || ' SAARs pending as of: ' || CAST(CURRENT_TIMESTAMP(5) AS VARCHAR(50))
In OAC when I am creating a dataset, How can I pass a Filter from the "Dashboard filters to the SQL? I attached a image like it was don in BIP Publisher
How can you put a total number of records in your oracle OAC table footer
we have two seperate environments in air gap… 1- oas 2024 2- oas 2026 developers in both env, required extensions like push button, racing bar, guage…. where to download.
