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
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
Tuesday, February 5, 2013
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
Monday, January 28, 2013
OBIEE 11.1.1.6.7 Patch Set available
The Business Intelligence Enterprise Edition 11.1.1.6.7 patch set has been released and is available to download from My Oracle Support.
Per the patch readme:
11.1.1.6.7 patch set is available for the supported platforms:
Note:
Per the patch readme:
- This patchset is available for all customers who are using Oracle Business Intelligence Enterprise Edition 11.1.1.6.0, 11.1.1.6.1, 11.1.1.6.2, 11.1.1.6.2 BP1, 11.1.1.6.4, 11.1.1.6.5 and 11.1.1.6.6.
- Oracle Exalytics customers may only only install this Oracle Business Intelligence patchset if it is certified for the specific Oracle Exalytics Patch or Patchset Update that they are applying. For more information see Oracle Fusion Middleware Installation and Administration Guide for Oracle Exalytics In-Memory Machine and the Oracle Exalytics In-Memory Machine and System Requirements and Support for Oracle Exalytics 1.x.
- Oracle Fusion Applications customers must not install this Oracle Business Intelligence patch set.
- Patch 15959887 (1 of 7) Oracle Business Intelligence Installer.
- Patch 15959877 (2 of 7) Oracle Real Time Decisions.
- Patch 15929063 (3 of 7) Oracle Business Intelligence Publisher.
- Patch 15959899 (4 of 7) Oracle Business Intelligence ADF Components.
- Patch 15959861 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x.
- Patch 15894670 (6 of 7) Oracle Business Intelligence.
- Patch 15959917 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer.
11.1.1.6.7 patch set is available for the supported platforms:
- Microsoft Windows (32-bit)
- Linux x86 (32-bit)
- Microsoft Windows x64 (64-bit)
- Linux x86-64 (64-bit)
- Oracle Solaris on SPARC (64-bit)
- Oracle Solaris on x86-64 (64-bit)
- IBM AIX PPC (64-bit)
- HPUX- IA (64-bit)
Note:
- The Readme files for the above patches describe the bugs fixed in each patch, and any known bugs with the patch.
- This patch is cumulative, and therefore, contains all of the fixes included in the earlier 11.1.1.6.2, 11.1.1.6.4, 11.1.1.6.5 and 11.1.1.6.6 patch sets.
- However, lists of fixes from included patch sets need to be looked up in the respective patches' readme files, and are not included in the above patches' readme files.
- The instructions to apply the above patches are identical, and are contained in the readme file for patch 15959887.
- Please bear in mind, that the readme states to apply patch 13952743 for JDeveloper, too.
Labels:
PATCHES
OBIEE 11g Patch Set 11.1.1.6.4 (seven total patches)
The most recent patch available for OBIEE 11g so far is 11.1.1.6.4 that was released on 19th September 2012. Patchset comprises of seven patches as below:
The Oracle Business Intelligence 11.1.1.6.4 patchset comprises a number of patches:
This patchset is available for all customers who are using Oracle Business Intelligence Enterprise Edition 11.1.1.6.0, 11.1.1.6.1, 11.1.1.6.2, and 11.1.1.6.2 BP1
Following bugs are fixed in this patch set;
Bugs fixed by each of the patches in the Oracle Business Intelligence 11.1.1.6.4 patchset are described in the Readme file for each patch.
Bugs fixed in this patch (1 of 7) are shown in the following list:
13560245:BIDOMAIN/CONFIG/JDBC NOT FOUND.
13504454:BLK - BIINSTANCE COPYCONFIG FAILURE ESSBASE MAXL LOGIN IS FAILING
13510938:NEED OFFICIAL WAY TO INVOKE _CONFIGURERPD
13628293:EMPTY PROCUREMENT DASHBOARD IN RC4
13565722:BLK: BI T2P PASTECONFIG ERRORED OUT WITH UNABLE TO PARSE JMS_WEBLOGIC_JNDI_URL
13589944:BI T2P - PASTECONFIG INSTANCE IS FAILING WITH JAVA.LANG.UNSATISFIEDLINKERROR
13619973:INCLUDE ESSSERVER HOST NAME IN THE MOVEPLAN
13683204:STRESS:FA:CRM ERROR RESPONSE[NQSERROR: 43082] ILLEGAL OPERATION ATTEMPTED CLOSED
13724975:RUP2 AIX HCM STARTERDB POSTCONFIGURE FAILED
13779029:BI T2P BI RPD PLUGIN OPERATION ERROR WHILE LOADING SHARED LIBRARIES LIBARICU23
13687239:RUP2_RC4 BI DOMAIN - BI ANALYTICS DATASOURCE TEST FAILS
13780076:USE BIPROV PROPERTIES FROM 13694505
13404296:BI PROVISIONING FACADE MUST TRIM RPD IN INSTANCE FOR SELECTED FA OFFERINGS
13485655:T2P ERROR MSG EXECUTING WLST SCRIPT APPEARS DURING BIINSTANCE PASTECONFIG
13896014:RPDTRIM INCORRECT PROPERTY BIPROV.BI-HOME.DIR IN BI-CONTENT.XML FILE
13896152:TRIMRPD NOT ABLE TO CREATE BIPROJECTS.TXT BASED ON FAOFFERING LIST BAD XPATH ERR
13896209:TRIMRPD RELATIVE BI ORACLE HOME LOCATION PASSED TO SCRIPTS DURING RPDTRIM
13898786:TRIMRPD PLEASE MASK THE RPD PASSWORD WHICH IS LOGGED DURING _TRIMRPDTARGET EXEC
13910554:MISSING CONNECTION PROPERTIES IN OBIEE RPD
13926479:TRIMRPD FOR WINDOWS THE PROPS FILE SHOULD INCLUDE FORWARD SLASH IN DIR PATHS
Unfortunately, this patchset has bugs of its own. Following three are known so far:
14228519 ADMINTOOL CLIENT MISSING ALL FILES UNDER EXTENDER DIRECTORY IN CLIENT INSTALLER
14244844 NAVIGATE TO URL ACTIONS BASED ON ENCODED URLS MAY RESULT IN DOUBLE ENCODING
14636489 11.1.1.6.4 ADMINTOOL CLIENT INSTALLER DIALOG TITLE IS SHOWN AS "11.1.1.6.2"
The Oracle Business Intelligence 11.1.1.6.4 patchset comprises a number of patches:
| Patch | Abstract |
|---|---|
| 14538078 | Patch 11.1.1.6.4 (1 of 7) Oracle Business Intelligence Installer |
| 14538128 | Patch 11.1.1.6.4 (2 of 7) Oracle Real Time Decisions |
| 14285344 | Patch 11.1.1.6.4 (3 of 7) Oracle Business Intelligence Publisher |
| 14538164 | Patch 11.1.1.6.4 (4 of 7) Oracle Business Intelligence ADF Components |
| 14415773 | Patch 11.1.1.6.4 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x |
| 14405222 | Patch 11.1.1.6.4 (6 of 7) Oracle Business Intelligence |
| 14409674 | Patch 11.1.1.6.4 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer |
This patchset is available for all customers who are using Oracle Business Intelligence Enterprise Edition 11.1.1.6.0, 11.1.1.6.1, 11.1.1.6.2, and 11.1.1.6.2 BP1
Following bugs are fixed in this patch set;
Bugs fixed by each of the patches in the Oracle Business Intelligence 11.1.1.6.4 patchset are described in the Readme file for each patch.
Bugs fixed in this patch (1 of 7) are shown in the following list:
13560245:BIDOMAIN/CONFIG/JDBC NOT FOUND.
13504454:BLK - BIINSTANCE COPYCONFIG FAILURE ESSBASE MAXL LOGIN IS FAILING
13510938:NEED OFFICIAL WAY TO INVOKE _CONFIGURERPD
13628293:EMPTY PROCUREMENT DASHBOARD IN RC4
13565722:BLK: BI T2P PASTECONFIG ERRORED OUT WITH UNABLE TO PARSE JMS_WEBLOGIC_JNDI_URL
13589944:BI T2P - PASTECONFIG INSTANCE IS FAILING WITH JAVA.LANG.UNSATISFIEDLINKERROR
13619973:INCLUDE ESSSERVER HOST NAME IN THE MOVEPLAN
13683204:STRESS:FA:CRM ERROR RESPONSE[NQSERROR: 43082] ILLEGAL OPERATION ATTEMPTED CLOSED
13724975:RUP2 AIX HCM STARTERDB POSTCONFIGURE FAILED
13779029:BI T2P BI RPD PLUGIN OPERATION ERROR WHILE LOADING SHARED LIBRARIES LIBARICU23
13687239:RUP2_RC4 BI DOMAIN - BI ANALYTICS DATASOURCE TEST FAILS
13780076:USE BIPROV PROPERTIES FROM 13694505
13404296:BI PROVISIONING FACADE MUST TRIM RPD IN INSTANCE FOR SELECTED FA OFFERINGS
13485655:T2P ERROR MSG EXECUTING WLST SCRIPT APPEARS DURING BIINSTANCE PASTECONFIG
13896014:RPDTRIM INCORRECT PROPERTY BIPROV.BI-HOME.DIR IN BI-CONTENT.XML FILE
13896152:TRIMRPD NOT ABLE TO CREATE BIPROJECTS.TXT BASED ON FAOFFERING LIST BAD XPATH ERR
13896209:TRIMRPD RELATIVE BI ORACLE HOME LOCATION PASSED TO SCRIPTS DURING RPDTRIM
13898786:TRIMRPD PLEASE MASK THE RPD PASSWORD WHICH IS LOGGED DURING _TRIMRPDTARGET EXEC
13910554:MISSING CONNECTION PROPERTIES IN OBIEE RPD
13926479:TRIMRPD FOR WINDOWS THE PROPS FILE SHOULD INCLUDE FORWARD SLASH IN DIR PATHS
Unfortunately, this patchset has bugs of its own. Following three are known so far:
14228519 ADMINTOOL CLIENT MISSING ALL FILES UNDER EXTENDER DIRECTORY IN CLIENT INSTALLER
14244844 NAVIGATE TO URL ACTIONS BASED ON ENCODED URLS MAY RESULT IN DOUBLE ENCODING
14636489 11.1.1.6.4 ADMINTOOL CLIENT INSTALLER DIALOG TITLE IS SHOWN AS "11.1.1.6.2"
Labels:
PATCHES
Subscribe to:
Posts (Atom)