Oracle® Developer Suite Release Notes
10g (9.0.4) for Windows and UNIX Part No. B10668-01 |
|
![]() |
![]() |
This chapter discusses issues and workarounds for Oracle Reports, including Oracle Reports Developer (Reports Developer) and Oracle Application Server Reports Services (Reports Services). The chapter includes the following topics:
The notes in this chapter cover issues and workarounds that are not documented in Oracle Reports 10g manuals and online help. For information about the new features in this release, refer to the Oracle Reports 10g page on OTN (http://otn.oracle.com/products/reports/index.html
), and to the "About this release" topic in the Reports Builder online help.
Note: You can also download the latest version of the Reports Builder online help from the Oracle Reports 10g OTN page. |
This section describes general issues and workarounds for Oracle Reports.
Currently there is no support for FTP and WebDaV destinations from the Reports Builder environment. However, they are supported from the Reports Runtime and the Reports Server environments.
When you are debugging an OracleAS Reports Services JSP in Oracle9i JDeveloper (JDeveloper), you must disable any breakpoints that are not of source type. If you do not disable these breakpoints, a deadlock occurs. You can disable breakpoints that are not of source type in the Breakpoints window.
When you run a JSP report with the rw:graph
tag in JDeveloper, the graph image is not visible in the browser. To fix this problem, set the IMAGEURL
parameter in the rwservlet.properties
file in oracle_home
/reports/conf
:
IMAGEURL=http://host:port/Workspace-Project-context-root/servlet/
oracle.reports.rwclient.RWClient
If you set the JDeveloper Java Virtual Machine (JVM) to ojvm
, minimal
, or vanilla
(Project Settings > Runner > Virtual Machine), the rwservlet's in-process server is not killed when you terminate JDeveloper’s embedded OC4J server. As a result, a port conflict occurs the next time you start OC4J. To avoid this problem, do one of the following:
Set the JVM to hotspot
.
Disable the in-process server in oracle_home
/reports/conf/rwservlet.properties
by setting server_in_process=no
.
Use the standalone Reports Server instead.
This section contains issues and workarounds that apply to specific operating environment platforms supported by Oracle Developer Suite.
This section contains issues and workarounds that apply specifically to supported Microsoft Windows platforms.
Oracle Reports’s architecture uses VisiBroker’s osagent
to find the various servers running in the network.
You use osfind to find various osagent
instances running on the network. However, osfind
does not work with the JDK version used by Oracle Application Server (version 1.4). To work around this issue and find osagent
instances running on the network, you must run osfind
with the following settings:
osfind -J-Xbootclasspath /p:oracle_home\vbroker4\lib\vbjboot.jar
If you open the Getting Started page from Reports Builder using Netscape 7.0, you might get a Failed to locate browser
error. To correct this problem:
Open the Windows registry using a registry editor (for instance, regedit.exe
).
Note: Create a backup of the registry before proceeding to edit it. |
Navigate to the following key:
HKEY_CURRENT_USER\Software\Oracle\Toolkit\Tkbrowser
Delete all other values except Default
.
Run Reports Builder and select Getting Started.
Click OK. The Information Navigator Preferences dialog box appears.
Select Netscape Navigator 7.0+ as the browser. Ensure that the path and the browser program name are accurate. To change the browser location (if the path or the program name is incorrect):
Click Browse.
Navigate to the location and program name you want.
Click OK.
In the Information Navigator Preferences dialog box, click OK.
Oracle Reports 10g (9.0.4) has been changed to generate the report output relative to the top-left corner of the physical paper. Earlier, the printer's printable area was used, causing inconsistencies in the location of the report output when used across different printer models.
If required, you can revert to the earlier behavior by setting the registry key REPORTS_ADD_HWMARGIN
to YES
.
To set the REPORTS_ADD_HWMARGIN
registry key to YES
:
Back up the Windows registry, then edit it using a registry editor such as regedit.exe
.
Note: Refer to Windows online help for instructions on how to back up the registry. |
Navigate to the key HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
, then find the HOMEn
key that contains the directory for the Oracle home that contains Reports.
With this key selected, add a new String sub-key named
and set its value to
REPORTS_ADD_HWMARGINYES
.
By default, the non-printable left margin of the printer is ignored. The printing origin starts from the top-left corner (0,0) of the physical paper and not the printable area. If you have set the registry key value to YES
and then want to switch to the default, you can set the key value to NO
, or you can delete the key.
You must provide enough margin in your report's layout to put the data within the printable area. The margin fields in the Page Setup dialog box of Reports Builder have been disabled to ensure consistency with OracleAS Reports Services.
Note: UNIX issues are classified as platform-specific unless it is certain that they occur on all UNIX platforms. Also, platform-specific issues are only reported for the platform on which they were first detected; an issue that is listed as "platform-specific" may actually occur on several platforms. Unless the notes say otherwise, you should only use a platform-specific workaround on the stated platform. |
This section contains issues and workarounds specifically for all supported UNIX platforms including SPARC Solaris, HP HP-UX, and Linux x86.
With Oracle Reports 10g (9.0.4), it is no longer necessary to have the DISPLAY environment variable or a valid printer defined at runtime.
The REPORTS_DEFAULT_DISPLAY
environment variable specifies whether to implement the following features:
The elimination of the dependency on the DISPLAY
environment variable, which was required in prior releases to define the windowing system display surface for creating images and getting pixel resolution.
The elimination of the dependency on having a valid printer defined for font information (PRINTER
and TK_PRINTER
environment variables set to a valid printer, or a valid entry in uiprint.txt
).
Using screenprinter.ppd
for surface resolution for images and font information.
Enhanced imaging support
Note: Although these issues were seen on Solaris, they may also exist on other UNIX platforms, such as Linux and HP-UX. |
On Solaris, invoking the Graph Wizard in a multibyte (Japanese, Simplified Chinese, and Korean) environment causes Reports Developer to stop responding.
To work around this issue, you must:
Install J2SE Version 1.4.2 on your computer. You can download J2SE 1.4.2 from Sun Microsystem’s Java web site (http://java.sun.com
).
Set the path to the J2SE home in the reports.sh
file:
PATH=$J2SEHOME/bin:$ORACLE_HOME/jdk/bin: $ORACLE_HOME/bin:${PATH};
export PATH
Modify LD_LIBRARY_PATH
in reports.sh
to point to the location of the J2SE home:
LD_LIBRARY_PATH=$J2SEHOME/lib/sparc: $ORACLE_HOME/jdk/jre/lib/sparc:$ORACLE_HOME/lib: ${LD_LIBRARY_PATH}; export LD_LIBRARY_PATH
This section contains issues and workarounds specifically for supported Linux x86 platforms.
Reports Builder has a known issue with selecting a radio button with your mouse.
When you select a radio button in the New Program Unit dialog box, close the dialog box (for example, by clicking on Cancel) and then reopen the New Program Unit dialog box, you cannot select the same radio button.
For example, if you select the Function radio button, close the New Program Unit dialog box, and then reopen it, you cannot select the Function radio button.
You can work around this using either of the following methods:
Select a radio button other than the one you selected previously, then select the one you want. For example, to select the Function radio button, first select the Procedure radio button. You can then select the Function radio button.
Use your keyboard to select the radio button. Navigate to the radio button using the Tab, Up, and Down keys, then use the space bar to select the radio button.
For further details, please refer to bug 3209858: RWBUILDER: NEW PROGRAM UNIT: CANNOT MAKE RADIO BUTTON SELECTION WITH MOUSE
This section contains issues and workarounds for Oracle Reports Developer configuration.
Text in the user interface of Reports Builder, such as the window title, uses fonts taken from the system resource files for the current language. These system resource files are supplied with the Oracle Reports installation. In Oracle Reports, you can map these fonts in the [RWBUILDER]
section of uifont.ali
. If found, the mapped font is used instead of the original font; if not, Oracle Reports uses the original font.
Note: The mapped font needs to be a fixed-width font. |
In the Web Source view of the Report Editor, the following languages may appear garbled: Arabic, Central European languages, Cyrillic, Greek, Hebrew, Japanese, Thai, and Turkish. To work around this issue, you can set the font names for Reports Builder in uifont.ali
as follows:
[rwbuilder] .....AR8MSWIN1256="Courier New" .....CL8MSWIN1251="Courier New" .....EE8MSWIN1250="Courier New" .....EL8MSWIN1253="Courier New" .....IW8MSWIN1255="Courier New" .....JA16SJIS="MS Gothic" .....TH8TISASCII="Andale Duospace WT" .....TR8MSWIN1254="Courier New"
You can download a copy of the Andale Duospace WT (fixed-width) font from OracleMetalink (http://metalink.oracle.com
). The ARU number is 2638552.
Before you deploy a report on a computer that is either slow or is running on a load, you may want to configure the following:
Ping timeout (OPMN-side): Ping timeout is the measure that OPMN uses to determine the time that it must wait for a callback from an in-process Reports Server (in OC4J_BI_FORMS), before considering it as a timeout.
The default timeout period is 150. This period is calculated from: ping timeout, ping interval, and number of retries. The default values for these are:
ping timeout = 30 seconds
ping interval = 20 seconds
number of retries = 3
Note: The number of retries is applicable only when OPMN successfully connects to OC4J and receives regular ONS notifications from the process. |
Based on these values, there will be three ping attempts with a timeout of 30 seconds each at 20 second intervals. The first ping is done after the specified ping interval. Thus, from the time the OC4J is started by OPMN, approximately 150 (20 + 3*30 + 2*20) seconds will elapse before the process is considered unresponsive and restarted. However, if after OPMN connects to OC4J but OC4J is too slow in sending regular ONS notifications then the 30 second timeout is applicable.
See Also: Oracle Application Server Reports Services Publishing Reports to the Web for more information on theopmn.xml file.
|
Callback timeout (Reports Server-side): Callback timeout is the measure that Reports Server uses to determine the time that it must wait for a response from the engine before timing out. You can specify this value in the Reports Server configuration file, server_name
.conf
. This time out period is in milliseconds.
For example:
<engine id="rwEng" class="oracle.reports.engine.EngineImpl" initEngine="1" maxEngine="1" minEngine="0" engLife="50" maxIdle="30" callbackTimeOut="80000">
Note: Increase the timeout when the machine is very slow. |
The REPORTS_GRAPH_IMAGE_DPI
environment variable specifies a dots per inch (DPI) value for graphs displayed to a PDF file or on a printer. The default value for this environment variable is 72 DPI, which minimizes the time it takes to generate the report and reduces the report file size.
If you specify a value higher than 72 DPI, you will see an improvement in the image resolution. However, this increases the time it takes to generate the report and increases the report file size.
For instance, setting the value to 250:
Increases the time to generate a report by 5 to 6 times that of a report generated at 72 DPI.
Increases the PDF file size by 5 to 6 times that of a report generated at 72 DPI.
Usage Notes
The valid values are 72 through 300.
The default value is 72.
For Windows, set the value in the Windows registry key HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME
n
\
REPORTS_GRAPH_IMAGE_DPI
. Refer to Section 9.2.1.3, "Printing Reports Without Hardware-based Left Margins" for instructions on how to set a registry key value.
For UNIX, set the value by setting the environment variable in reports.sh
.
When you set a DPI value greater than 250 and your chart is bigger than 5"x5", you may also need to change the JVM heap size value usingREPORTS_JVM_OPTIONS
to avoid an Out Of Memory
error in the JVM.
This variable is currently not supported in Oracle Reports distribution functionality as this is specific to PDF and printer outputs only.
See Also: Oracle Application Server Reports Services Publishing Reports to the Web for more information on setting the JVM options. |
You may want to set Oracle Reports’ Java Virtual Machine (JVM) options explicitly to get certain specific behaviors from the JVM that aren't enabled by default. To do this, use the command line option JVMOPTIONS
.
You can use JVMOPTIONS
to set options for Reports Runtime, Reports Builder, or Reports Converter's JVM. For example, you can use the following command line to start Reports Builder with a 512MB heap space:
rwbuilder jvmoptions=-Xmx512M
You can set more than one option by enclosing the value in quotes:
rwbuilder jvmoptions="-Xmx256M -Xms=128M"
The syntax of JVMOPTIONS
is
JVMOPTIONS=option | "option [option]"
where option
is a valid option for a Reports JVM.
The default value for JVMOPTIONS is -Xmx256M
.
Note: The value ofJVMOPTIONS overrides the value in the REPORTS_JVM_OPTIONS environment variable.
|
In OracleAS Portal, when you have configured Oracle Reports Security settings for Reports Definition File Access by editing a reports definition file, you may encounter the following error when you click Run or Run as Portlet:
500 Internal Server Error Unexpected Error. Please contact Administrator
This error occurs when all of the following conditions are true:
You have an Interop deployment (which allows for a mixed 9.0.2/9.0.4 environment), with 9.0.4 MT (mid-tier), 9.0.4 IM (Identity Management), and 9.0.2 MR (metadata repository) configured to run together.
You are running Oracle Reports within OracleAS Portal, using the SSOCONN parameter.
The connection resource you specify in the SSOCONN parameter was not created in the Oracle Internet Directory (OID) server.
To work around this issue, do the following:
In the 9.0.4 IM Oracle home, open the following file in a text editor:
oracle_home
/Apache/Apache/conf/mod_osso.conf
Add the following line to the file:
OssoRedirectByForm on
For example:
<IfModule mod_osso.c> OssoIpCheck off OssoIdleTimeout off OssoConfigFile /private1/iasinst/install_set1/904infra/Apache/Apache/conf/osso/osso.conf OssoRedirectByForm on </IfModule>
You can preview a report from Reports Builder by using the Run To Web Layout functionality. You do not need to have the Reports Server configured in order to use this functionality, because Reports Builder includes an embedded Oracle Application Server Containers for J2EE(OC4J) server.
After you upgrade to Oracle Reports 10g (9.0.4) from Oracle9i Reports Release 2 (9.0.2), you must ensure that the location in the environment variables CLASSPATH
or REPORTS_CLASSPATH
refer only to the oc4j.jar file
in the 10g (9.0.4) Oracle home. You must remove the path to the 9.0.2 Oracle home oc4j.jar
if it exists in either REPORTS_CLASSPATH
or CLASSPATH
.
If you include the 9.0.2. oc4j.jar
file path in either CLASSPATH
or REPORTS_CLASSPATH
, the Run to Web Layout functionality will fail with the following error:
The major.minor version '48.0' is too recent for this tool to understand
This section describes administration issues and their workarounds for Oracle Reports Developer.
The identifier
element in server_name
.conf
contains a new value called SERVERACCESSKEY
. This value is used to ensure that the Reports Server information in Oracle Enterprise Manager (EM) is secure. The following authentication is implemented:
The value of the identifier element in the server_name
.conf
file is encrypted and is of the form %SERVERACCESSKEY_USER%/%SERVERACCESSKEY_PASSWORD%
. For example:
<identifier confidential="yes" encrypted="no"> %SERVERACCESSKEY_USER%/%SERVERACCESSKEY_PASSWORD% </identifier>
The corresponding entries in the targets.xml
file are:
<Property NAME="UserName" VALUE="%SERVERACCESSKEY_USER%" ENCRYPTED="FALSE"/> <Property NAME="Password" VALUE="%SERVERACCESSKEY_PASSWORD%" ENCRYPTED="FALSE"/>
The default installation ensures that the install time values of %SERVERACCESSKEY_USER%
and %SERVERACCESSKEY_PASSWORD%
match those in targets.xml
.
Note: %SERVERACCESSKEY_USER% and %SERVERACCESSKEY_PASSWORD% in server_name .conf and targets.xml must match for the Reports Server pages in EM to display data correctly.
|
To change the user name and password:
Edit the oracle_home
/reports/conf/
server_name
.conf
file, as follows:
<identifier confidential="yes" encrypted="no">new_username
/new_password
</identifier>
Edit the oracle_home
/sysman/emd/targets.xml
file, as follows:
<Property NAME="UserName" VALUE="new_username" ENCRYPTED="FALSE"/> <Property NAME="Password" VALUE="new_password" ENCRYPTED="FALSE"/>
Restart EM and Reports Server. The user name and password in server_name
.conf
and targets.xml
will be encrypted after the restart.
Note: Beginning with Oracle Reports 10g (9.0.4), Enterprise Manager (EM) will not use OID authentication to access Reports Server information. It will use theSERVERACCESSKEY value to specify the authentication.
|
When you install OracleAS Portal with a non-default language setting, some entries required to publish a report as an item link on a portal page are not installed automatically. You must install the language of your choice by using the rwlang.sql
script.
Run the script rwlang.sql
in the directory oracle_home
/portal/admin/plsql/wwd/
if:
You selected at least one language in addition to the default ("US") when you installed OracleAS Portal
You want to publish a report as an item link in OracleAS Portal.
This is a one time post-installation task and will ensure that you can publish a report as an item link on OracleAS Portal.
To run the script:
Navigate to the directory oracle_home
/portal/admin/plsql/wwd/
.
Run SQL*Plus.
Logon to OracleAS Portal using the portal schema.
Note: This is the portal schema you used to install OracleAS Portal PL/ SQL packages. |
Run the script rwlang.sql
with a list of language identifiers corresponding to the languages you installed with OracleAS Portal:
@rwlang.sql
language_list
where language_list
is a list of language identifiers, separated by commas.
For example, if you installed French and Japanese when you installed OracleAS Portal, you would run the following command:
@rwlang.sql f,ja
.
Usage Notes:
Do not leave spaces before or after the comma (,), otherwise SQL*Plus will interpret the language list as two parameters, instead of one parameter containing a comma delimiter.
The file rwlang.sql
contains a complete list of language identifiers. You can view the file with a text editor to find the identifiers you want.
This section describes known errors in the documentation.
Chapter 8, sections 8.1.2 through 8.2, of the Oracle Application Server Reports Services Publishing Reports to the Web manual specifies the reports.sh
file as containing the REPORTS_CLASSPATH
variable on Solaris. The REPORTS_CLASSPATH
variable is located in the reports.sh
file for all UNIX platforms.
Chapter 19, "Managing and Monitoring OracleAS Reports Services", of the Oracle Application Server Reports Services Publishing Reports to the Web manual may show screenshots that do not reflect the latest updates to the Oracle Enterprise Manager user interface.
Due to improvements on OTN, the URL that directly accesses the Oracle Reports Documentation page is incorrect in the documentation. Instead of http://otn.oracle.com/docs/products/reports/content.html
, the revised URL is http://otn.oracle.com/documentation/reports.html