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!
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
What is wrong with this code
Am I missing something or is there no way to search through previous posts to make sure I don't duplicate a question? All I see on the filter options are tags or status… a general search for a word or phrase would be helpful.
We were under the impression that when exporting a visualization in DV to CSV format hidden columns would be include from the grammar panel. This is not happening. See below for a screenshot showing 3 hidden columns that do not appear when exporting the pivot table to CSV. This seems to have worked a month or so back but…
Migrated RPD from obiee12c to OAS 2024. post migration when we try to access dashboards on OAS we are getting below error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS…
There is no option for legend title in many visualization types.
