Oracle® Fusion Middleware Release Notes 11g Release 1 (11.1.1) for AIX Based Systems (64-Bit) E14771-11 |
|
![]() Previous |
![]() Next |
This chapter describes issues associated with Oracle Business Intelligence Discoverer. It includes the following topics:
Section 33.2, "Issues Specific to Oracle BI Discoverer Plus Relational"
Section 33.3, "Issues Specific to Oracle BI Discoverer Plus OLAP"
Section 33.4, "Issues Specific to Oracle BI Discoverer Portlet Provider"
Section 33.5, "Issues Specific to Oracle BI Discoverer Viewer"
Section 33.6, "Issues Specific to Oracle BI Discoverer EUL Command Line for Java"
Section 33.7, "Issues Specific to Oracle BI Discoverer Administrator"
This section describes general issues that affect more than one Discoverer component. It includes the following topics:
Section 33.1.1, "Issues with Metadata Repository and Oracle Database 10g Release 1"
Section 33.1.2, "Compatibility Issues with Required Support Files"
Section 33.1.4, "Additional Fonts Required for Non-ASCII Data When Exporting to PDF"
Section 33.1.5, "Query Prediction Requires the Majority of the Query Time"
Section 33.1.8, "Issues with Mac OS X Browser and Oracle BI Discoverer Plus"
Section 33.1.10, "Multibyte Characters Rendered as Square Boxes in Exported PDF and Other Formats"
Section 33.1.11, "Java Plug-in Not Downloaded Automatically on Firefox"
Section 33.1.12, "HTTP 404 Error While Accessing Discoverer on a Remote Machine"
Section 33.1.13, "Error While Launching Discoverer Plus Applet on an IPv6 Environment"
Section 33.1.14, "Error While Updating the Discoverer Web Services Configuration Parameter"
Section 33.1.15, "Exception Logged for Discoverer Web-Based Applications in an Extended Domain"
When using Oracle Database 10g Release 1 (10.1.x) for the Metadata Repository or after upgrading the Metadata Repository to Oracle Database 10g Release 1, you might see the following error on the Oracle BI Discoverer Plus Connection pages, the Oracle BI Discoverer Viewer Connection pages, and the Public Connection definition page in Fusion Middleware Control:
The connection list is currently unavailable. ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "ORASSO.WWSSO_API_PRIVATE," line 258 ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "ORASSO.WWSSO_UTL" line 728 ORA-28231: no data passed to obfuscation toolkit ORA-06512: at line 1 Unable to retrieve connection list
To resolve this issue, make the following changes in the Metadata Repository database:
Edit the init%ORACLE_SID%.ora
file. This file exists either in the dbs
folder or the database
folder. For example, in Windows, this file is located in the DB_install_home/database/ folder.
Add the following line to this file:
event="10946 trace name context forever, level 36"
If an spfile%ORACLE_SID%.ora
exists in either the dbs
folder or the database
folder, rename the file to spfile%ORACLE_SID%.bak
. Changes to init%ORACLE_SID%.ora
are not loaded if the database server finds an spfile
.
Log in as a sysadmin
.
At the SQL prompt, shut down then start up the database server.
Restart the Oracle BI Discoverer server using the command opmnctl restartall
.
The Oracle Database and other Oracle database client software (for example, SQL*Plus, the database export utility) use Oracle Required Support Files (RSF).
Oracle BI Discoverer also uses Oracle Required Support Files (RSF), specifically RSF version 11.1.0.7. This version of the Oracle Required Support Files is installed during Oracle BI Discoverer installation.
Note that the Required Support Files version 11.1.0.7 is incompatible with earlier versions of Oracle Database 10g. So if the machine on which you install Oracle BI Discoverer already has a version of Oracle Database 10g or database client software that is earlier than 11.1.0.7, there will be compatibility issues. For example, if you install Oracle BI Discoverer and attempt to run a version of SQL*Plus earlier than 11.1.0.7, then the following error is displayed:
ORA-12557 TNS: protocol adapter not loadable
To avoid the compatibility issues, upgrade Oracle Database 10g or database client software on the machine to the same version (11.1.0.7) as the version of the Required Support Files that were installed with Oracle BI Discoverer.
This issue does not exist for Oracle9i Database Server.
You might notice unsightly font issues when using a non-English locale such as Czech. For example, when a worksheet uses a serif font, text in that worksheet might be displayed incorrectly on the screen and in printouts.
To work around this issue, update the file that maps the serif fonts. The name of this file differs depending on the locale in use. When you use Oracle BI Discoverer Plus Relational or Plus OLAP in English, the file is named file.properties
. If you use Oracle BI Discoverer in a non-English locale, then the file name includes the code for the locale, such as file.properties.cs
for Czech.
Update the mapping file with the following information:
serif.0=Times New Roman,EASTEUROPE_CHARSET serif.1=WingDings,SYMBOL_CHARSET,NEED_CONVERTED serif.2=Symbol,SYMBOL_CHARSET,NEED_CONVERTED
Consult the following Sun Web site for additional information about fonts:
http://java.sun.com/j2se/1.3/docs/guide/intl/addingfonts.html
If you are running Oracle BI Discoverer Plus Relational or Plus OLAP on a Macintosh or Linux client machine, you must add the appropriate font files to your client machine to allow exported PDF files to display non-ASCII data correctly.
These font files include Albany fonts with names such as ALBANWTJ.TTF
and ALBANWTK.TTF
. The files are stored in the /utilities/fonts
directory on the CD-ROM or DVD for the Oracle Application Server Metadata Repository Upgrade Assistant.
To install the additional required fonts:
Navigate to the /utilities/fonts
directory on the CD-ROM or DVD for the OracleAS Metadata Repository Upgrade Assistant.
Copy the appropriate Albany TTF file from the /utilities/fonts
directory to the plug-in directory in the $jdk
/jre/lib/fonts
directory on the Macintosh or Linux client machine.
When using Oracle BI Discoverer with a relational data source, you can predict the time that is required to retrieve information by setting the value of the QPPEnable preference to 1. However, in some circumstances, the majority of the time taken to retrieve information is consumed by the prediction activity itself.
To work around this issue, set the value of the QPPObtainCostMethod
preference to 0
(use the EXPLAIN PLAN
statement to predict query times) rather than to 1
(use dynamic views to predict query times).
For more information about setting preferences, see the Oracle Fusion Middleware Configuration Guide for Oracle Business Intelligence Discoverer.
To use word wrap settings correctly, you must understand how they are designed for Oracle BI Discoverer:
Oracle BI Discoverer Plus: Word wrap settings that you make in Oracle BI Discoverer Plus are saved in the worksheet and affect the display of worksheets in Oracle BI Discoverer Plus and when printing to PDF.
Oracle BI Discoverer Viewer: Word wrap settings that you see in the Print Settings dialog work as follows:
The word wrap settings do not affect the display of worksheets in Oracle BI Discoverer Viewer.
For relational data:
The word wrap settings do affect the printing of worksheets to PDF.
If the Always wrap text when size exceeds column width box is checked, then the print settings in Oracle BI Discoverer Viewer do override the settings made in a worksheet in Oracle BI Discoverer Plus Relational for printing to PDF.
If the Always wrap text when size exceeds column width box is not checked, then the print settings in Oracle BI Discoverer Viewer do not override the settings made in a worksheet in Oracle BI Discoverer Plus Relational for printing to PDF.
For OLAP data:
The word wrap settings do not affect the printing of worksheets to PDF.
Regardless of whether the Always wrap text when size exceeds column width check box is selected, the print settings in Oracle BI Discoverer Viewer never override the settings made in a worksheet in Oracle BI Discoverer Plus OLAP for printing to PDF.
When you use Microsoft Internet Explorer, the Oracle BI Discoverer Plus Relational or Plus OLAP applet initialization and download dialog appears behind the browser window from which it was launched. After the applet is downloaded and initialized, it appears in front of the browser window from which it was launched.
To work around this issue:
Use a browser other than Internet Explorer, such as Netscape Navigator or Mozilla Firefox.
Use the Oracle BI Discoverer Plus URL parameter _plus_popup=false
, which is documented in the Oracle Fusion Middleware Configuration Guide for Oracle Business Intelligence Discoverer.
The following are issues that you might encounter when you use the Safari browser on Mac OS X with Oracle BI Discoverer Plus Relational or Plus OLAP:
If you resize the browser window in the applet, then some parts of the content might be clipped. To work around this problem, always maximize the browser window for the applet when working with Mac OS X.
Keyboard combinations (also known as mnemonics) do not work in Oracle BI Discoverer Plus Relational and Plus OLAP.
For example, you cannot press Alt+F to access the File
menu.
In the Share Workbooks dialog of Oracle BI Discoverer Plus Relational, the leading characters of the "Shared:" list are clipped. In other words, the left edge of the list is truncated. For example, if you shared a workbook with DISCODEV
, then you will only see SCODEV
in the list. The title for the list is also truncated such that you see only the vertical line of the "d" in "Shared" and the colon (that is, "l:").
The dialog continues to work as expected, but you might have difficulty reading the names in the "Shared:" list.
This issue has no workaround.
Because of Sun JRE 1.4 bug 4688797, you might encounter issues when connecting to a database schema from a computer that has Turkish regional settings. You will encounter the issue when you attempt to connect to a database schema with a user name that contains certain letters, such as the letter 'I' or 'i', for example, in "bibdemo". See the Sun JRE bug for information on the letters that are affected.
To work around this issue, either do not use Turkish regional settings or use a user name that does not contain the affected letters.
When you export a workbook to PDF and other formats, multibyte characters (for example, Korean, Japanese, and Chinese characters) appear as square boxes.
To work around this issue, copy the following Albany fonts from ORACLE_HOME
/jdk/jre/lib/fonts
to the fonts
folder of your JDK (Oracle JRockit or Sun) within the MW_HOME
directory. For example, if you are using IBM JDK, you must copy the fonts to MW_HOME
/jre/jdk160_11/lib/fonts
.
AlbanWTJ.ttf
AlbanWTK.ttf
AlbanWTS.ttf
AlbanWTT.ttf
ALBANYWT.ttf
When you attempt to connect to Discoverer Plus by using the Mozilla Firefox browser on a machine that does not have Java 1.6 installed, the browser does not download the JRE 1.6 plug-in automatically. Instead, the browser displays the following message:
Additional plugins are required to display this page...
You must download the JRE 1.6 plug-in (by clicking the Install Missing Plugin link) and install it manually.
When you attempt to connect to Discoverer Plus, occasionally, the browser returns an HTTP 404 (File Not Found) error.
The page loads correctly when you refresh the browser a few times.
If the Web tier is on an IPv6 machine, when you start Discoverer Plus, the following error message might be displayed:
Attempt1. RMI protocol over JRMP transport: Connection refused to host: DiscoServerMahcineName;nested exception is: @ java.net.ConnectionException: Connection timed out
To work around this issue, in the System MBean Browser of Fusion Middleware Control, change the TransportProtocols attribute of the Plus Config MBean to "jrmp,http" (or "jrmp,https" if Discoverer Plus is accessed by using secure HTTP).
When you update the web services configuration parameter (Maximum Sessions) using the Discoverer Web Services Configuration page of Fusion Middleware Control and click Apply, the following error message is displayed:
Applying changes - Failed. Exception caught:
You can ignore the error message because the changes are applied even if the exception is thrown. Alternatively, you can update the MaxSessions attribute of the WebServicesConfig MBean in the System MBean Browser of Fusion Middleware Control.
When you extend a domain and add Discoverer application in a remote machine, you may see the following exception in the WebLogic Server log:
java.lang.IllegalArgumentException: ODL-52057: The handler 'disco-server-handler' is not defined.
To work around this issue, modify the log_handlers and loggers elements in the logging.xml file located in the DOMAIN_HOME
/config/fmwconfig/servers/
WLS_DISCO
folder of the machine where the domain exists.
In the log_handlers section, add the handlers as follows:
<log_handler name='discoverer-handler' class='oracle.core.ojdl.logging.ODLHandlerFactory'> <property name='path' value='${domain.home}/servers/${weblogic.Name}/logs/discoverer/diagnostic.log' /> <property name='maxFileSize' value='1048576'/> <property name='maxLogSize' value='10485760'/> <property name='format' value='ODL-Text'/> <property name='useSourceClassAndMethod' value='false'/> </log_handler> <log_handler name='disco-server-handler' class='oracle.core.ojdl.logging.ODLHandlerFactory'> <property name='path' value='${domain.home}/servers/${weblogic.Name}/logs/discoverer/server/diagnost ic.log'/> <property name='maxFileSize' value='1048576'/> <property name='maxLogSize' value='10485760'/> <property name='format' value='ODL-Text'/> </log_handler>
In the loggers sections, add the following elements:
<logger name='ORACLE.DISCOVERER.VIEWER' level='TRACE:32' useParentHandlers='false'> <handler name='discoverer-handler'/> <handler name='odl-handler'/> </logger> <logger name='ORACLE.DISCOVERER.PORTLET_PROVIDER' level='TRACE:32' useParentHandlers='false'> <handler name='discoverer-handler'/> <handler name='odl-handler'/> </logger> <logger name='ORACLE.DISCOVERER.MODEL' level='TRACE:32' useParentHandlers='false'> <handler name='discoverer-handler'/> <handler name='odl-handler'/> </logger> <logger name='ORACLE.DISCOVERER.WEB_SERVICES' level='TRACE:32' useParentHandlers='false'> <handler name='discoverer-handler'/> <handler name='odl-handler'/> </logger> <logger name='ORACLE.DISCOVERER.SERVER' level='TRACE:32' useParentHandlers='false'> <handler name='disco-server-handler'/> <handler name='odl-handler'/> </logger>
After adding these elements, save the logging.xml file, and restart the Administration Server and Discoverer Managed Servers.
When you recover the Oracle BI Discoverer middle tier from a backup, the Discoverer application URL in the Discoverer Home page of Fusion Middleware Control point to a wrong location.
You must configure the application URLs that appear on the Oracle BI Discoverer Home page in Fusion Middleware Control after recovering the Oracle BI Discoverer middle tier from a backup.
For more information, see "How to configure application URLs displayed on the Fusion Middleware Control Discoverer Home page" in the Oracle Business Intelligence Discoverer Configuration Guide.
This section describes issues that are specific to Oracle BI Discoverer Plus Relational. It includes the following topics:
Section 33.2.2, "Non-ASCII Characters Not Saved Correctly in Title or Text Area"
Section 33.2.4, "Nonaggregable Values Not Displayed for Scheduled Workbooks"
When you run Oracle BI Discoverer Plus Relational with Sun Java Plug-in 1.4.2_06, the Browser Look and Feel, and an Asian language (such as Korean or Chinese), you might notice that static text and text in buttons in the user interface appears truncated or clipped. To work around this issue, do one of the following:
Change the Look and Feel to either Plastic or System.
Use JInitiator 1.3.1.17 instead of the Sun Java Plug-in.
Install Sun Java Plug-in version 1.4.2_10 or higher.
When you save a new workbook in Oracle BI Discoverer Plus, any text characters beyond the standard ASCII characters are not saved correctly when all the conditions that are described in the following list are met:
You are logged in as an Oracle e-Business Suite user.
The language for the computer is not English.
Oracle BI Discoverer Plus is running against an Oracle e-Business Suite database that does not have that non-English language installed.
This issue has no workaround.
If you cancel a query that is running in Oracle BI Discoverer Plus Relational, then you are prompted to either choose YES to undo the changes or NO to show a blank sheet. If you choose YES, then Oracle BI Discoverer Plus Relational hangs and you must close the window and restart.
To work around this issue, choose NO to show a blank worksheet. You can then refresh the sheet and continue working.
Oracle BI Discoverer Plus Relational does not display nonaggregable values for scheduled workbooks. In other words, Oracle BI Discoverer Plus Relational processes scheduled workbooks as if you selected the Show values that cannot be aggregated as: <Non-aggregable label> option in the Worksheet Properties dialog: Aggregation tab.
Nonaggregable values include those based on the following SQL functions:
A CASE
SQL statement
A DECODE
SQL statement
A PL/SQL function
A DISTINCT
SQL statement
An analytic function
If you use Oracle BI Discoverer Plus Relational to open a worksheet that was created using Oracle BI Discoverer Desktop Version 9.0.4 (or earlier), the size of the title area for that worksheet defaults to two lines in height. A title height of two lines might be a problem if a worksheet title requires more than or less than two lines. If you want to change the size of the title area, you must resize the title area manually and save the worksheet.
To resize the title area for a worksheet, open the worksheet and drag the bar at the bottom of the title area pane up or down.
This section describes issues that are specific to Oracle BI Discoverer Plus OLAP. It includes the following topics:
Section 33.3.5, "Link Tool Works Incorrectly in Some Locales"
Section 33.3.6, "Memory Issues when Exporting Extremely Large Graphs"
Section 33.3.7, "Issue While Printing Worksheets with Large Data Values"
There may be Oracle Business Intelligence Discoverer Plus applet download issues when caching has been enabled in the Sun Java Plug-In.
To avoid these issues, disable caching in the plug-in.
When you are running Netscape 7.x or Mozilla browsers, the Netscape and Mozilla Mail clients and Web browser may become disabled when Oracle BI Discoverer Plus OLAP modal dialogs are displayed.
Dismissing the Oracle BI Discoverer Plus OLAP dialogs resumes normal operation for the Netscape and Mozilla tools.
When you use the Tab
key to select items in a worksheet, the menus do not always synchronize to reflect the currently selected item.
This issue has no workaround.
The Esc
key does not close the following dialogs: Totals, New Total, Parameter, and Manage Catalog.
Instead of using the Esc key, click the Close or OK button.
The Link tool, which enables users to drill out to external URLs from a crosstab cell, might not work correctly in all locales due to URL encoding issues.
This issue has no workaround.
Exporting extremely large graphs can cause memory issues, requiring a restart of the Oracle BI Discoverer Plus OLAP session.
This issue has no workaround.
When printing a worksheet that contains large numbers in the data cells, the string ####### may be printed instead of the actual numbers.
This issue has no workaround.
The following issues exist with titles and text areas:
Nonempty titles and text areas are printed even if they are hidden in the worksheet.
This issue has no workaround.
When you set the title or text area background to green and export the worksheet to an HTML file, the background is incorrectly set to red in the exported file.
This issue has no workaround.
When you use JAWS, you will notice errors when you attempt to format graphs and crosstabs using the Format dialogs.
This issue has no workaround.
This section describes issues that are specific to Oracle BI Discoverer Portlet Provider. It includes the following topics:
Section 33.4.1, "Inability to Turn Off Display of Range Min and Max as Labels"
Section 33.4.3, "Issues with Discoverer Portlets in WebCenter"
Section 33.4.5, "Issue with Portlet Titles in Discoverer WSRP Portlets Published on IBM WebSphere"
Section 33.4.6, "Issue with Color and Date Pickers in Discoverer WSRP Portlets"
Section 33.4.8, "Issue with Worksheet Parameter LOV Pop-Up Window in Discoverer WSRP Portlets"
In the Display Options of a gauge portlet, the Minimum Value and Maximum Value range labels are selected but are also disabled so that you cannot deselect the display of those values. The values for the minimum and the maximum appear at the ends of every gauge in the set except for those gauges where the value to be gauged is out of the range of the minimum and the maximum values. For those gauges where the value to be displayed exceeds the range of the minimum and the maximum values, the gauge will automatically adjust to accommodate the value.
This issue has no workaround.
If you configure Oracle BI Discoverer Portlet Provider to work with Oracle Single Sign-On and SSL, then UIX images might not display correctly in Oracle BI Discoverer. For example, on the Connect to OracleBI Discoverer page, the expand icon (that is, the blue + symbol) in the Details column of the Discoverer connections list might not display correctly.
To address this issue, you must add certain server startup properties.
Start Enterprise Manager Fusion Middleware Control. For more information, see "Managing and Configuring Discoverer" in Oracle Fusion Middleware Configuration Guide for Oracle Business Intelligence Discoverer.
Navigate to the WebLogic Server node (for example, WLS_DISCO) node, and click the WebLogic Server Administration Console link.
Select the Server Start tab on the Configurations page of the WebLogic Server Administration Console.
In the Arguments field, append the following lines, if they do not exist.
-Doracle.discoverer.applications.protocol=https
-Doracle.discoverer.applications.port=
port_no
Set port_no
to the HTTPS port number that you want to use (for example, 4443).
Restart the server.
The following issues exist for Discoverer portlets displayed in Oracle WebCenter.
When a Worksheet portlet is displayed in Oracle WebCenter, the links to navigate to the next set of records does not work.
When a List of Worksheets portlet is displayed in Oracle WebCenter, the Expand All Icons link does not work.
To work around these issues, set the RenderPortletInIFrame
attribute of the portlet tag to TRUE
. For more information, see "Setting Attribute Values for the Portlet Tag" in Oracle Fusion Middleware Developer's Guide for Oracle WebCenter.
When you publish Discoverer WSRP Portlets in portals other than Oracle Portal and Oracle WebCenter (such as Oracle WebLogic Portal and IBM WebSphere Portal), the pop-up windows for input selection will have the same page layout as the portal page with all navigation options. If you select any of these navigation options, the current portlet state will be lost. You might need to start publishing the portlet from the beginnng.
The issue has no workaround.
You cannot dynamically change the portlet title of a Discoverer WSRP portlet in IBM WebSphere after it is published. Static title is rendered in the portal for each portlet instance.
To work around this issue, set a meaningful title for the portlet by editing the title using the Set Title or Description option in the WebSphere portal. For more information about changing the title of a portlet, see WebSphere documentation.
The Color and Date pickers in Discoverer WSRP Portlets do not work on portals other than Oracle WebCenter.
On portals such as Oracle Portal, Oracle WebLogic Portal and IBM WebSphere, to workaround this issue, set the value of the configuration parameter useInlineUIXPicker
to true. The default value of this parameter is false. When you set the useInlineUIXPicker
parameter to true, set the color and date as follows:
Inline color pickers are enabled in the Gauges Selection page and you can select a color from the palette.
You cannot select the color using the Format option of the Personalize menu of the worksheet. Use the Analyze option in the portlet window to change the color.
The Date picker in the Refresh option will not be available. Enter the date manually.
The Worksheet Parameter LOV icon is not displayed when you publish Discoverer WSRP portlets in IBM WebSphere portal.To work around this issue, enter parameter values manually.
In Oracle Portal and Oracle WebLogic Portal, when you select values from the parameter LOV from a worksheet portlet published by using the Discoverer WSRP Portlet producer, the pop-up window is not getting closed on selection of values.You must explicitly close the pop-up window after selection of values.
This section describes issues that are specific to Oracle BI Discoverer Viewer. It includes the following topics:
Section 33.5.1, "Drill Icons Cannot Be Hidden in Oracle BI Discoverer Viewer"
Section 33.5.2, "Error Displaying Page for Multiple SSO Users"
Section 33.5.3, "Inability to Disable the Display of Row Numbers"
Section 33.5.4, "Issues with Oracle BI Discoverer Viewer Embedded in Frames"
Section 33.5.5, "Issue Exporting to PDF Under Certain Circumstances"
Section 33.5.7, "Discoverer Catalog Items Not Visible From UNIX Servers"
Section 33.5.8, "Known Bug with JAWS Prevents Drilling Using the Enter Key"
Section 33.5.9, "JAWS Does Not Read Asterisks that Precede Fields"
Section 33.5.10, "Oracle BI Discoverer Viewer Pages are not Cached by Oracle Web Cache"
The pref.txt
file contains a setting called ShowDrillIcon
, which is not functioning properly. If you set ShowDrillIcon
to False
, then drill icons are still displayed in Oracle BI Discoverer Viewer.
The issue has no workaround.
When an Oracle Single Sign-On (SSO) user tries to view a worksheet from a List of Worksheets Portlet by using the same browser window that is already being used by an SSO user to view that worksheet, the second user sees the following error message: "The page cannot be displayed
".
To work around this issue, start a new browser session and view the worksheet.
Oracle BI Discoverer Viewer no longer offers the ability to disable the display of row numbers in a tabular worksheet.
Users might see JavaScript errors such as "Access Denied
" or other unexpected behavior when both of the following conditions are met:
When Oracle BI Discoverer Viewer is embedded in an IFRAME tag.
When the domain of the server that hosts the HTML page with the IFRAME tag is different from the domain of the Oracle BI Discoverer server that is running Oracle BI Discoverer Viewer.
Use one of the following workarounds for this issue:
Run the Oracle BI Discoverer server and the server that hosts the HTML page with the IFRAME tag in the same domain.
Alter the Common2_2_20.js
file on the Oracle BI Discoverer server using the following steps:
Use Fusion Middleware Control to stop all services on the middle tier for Oracle Business Intelligence.
Make a backup copy of the Common2_2_20.js
file from the following directory:
domain
\servers\
managed_server
\stage\discoverer\
release
\discoverer\discoverer.war\cabo\jsLib
domain
is the path of directory that contains the domain.
managed_server
is the name of the managed server on which the Discoverer application is deployed.
release
is the release number of Discoverer. For example, 11.1.1.1.0
.
Edit the Common2_2_20.js
file and replace all occurrences of "parent._pprSomeAction" with "window._pprSomeAction".
Use Fusion Middleware Control to start all services on the middle tier for Oracle Business Intelligence.
Clear the browser cache on the client machine so that the new Common2_2_20.js
file will be used.
If you are using Oracle BI Discoverer Viewer with Microsoft Internet Explorer, you might encounter an error message when you try to export to PDF a worksheet that is named with non-ASCII characters, a space, and a number. The export fails and you will see a message similar to the following one:
No %PDF- in a file header
Use one of the following methods to work around this issue:
Use a browser other than Internet Explorer, such as one from Netscape or Mozilla.
Remove the space between the non-ASCII characters and the number, or remove the number altogether.
Continue to use Internet Explorer and leave the space in the worksheet name, but follow these steps:
Start the Adobe Reader.
From the Edit menu, choose Preferences, then click Internet.
Clear the Display PDF in browser box.
You can use Fusion Middleware Control to change the look and feel of Oracle BI Discoverer Viewer. That page contains a color chooser, or palette. If you use Fusion Middleware Control on Mac OS X with the Safari browser, then the page does not correctly enter the color code when you select a color from the palette.
To work around this issue, you can either use the Firefox browser or you can enter a color code directly.
The color codes are standard HTML hexadecimal color codes. You can enter one of the 49 colors that are available in the color palette, or you can enter any valid HTML hexadecimal color code.
The following list provides examples of colors with their codes:
You might encounter issues when trying to see items in the Discoverer Catalog when using Oracle BI Discoverer Viewer with OLAP data on UNIX servers.
You can resolve this issue on the middle-tier machine where Oracle BI Discoverer runs by performing the following steps.
To check whether the time zone variable is set:
Open a shell prompt.
Type echo $TZ
to display the time zone setting.
If no value is displayed, then the time zone has not been set.
To set the time zone variable:
Open a shell prompt.
Note: The UNIX user that sets the TZ variable must be the same UNIX user that installed Oracle Business Intelligence. |
If you do not know which shell you are using, type $echo $SHELL
to display the name of the current shell.
Set the time zone as appropriate.
For example, to set the time zone variable for US/Pacific time:
For the Bourne, Bash, or Korn shell, type export TZ=US/Pacific
For the C shell, type setenv TZ US/Pacific
Note: Consult the shell documentation for the appropriate values. |
Oracle BI Discoverer can be used in conjunction with assistive technologies such as the JAWS screen reader. However, a bug in JAWS prevents the drilling feature from working correctly in Oracle BI Discoverer Viewer when querying a relational data source.
Assume that you use the keyboard to navigate to the drill icon beside an item in the worksheet header. When you press the Enter
key to drill on that header item, the Drill page should be displayed as described in the "Worksheet Display page: (Page level tools and controls)" topic in the Help system and the Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Discoverer Viewer).
However, when JAWS is running, the Drill page is not displayed. Instead, the Drill popup menu is displayed. It is not possible to select items from this popup menu by using the keyboard, and JAWS does not read the items on the popup menu.
This issue has no workaround.
In Oracle BI Discoverer Viewer, an asterisk that precedes a text field indicates that the user is required to enter a value into that text field. The JAWS screen reader does not read an asterisk that precedes a required text field and does not otherwise indicate that the field is required.
This issue has no workaround.
When using Oracle BI Discoverer with Oracle Web Cache, note the following:
When Oracle Single Sign-On is enabled, Oracle Web Cache does not cache Oracle BI Discoverer Viewer pages, regardless of whether they are accessed using a public connection or a private connection.
If an Oracle BI Discoverer Viewer page is accessed directly through a URL and the URL contains URL parameters that specify login details (for example, user name, database name), then Oracle Web Cache does not cache the page. For example, Oracle Web Cache does not cache worksheet "Sheet 1" in workbook "Workbook 2" that is displayed by using the following URL:
http://<host.domain>:<port>/discoverer/viewer?us=video5&db=db1&eul=VIDEO5&wbk=Workbook+2&ws=Sheet+1
Note: In the example above,us= specifies the database user name, and db= specifies the database name. |
However, Oracle Web Cache does cache worksheet "Sheet 1" in workbook "Workbook 2" if a user logs in manually to Oracle BI Discoverer Viewer by using the same login details, and navigates to the worksheet.
You must increase the delays for Oracle BI Discoverer Viewer by at least 60 seconds for Oracle BI Discoverer Viewer to properly cache workbooks with Oracle Web Cache.
For more information, see "How to configure Discoverer Viewer to enable maximum caching" in the Oracle Fusion Middleware Configuration Guide for Oracle Business Intelligence Discoverer.
This section describes issues that are specific to Oracle BI Discoverer EUL Command Line for Java. It includes the following topics:
When you export multibyte or Eastern European data (such as the names of items and business areas in Japanese or Russian characters) from Oracle BI Discoverer EUL Command Line for Java on a platform other than Windows, the exported data is corrupted.
To work around this issue, edit the discwb.sh
file that is located in the ORACLE_HOME/discoverer
directory before exporting. Change the character set value in the NLS_LANG variable to UTF8.
For example, if the original setting of the variable is:
NLS_LANG="GERMAN_GERMANY.WE8ISO8859P1"
Change the setting to:
NLS_LANG="GERMAN_GERMANY.UTF8"
When you use the java -jar eulbuilder.jar -connect
command to connect to an EUL, the JVM crashes if the NLS_LANG environment variable is not initialized.
This problem does not occur when you connect by using the eulapi.sh
command.
To work around this issue, set the NLS_LANG environment variable to AMERICAN_AMERICA.UTF8
.
The eulapi
command does not run properly because of incorrect ORACLE_HOME
location in the script.
To work around this issue, you must manually set the environment variable ORACLE_HOME
before running the eulapi utility.
This section describes issues that are specific to Oracle BI Discoverer Administrator. It includes the following topic:
Before installing the video stores tutorial in Oracle Database 10g Enterprise Edition Release 2 (version 10.2.0.1 and higher), you must manually create the VIDEO5 user. If you attempt to install the video stores tutorial in Oracle Database 10g Enterprise Edition Release 2, then the installation will fail if the VIDEO5 user does not already exist. To work around this issue:
Create the VIDEO5 user manually by completing these steps:
Access Oracle Database 10g with SQL*Plus, Enterprise Manager, or any SQL command line tool.
Create the VIDEO5 user.
Grant CONNECT and RESOURCE privileges to the VIDEO5 user.
For more information about creating users and granting privileges, see the Oracle Database SQL Reference or your DBA
Connect to Discoverer Administrator as the EUL owner and install the tutorial. You must enter the VIDEO5 user password during installation.
For information about installing the video stores tutorial, see the Oracle Fusion Middleware Administrator's Guide for Oracle Business Intelligence Discoverer.
This section describes the documentation errata. It includes the following topics:
Section 33.8.1, "Incorrect Information about Discoverer Desktop and Application Server"
Section 33.8.2, "Additional Step When you Create Cascading Parameters in Discoverer Plus"
Section 33.8.3, "Incorrect Information about Databases Supported for Discoverer"
Section 1.6.2 "How does Discoverer work?" of the Oracle Fusion Middleware Administrator's Guide for Oracle Business Intelligence Discoverer states: "In the case of Discoverer Plus, Discoverer Desktop and Discoverer Viewer, the SQL statements are routed to the database through Discoverer processes running on an application server machine." This sentence contains an error.
Discoverer Desktop does not require an application server. When you use Discoverer Desktop, SQL statements are sent directly to the database.
Corrected sentence: "In the case of Discoverer Plus and Discoverer Viewer, the SQL statements are routed to the database through Discoverer processes running on an application server machine."
In the "About filtering lists of parameter values based on selected conditions (cascading parameters)" section of Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Discoverer Plus, the following information is missing:
When you create cascading parameters from worksheet items of two simple folders, which are based on different tables, ensure that a join condition is defined between the two folders. For example, you might want to create a cascading parameter relationship between Region and City items. If the Region and City are items of two folders, these folders must be related using a join condition.
If you create a cascading parameter relationship between items in a custom SQL folder and if no simple folders exist (based on the tables used in the custom SQL folder), you must do the following:
Create simple folders for each of the tables used in the view
Define a join relationship between the folders used for the cascading parameters
For more information about creating joins, see the "Creating and Maintaining Joins" section in Oracle Fusion Middleware Administrator's Guide for Oracle Business Intelligence Discoverer.
Section 1.3.3 "About Discoverer installations and the Oracle11g Database" of the Oracle Fusion Middleware Configuration Guide for Oracle Business Intelligence Discoverer does not contain complete and correct information about the databases supported for Discoverer.
Ignore the content in that section; instead, see System Requirements and Supported Platforms for Oracle Fusion Middleware 11gR1 on OTN.