Obiee 12c extended subject areas xsa and the data set service. Diagnostics, logging and the obiee 11g em log viewer 31 march 2011 on oracle bi suite ee, technical earlier this week i took a closer look at enterprise manager within obiee 11g, and in particular the mbeans that enterprise manager uses to perform its administration functions. Sometimes we used to define the log level in initialization blocks. I briefly i touched on a few administration tasks such as starting and stopping the obiee components, but in this posting i want to look at this topic in more detail, looking at where all the various files have gone and how you perform basic administration on the system. I shall not miss the vile coreapplication click through folder in the 11g folder structure. Use the oracle business intelligence log viewer utility or a text editor to view the query log. Ive been annoyed at how often i have to go dig through the nqquery logs lately. Examples of log files are 1 presentation services log sawlog. Uploading the repository oracle business intelligence 11g r1.
Presentation services log server log scheduler log javahost log. The diagram above shows obiee application layer architecture. Sep 21, 20 obiee 11g configuration and log files location and scripts location. Obiee 12c environment variables, config files and log file. Diagnosing and resolving issues in oracle business. Obiee 11g configuration and log files location and scripts. When enabled, obiee creates a query log in nqquery. Createmodify metadata repository suiting to data requirements by using obiee administration tool. Logs, for the most part, live under the domains leg of the directory structure. Oct 17, 2018 we can see how obiee is handling xsa under the covers by examining the query log. Open administration tool, file open online manage identity. Ill be putting the source code up soon and will update as appropriate.
Obiee 12c environment variables, config files and log file locations info below are the environment variables needed for obiee 12c. Aug 15, 2010 many administration tasks in 11g are the same as 10g. Here set the log level to 7 in system logging level. Bi tools this location contains scripts to startstopstatus of the server. Obiee 11g log files oracle diagnostic logging odl obiee 10g reporting on multiple subject area advanced logical sql. Apr 10, 20 so many people dont know the log file name and their path. I come from a etl background and have very little knowledge in obiee. In this example here im using an excel worksheet with 140,000 rows and 78 columns. Obiee11g security setup an overview on obiee11g security setup. When using microsoft active directory as the identity store and also using the virtualizetrue option as described in the bi security documentation, the patch for bug 20188679 must be downloaded and applied.
Download rda for your environment platform windowslinuxsolarishpaix from the knowledgebase article remote. Presentation services log server log scheduler log javahost log cluster. Go to business intelligence coreapplications diagnostics log messages 3. What are more fascinating for me are more and more questions around max size and rotation policy of log files which i will cover in subsequent blogs. Go to manageidentityweblogic and set the logging level to 7 here.
Data visualization for oracle business intelligence 11g. Download the obiee 11g versionfrom here or from oracle edelivery site and extract all the four disk into a single folder and click setup. Mar 03, 2012 here set the log level to 7 in system logging level. Deploy rpd manually in obiee 11g 4 years ago shiv bhartis blog. In obiee 11g, we have got enterprise manager console, where we can check log files but we can still see these files in obiee install directory. Since i had to rely on it quite a couple of times, i thought it would be worth sharing it with our readers. On the fly and per analysis an enduser with advanced tab permissions can update variables, logging levels, etc. Welcome as the changes to obiee 12c are, the day after install generated for me. Consolidating onpremise and public cloud data on oracle bi apps. Go to variablessessioninitialization blockslog level.
Sep 09, 2014 download or view obiee 11g server logs from enterprise manager. Otherwise some or all users may be unable to login to oracle business intelligence. For further information on obiee logging refer to the oracle fusion middleware system administrators guide for obiee 11g part number e1054102, chapter eight. Download obiee 11g server logs from enterprise manager. In obiee 10g, we can check the different log files in the installation directory. Obiee 12c extended subject areas xsa and the data set. Diagnostics, logging and the obiee 11g em log viewer. In obiee 11g, all administration and configuration tasks are moved into fusion middleware control also called as enterprise manager. This warning is created in the log file whenever a report is run. Oracle business intelligence enterprise edition 11g documentation is part of oracle fusion middleware online documentation library 11g release 1 11. If the log goes beyond this size obiee will rename it as nqquery. Obiee maintainance mode oracle database databases scribd. The users should be downloaded from the weblogic server.
Obiee 12c environment variables, config files and log file locations. Business intelligence suite enterprise edition version 12. Ill update this page when i find something i consider interesting. Explain the architecture of obiee and what each components do. Altering the banner description text and image in obiee 11g 4 years ago.
Advanced analytics 4 allgemeines 44 architecture 2 bi applications 14 big data 4 case studies 8. Oac csv download limit 2 years ago camerons blog for essbase hackers. Jun 28, 2010 so i decided to write a quick and dirty java program that will pull the physical sql out of the file. Heres some of the main configuration log file locations. Access and configuration of the log files is centralized on the diagnostics tab of the bi coreapplication in the fmw control web interface with the help of odl oracle diagnostic logging is a centralized framework for logging. To define log level open your repository in online mode in oracle bi admin tool, go to manage identity. I believe there are 7 log levels in obiee, this is done at level 5 so no guarantee it will work on anything but 5. It also calls out explicitly total time in bi server which is a welcome addition from a time profilingperformance analysis point of view. Obiee 10g 11g usage trackingut query log obiee odbc. The changes in 12c are not as dramatic as going from obiee 1og to 11g, but the. Yes, i know about session manager and the ability to view logs there. Each entry in the query log is tagged with the name of the user who issued the query, the session id of the session in which the query was initiated, and the request id of the individual query. Obiee 11g configuration and log files location and scripts location. Obiee tutorial a beginner guide by obiee professionals.
Now, in obiee 11g, the users securityidentify store is defined in weblogic server. There are mainly 25 configuration files available in obiee. Parse nqquery log its been quite some time since ive dabbled in java, thankfully jdeveloper makes it pretty easy for me. Obiee 11g log files oracle diagnostic logging odl obiee 10g reporting on multiple subject area advanced logical sql obiee 10g 11g how to see the physical sql generated by a request in presentation service. Obiee 12c file locations and meanings the file locations in obiee12c are very different from previous versions. It is a business intelligence system for the enterprise that delivers abilities for reporting, online analytical processing olap, ad hoc query and analysis dashboards, and scorecards. In obiee 11g if we look at session logs, we will see a new status called dxe execution with amount of time its been executed.
So many people dont know the log file name and their path. Query logging level for user does not work in obiee 12. When you log in, youll see the deployment tab and the repository link. I did some research on this to answer my burning questions what this new alien will do. The oracle application layer or popularly known as the fusion middleware layer is built upon a common domainbased architecture that can support as a set of common core functionality like security, scalability etc across various oracle products. The changes in 12c are not as dramatic as going from obiee 1og to 11g, but the following items were on the short list of things that held my attention before moving on to building repositories and creating dashboards. After warning messages, you can also see all the log files grouped by categories using log viewer. To configure obiee logging, the bi admin client tool is used to set the overall default log level for the rpd as well as identify specific users to be logged. Each message category in a log file for oracle business intelligence is set to a specific default value between 1 and 32, and only messages with a level less than or equal to the log level is. Download obiee 11g server logs from enterprise manager when we face some trouble in obiee 11g, we always search for the log files to find out the cause. Obiee 11g event polling table obiee 11g event pooling table oracle bi server event polling table is used to notify the oracle bi serv. In this post, we are going to see where the log files in obiee 11g reside. To find out, lets download the rpd file, change it and load it back. In a development environment you might consider setting this value to 50kb or even as low as 10kb.
Oct 30, 2015 obiee 12c file locations and meanings the file locations in obiee12c are very different from previous versions. Obiee stands for oracle business intelligence enterprise edition obiee. Feb 29, 2008 by default the maximum size for the nqquery. We can see how obiee is handling xsa under the covers by examining the query log. You might need to show custom image with title, logo of company in header or any such manner where you can show images by just using fmap. While the messages may not indicate a fault with the product as such, the large number of these entries causes problems for. Obiee using the em nqquery log oracle business intelligence. Rda collects the following configuration and log information for obiee 11g. Obiee obia onlineoffline training obiee 11g,obia 7963 contact info. Set the log level at 4 or higher to write this information to the log file. Mar 31, 2011 diagnostics, logging and the obiee 11g em log viewer 31 march 2011 on oracle bi suite ee, technical earlier this week i took a closer look at enterprise manager within obiee 11g, and in particular the mbeans that enterprise manager uses to perform its administration functions.
Once the obiee rpd is designed, i see that obiee starts generating select queries in the background to feed data into the reports. Important configuration files and log files location ive written this short post as just a note to myself quite some time back. Obiee 11g log files and configuration november 20, 20. For more information about logging, see diagnosing and resolving issues in oracle business in oracle fusion middleware system administrators guide for oracle business intelligence enterprise. Diagnosing and resolving issues in oracle business intelligence. Nov 09, 20 after the log fills up, it copies it over to nqquery. In production mode, query logging is typically disabled. Heres some of the main configurationlog file locations. The benefit here is that if one is just running quick tests or looking to identify issues, one need not make changes permanent in the rpd, etc. Obiee 11g log files in this post, we are going to see where the log files in obiee 11g reside.
180 912 293 1173 1005 1036 102 1008 1539 451 477 234 926 1404 521 1011 1578 1343 666 1190 579 1071 690 340 1486 35 1166 658 181 727 792 1304 707 272 602 501 458 247 991