OBIEE 11g has miltiple configuration files and stored redundantly in different location. Changing configurations manually through text editor can be challenging, and admins have to take care that setting are updated and in sync in all the locations. This is even worse if environment is set to be clustered or has redundancy built in.
A better way to manage configuration is through one of the following two tools:
- Fusion Middleware Control - Also called enterprise manager - this is a web based tool that allows OBIEE 11g monitoring and configuration of basic components, like cache, RPD deployment etc. Tool can be accessed using following URL:
http://localhost:7001/em
- Fusion Middleware Control MBean Browser - This is much advanced tool for modifying OBIEE server settings. It internally takes care of multiple instances of config files in diferent directories and redundant servers.
The Mbean Browser can be accessed from within the Fusion Middleware Control, by navigating as below:
Weblogic Domain > bifoundation_domain > AdminServer > Weblogic Server drop down > System Mbean Browser
To start modifying, first step would be to take an exclusive lock on settings by following link:
Application Defined MBean > oracle.biee.admin > Domain:bifoundation_domain > BIDomain > BiDomain > Operations > lock > invoke
After that, admins can make any necessary changes that are required, and hit 'Apply'. After all changes have been applied, it required to select Commit from same screen where lock was acquired. Fortunately we also have rollback option, incase we want to revert at last minute.
OBIEE Answers, Publisher, Installation, Configuration and work around tips. I record all issues and finding in oracle BI, that I can refer back later, or others can use for troubleshooting. I have extensive experience on OBIEE 10g version previously although currently I am on OBIEE 11g
Friday, February 8, 2013
Thursday, February 7, 2013
Unexplained intermittent error in OBIEE UAT server only
We made few RPD changes and code was migrated to UAT server. Intermittently, in UAT, we were getting error on report side:
As a work around, we would clear the cache, delete cookies, close browser completely and try again. This time error was gone. The error kept coming back next day, and we could also recreate the issue just be repeating steps for work around.
I asked admin team to look at it, and we found that this was happening due to clustered environment in UAT. Probably one of the server was still pointing to old RPD.
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 27005] Unresolved column: "Dim - Derivative"."Derivative ID". (HY000)
As a work around, we would clear the cache, delete cookies, close browser completely and try again. This time error was gone. The error kept coming back next day, and we could also recreate the issue just be repeating steps for work around.
I asked admin team to look at it, and we found that this was happening due to clustered environment in UAT. Probably one of the server was still pointing to old RPD.
Labels:
CLUSTERING
Tuesday, February 5, 2013
Timestamp fields in database not showing in SQL Developer
The new GUI for SQL developer from Oracle, does not seem to show "time" value for a timestamp field when doing a select statement. I tried setting options, but did not help. Till I get a real solution, here is a workaround:
select to_char(calendar_date,'DD-MON-YYYY HH24:MI:SS')) from W_Day_D
select to_char(calendar_date,'DD-MON-YYYY HH24:MI:SS')) from W_Day_D
Labels:
TIMESTAMP
Friday, February 1, 2013
OBIEE - How to prevent automatic execution of reports in dashbaord
The ability to disable auto execution of reports is missing in BI. Neither it is not available in OBIEE 10g, nor in OBIEE 11g (up to 11.1.1.6.7 version). Some experts are saying its planned to be available in OBIEE 11.1.1.7 version. Going by number and speed of releases at one release a month, with currently 11.1.1.6.7, we should expect release of 11.1.1.7 within three month, i.e. May 2013.
In the mean time, here are few work around, if this cannot absolutely wait, or you don't plan to upgrade to new version in this time frame:
1. Use Prompts tab in Answers to create a prompt on a field. When this report is run on the dashboard, it will wait for the prompt to be selected, before execution will start. It may be difficult to integrate this with existing dashboard prompts though.
2. Another method is to default dashboard prompt to a dummy value, something like 'Select Month' etc, which will fetch 'No Results' unless users select an actual month. But this makes a prompt to be selected mandatory, and cant be left blank.
3. Last option that I can think of is to create an empty dashboard with just prompts and a basic answers report with out put as text field only. Ask users to select prompt values here, and make available a navigation link to actual dashboard. This way the values can pass either if the prompt has a scope set to "Dashboard", or through "guided navigation", as long as target dashboard has same set of filters.
Good luck.
In the mean time, here are few work around, if this cannot absolutely wait, or you don't plan to upgrade to new version in this time frame:
1. Use Prompts tab in Answers to create a prompt on a field. When this report is run on the dashboard, it will wait for the prompt to be selected, before execution will start. It may be difficult to integrate this with existing dashboard prompts though.
2. Another method is to default dashboard prompt to a dummy value, something like 'Select Month' etc, which will fetch 'No Results' unless users select an actual month. But this makes a prompt to be selected mandatory, and cant be left blank.
3. Last option that I can think of is to create an empty dashboard with just prompts and a basic answers report with out put as text field only. Ask users to select prompt values here, and make available a navigation link to actual dashboard. This way the values can pass either if the prompt has a scope set to "Dashboard", or through "guided navigation", as long as target dashboard has same set of filters.
Good luck.
Labels:
PROMPTS
OBIEE 10g Error from Dashboard layout
We had a requirement where we had hidden two tabs on a dashboard in development. When we requested to migrate dashboard layout to testing environment, we were getting error as below:
Turns out, we are hitting a OBIEE known bug. When administrator logged in, the error went away, but the dashbaord were not hidden like we had expected. There are two work arounds for this:
| Dashboard Display Error | |
Assertion failure: pRoot at line 107 of /net/sdchs20n529/vol1/users/anabuild/views/nightly/Tue/101341/RH_Linux/vobs/090414.1900/analytics_web/main/project/webxml/xmldocument.cpp
Error Details (javascript:void(null))
Error Codes: OQ78YWIW
| |
- Hide the tabs manually in Integration/UAT instead of moving the dashboard layout.
- When moving the layout, try to modify the permissions of dashboard layout object, not sure it will work though.
Labels:
BUGS
Subscribe to:
Posts (Atom)