Oracle® Application Server Release Notes
10g Release 2 (10.1.2) for Linux x86 B19312-02 |
|
![]() Previous |
![]() Next |
This chapter describes issues associated with Oracle Business Intelligence. It includes the following topics:
Section 13.2, "Oracle Business Intelligence Discoverer Plus Relational"
Section 13.3, "Oracle Business Intelligence Discoverer Plus OLAP"
Section 13.4, "Oracle Business Intelligence Discoverer Portlet Provider"
Section 13.5, "Oracle Business Intelligence Discoverer Viewer"
Section 13.6, "Oracle Business Intelligence Discoverer EUL Command Line for Java"
This section describes general issues and workarounds for Oracle Business Intelligence products. It contains the following topics:
Section 13.1.3, "Compatibility Issues with Required Support Files"
Section 13.1.4, "Resizing Issue with Mozilla and Firefox Browsers"
Section 13.1.6, "Query Prediction Requires the Majority of the Query Time"
Section 13.1.9, "Corrections to the OracleBI Discoverer Connections Help"
Section 13.1.10, "Corrections to the Oracle Business Intelligence Discoverer Configuration Guide"
For the latest certification information, which supersedes that in the Oracle Business Intelligence documentation, refer to OracleMetalink at the following location:
Previous versions of Oracle Business Intelligence Discoverer shipped with the files HWOnline.htm
and Memo.doc
, which were used to demonstrate "drill out" functionality. To reduce disk space requirements and installation time, these files and instructions for their use will be made available from Oracle Technology Network:
http://www.oracle.com/technology/sample_code/products/discoverer/index.html
The Oracle Database and other Oracle database client software (for example, SQL*Plus, the database export utility) use Oracle Required Support Files (RSF).
Oracle Business Intelligence also uses Oracle Required Support Files (RSF), specifically RSF version 10.1.0.4. This version of the Oracle Required Support Files is installed during Oracle Business Intelligence installation.
Note that the Required Support Files version 10.1.0.4 is incompatible with earlier versions of Oracle Database 10g. So if the machine on which you install Oracle Business Intelligence already has a version of Oracle Database 10g or database client software that is earlier than 10.1.0.4, there will be compatibility issues. For example, if you install Oracle Business Intelligence and attempt to run a version of SQL*Plus earlier than 10.1.0.4, 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 (that is, 10.1.0.4) as the version of the Required Support Files that were installed with Oracle Business Intelligence.
This issue does not exist for Oracle9i Database Server.
When you use Oracle Business Intelligence Discoverer Plus Relational or Oracle Business Intelligence Discoverer Plus OLAP with Mozilla and Firefox browsers (version 1.5 and later) and you resize the browser window, the browser can freeze and might crash the applet intermittently. This issue is caused by the following bugs in the Sun Java Runtime Engine: 4836462 and 5076485.
To work around this issue, do not resize the applet window (especially on Linux platforms) or use a different browser, such as Internet Explorer.
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 Business Intelligence Discoverer Plus in English, the file is named file.properties
. If you use Oracle Business Intelligence Discoverer Plus 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
When using Oracle Business Intelligence 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 will be 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, refer to the Oracle Business Intelligence Discoverer Configuration Guide.
To use word wrap settings correctly, you must understand how they are designed for Oracle Business Intelligence Discoverer:
For OracleBI Discoverer Plus: Word wrap settings that you make in OracleBI Discoverer Plus are saved in the worksheet and affect the display of worksheets in OracleBI Discoverer Plus and when printing to PDF.
For OracleBI 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 OracleBI 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 OracleBI Discoverer Viewer do override the settings made in a worksheet in OracleBI 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 OracleBI Discoverer Viewer do not override the settings made in a worksheet in OracleBI 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 box is checked or unchecked, the print settings in OracleBI Discoverer Viewer never override the settings made in a worksheet in OracleBI Discoverer Plus OLAP for printing to PDF.
When you use Microsoft Internet Explorer, the OracleBI Discoverer Plus applet initialization and download dialog appears behind the browser window from which it was launched. After the OracleBI Discoverer Plus applet is downloaded and initialized, it will appear 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 OracleBI Discoverer Plus URL parameter _plus_popup=false that is documented in the Oracle Business Intelligence Discoverer Configuration Guide.
This section provides information about corrections to the OracleBI Discoverer Connections Help. It contains the following topics:
Section 13.1.9.1, "Account Details: Enter Password page Help topic"
Section 13.1.9.2, "Account Details: Select Responsibility page Help topic"
Section 13.1.9.3, "Connect to OracleBI Discoverer page Help topic"
Section 13.1.9.4, "Account Details: Username and Password page Help topic"
Section 13.1.9.5, "Account Details: Select Username page Help topic"
Section 13.1.9.6, "Enter connection details page Help topic"
This Help topic is incorrectly called the Create Connection: Enter Password page, when it should be called the Account Details: Enter Password page.
This Help topic is incorrectly called the Select Applications Responsibility for Discoverer connection page, when it should be called the Account Details: Select Responsibility page.
The Create Connection button should have the following additional text:
Note: The Create Connection button will be disabled if the OracleBI Discoverer manager specifies (in Application Server Control) that end users cannot create private connections.
Disregard the note and the bullet points underneath the Password field.
This section provides information about corrections to the Oracle Business Intelligence Discoverer Configuration Guide. The following table summarizes the corrections required:
Section 15.1 "About Discoverer connections and Oracle e-Business Suite", disregard the last bullet point in the notes section that begins 'If you have already connected to the database using SSO...'
Disregard the whole of Section 15.2 "About Discoverer private connections, OracleAS Single Sign-On and Oracle e-Business Suite users".
In Appendix A.1 "List of Discoverer file locations", disregard the entry for migratediscoconnection.bat/sh script.
In Appendix A.2 "List of configuration settings in configuration.xml", disregard the enableAppsSSO setting.
This section provides information about corrections to Oracle Enterprise Manager 10g Application Server Control (Application Server Control) Discoverer Help. It contains the following topics:
Section 13.1.11.1, "Discoverer Administration page Help topic"
Section 13.1.11.2, "Discoverer Configuration page Help topic"
Section 13.1.11.4, "Log in to Manage Catalog page Help topic"
Section 13.1.11.6, "Discoverer Plus Configuration page Help topic"
Section 13.1.11.7, "Discoverer Portlet Provider Configuration page Help topic"
Section 13.1.11.8, "Discoverer Administration page Help topic"
The Discoverer Administration page Help topic should be amended as follows:
Links to Install Catalog, Uninstall Catalog, and Manage Catalog on the OracleBI Discoverer Administration page Help topic should be called Install, Uninstall, and Manage respectively.
The Discoverer Configuration page Help topic should be amended as follows:
The Viewer Delay Times area has the following two new fields:
Query Request Timeout (seconds)
The time to wait before OracleBI Discoverer displays the Query Progress page.
Long Request Timeout (seconds)
The time to wait before OracleBI Discoverer displays the Query Progress page for long queries.
This Help topic is incorrectly called the Discoverer Install Catalog page, when it should be called the Install Catalog page.
This Help topic is incorrectly called the Discoverer Log in to Manage Catalog page, when it should be called the Log in to Manage Catalog page.
This Help topic is incorrectly called the Discoverer Uninstall Catalog page, when it should be called the Uninstall Catalog page.
The Discoverer Plus Configuration page Help topic should be amended as follows:
The Default (Oracle Logo) radio button should be changed to say None and its description should be as follows:
Use this radio button to avoid displaying a logo in OracleBI Discoverer Plus Relational and OracleBI Discoverer Plus OLAP.
The Discoverer Portlet Provider Configuration page Help topic should be amended as follows:
The Discoverer Session Pool heading should be changed to Discoverer Session.
The Portlet Generic Parameters field should be changed to the Maximum Generic parameters field.
The Discoverer Administration Help topic should be amended as follows:
Disregard the section "Connect to SSO-enabled Oracle Applications database" that contains the Allow authenticated OracleAS Single Sign-On (SSO) users to create and use private connections to SSO-enabled Oracle Applications databases, without entering a password check box.
This section provides release notes for Oracle Business Intelligence Discoverer Plus Relational (OracleBI Discoverer Plus Relational). It contains the following topics:
Section 13.2.2, "Non-ASCII Characters Not Saved Correctly in Title or Text Area"
Section 13.2.4, "Corrections to the OracleBI Discoverer Plus Relational Help"
When you run OracleBI Discoverer Plus Relational with Sun Java Plug-in 1.4.2_06, the Browser Look and Feel, and an Asian language (such as Japanese, 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 1.4.2_10, when it becomes available from Sun Microsystems.
When you save a new workbook in OracleBI 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.
OracleBI Discoverer Plus is running against an Oracle E-Business database that does not have that non-English language installed.
This issue has no workaround.
With Mac OS X, if you resize the browser window in the OracleBI Discoverer Plus applet, then some parts of the content might be clipped. This issue is specific to Mac OS X. To work around this problem, always maximize the browser window for the OracleBI Discoverer Plus applet when working with Mac OS X.
This section provides information about corrections to OracleBI Discoverer Plus Relational Help. It contains the following topics:
The OracleBI Discoverer Plus Help topics contain a number of references to the Connect to Discoverer Plus page. Each reference to the Connect to Discoverer Plus page should instead refer to the Connect to OracleBI Discoverer page.
The following important bugs were fixed in this release:
In previous releases, you could not automatically open exported files with non-ASCII file names; that is, file names that used Asian characters (for example, Japanese language characters).
In previous releases, you could not specify and save the paper size for printing in the Page Setup dialog of OracleBI Discoverer Plus.
This section provides release notes for Oracle Business Intelligence Discoverer Plus OLAP (OracleBI Discoverer Plus OLAP). It contains the following topics:
Section 13.3.5, "Link Tool Works Incorrectly in Some Locales"
Section 13.3.6, "Memory Issues when Exporting Extremely Large Graphs"
Section 13.3.8, "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. Disable caching in the plug-in to avoid this issue.
When you are running Netscape 7.x or Mozilla browsers, the Netscape and Mozilla Mail clients and Web browser may become disabled when OracleBI Discoverer Plus OLAP modal dialogs are displayed. Dismissing the OracleBI Discoverer Plus OLAP dialog 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, may 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 OracleBI Discoverer Plus OLAP session. This issue has no workaround.
Reinvoking the Page Setup dialog from the Print dialog may cause the Page Setup dialog to be blank. 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:
Non-empty titles and text areas will be 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.
This section provides release notes for OracleBI Discoverer Portlet Provider. It contains the following topics:
In the Display Options of a gauge portlet, the Minimum Value and Maximum Value range labels are checked but are also disabled so that you cannot deselect the display of those values. The values for the minimum and the maximum will 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.
This section provides information about corrections to Help topics in OracleBI Discoverer Portlet Provider. It contains the following topics:
In the Refresh Options page Help topic, the description of the First Refresh Date field reads like so:
Use this field to specify the date that the data in the portlet is first updated (DD-MON-YYYY). For example, enter 25-JAN-2005 to update the data on January 25th, 2005. Click the adjacent calendar icon to select a date using a graphical calendar.
The correct text reads like so:
Use this field to specify the date that the data in the portlet is first updated (DD-MM-YY). For example, enter 25/01/05 to update the data on January 25th, 2005. Click the adjacent calendar icon to select a date using a graphical calendar.
In the Review Portlet Defaults page Help topic, the description reads like so:
When you are ready to save the portlet settings, click Apply.
The correct text reads like so:
When you are ready to save the portlet settings, click Finish. When you edit an existing portlet, you click Apply in the Review Portlet Defaults page.
This section provides release notes for Oracle Business Intelligence Discoverer Viewer (OracleBI Discoverer Viewer). It contains the following topics:
Section 13.5.1, "Drill Icons Cannot Be Hidden in OracleBI Discoverer Viewer"
Section 13.5.2, "Error Sending E-mail in OracleBI Discoverer Viewer"
Section 13.5.3, "Error Displaying Page for Multiple SSO Users"
Section 13.5.4, "Inability to Disable the Display of Row Numbers"
Section 13.5.5, "Issues with OracleBI Discoverer Viewer Embedded in Frames"
Section 13.5.6, "Known Bug with JAWS Prevents Drilling using Enter Key"
Section 13.5.7, "JAWS Does Not Read Asterisks that Precede Fields"
Section 13.5.8, "Corrections to the OracleBI Discoverer Viewer Help"
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 OracleBI Discoverer Viewer. The issue has no workaround.
After you configure an SMTP server that has a hyphen in the name (for example, my-smtpserver.mycompany.com
) for OracleBI Discoverer Viewer in Application Server Control, users will see the following error message when they try to send e-mail from OracleBI Discoverer Viewer:
OracleBI Discoverer was unable to read the configuration file. A value is required for the following expression my-smtpserver.mycompany.com
The application log contains the following text:
ERROR: Invalid SMTP Server
To work around this issue, use the IP address of the server instead of the server name when configuring the SMTP server. This problem will be fixed in a future patch release.
When an OracleAS Single Sign-On (SSO) user tries to view a worksheet from a List of Worksheets Portlet using the same browser window that is already being used by an SSO user to view that worksheet, the second user will see the following error message: "The page cannot be displayed".
To work around this issue, start a new browser session and view the worksheet.
OracleBI 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 OracleBI 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 OracleBI Discoverer server that is running OracleBI Discoverer Viewer.
Use one of the following workarounds for this issue:
Run the OracleBI 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 OracleBI Discoverer server using the following steps:
Use Application Server 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:
ORACLE_HOME/j2ee/OC4J_BI_Forms/applications/discoverer/discoverer/cabo/jsLibs
Edit the Common2_2_20.js
file and replace all occurrences of "parent._pprSomeAction" with "window._pprSomeAction".
Use Application Server 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.
OracleBI Discoverer can be used in conjunction with assistive technologies such as the JAWS screen reader. However, a bug in JAWS prevents drilling from working correctly in OracleBI Discoverer Viewer when querying a relational datasource, described as follows.
Assume 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 Business Intelligence Discoverer Viewer User's Guide).
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 using the keyboard, and JAWS does not read the items on the popup menu. This issue has no workaround.
In OracleBI 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.
This section provides information about corrections to OracleBI Discoverer Viewer Help. It contains the following topics:
Section 13.5.8.1, "References to the Connect to Discoverer Viewer page"
Section 13.5.8.3, "Printable Page Options page: Content Tab Help topic"
The OracleBI Discoverer Viewer Help contains a number of references to the Connect to Discoverer Viewer page. Each reference to the Connect to Discoverer Viewer page should instead refer to the Connect to OracleBI Discoverer page.
The List of Worksheets page Help topic should display the following note:
Note: When using a private connection or connecting directly, if you use the Web browser controls (refresh, back, and forward) to refresh or navigate to or from the Worksheet List page, then you might be disconnected. If this happens, then OracleBI Discoverer Viewer prompts you to re-connect. Use controls within the page for navigation and refreshing.
This Help topic is incorrectly called the Printable Page Options page: Page Content tab, when it should be called the Printable Page Options page: Content tab.
The following changes should be made to this Help topic:
The Always, when available field, and its description are duplicated and one should be removed.
The When summary data is more recent than nn days field and its description should be removed.
There are no known issues for the Oracle Business Intelligence Discoverer EUL Command Line for Java.
This section describes some of the known issues with the Oracle OLAP option. These issues affect all products that access OLAP data, including OracleBI Discoverer Plus OLAP and OracleBI Discoverer Viewer.
At times, database resources are not properly released in the Oracle9i (Release 2) OLAP option. This may result in excessive memory consumption. To release the resources, close OracleBI Discoverer Plus OLAP or OracleBI Discoverer Viewer.
There are potential performance issues running against analytic workspaces in Oracle OLAP 10g Release 1 version 10.1.0.4. To work around these issues, always check OracleMetalink for the appropriate Oracle OLAP patches at the following location:.