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!
Description: The Oracle Fusion Data Intelligence (FDI) Product Roadmap Update provides an overview of the latest developments and future plans for FDI. Oracle Product Management experts will share upcoming capabilities, key enhancements, and product direction, helping attendees understand what is changing and how these…
Hi! I am looking for audit logging for Analytics objects, such as users creating, modifying, or deleting datasets, dataflows, schedules, etc. The traditional Presentation Services component provides such logging in domains/oas/servers/obips1/logs/auditjson.log, which contains audit information for catalog objects,…
I'm trying to index a Local Subject Area so I can use it in my AI Agent, however, I keep receiving the generic error below. Request status(500) : error = {"prefix":"DSS","code":50000,"message":"There was an unexpected error while processing this request. Please try again."}
it is observed that in OAC while using case statements the output is not expected.For example if we have a case statment like case when table1.column1=table2.column1 then 'yes' else 'No' end as Attribute1 Now if i use this attribute with a fact-amount column attribute 1|| Amount on a report then we dont get the aggregation…
Once I select that value from the list box Region I created, I want to filter the table by my selection. See the images
