Oracle® Application Server Release Notes
10g Release 2 (10.1.2) for AIX 5L Based Systems (64-Bit) B25203-02 |
|
Previous |
Next |
This chapter describes issues with Oracle Reports. It includes the following topics:
Note:
|
This section describes general issues and their workarounds for Oracle Reports. It includes the following topics:
Section 17.1.1, "Enabling Backward Compatibility with 9.0.4"
Section 17.1.2, "OracleAS Reports Services Demos Will Not Work If JServ is Configured"
Section 17.1.3, "Error While Editing Batch Registered Report in OracleAS Portal"
Section 17.1.4, "Limitation on Linked Queries for DelimitedData Output"
Section 17.1.8, "PL/SQL Compilation Failure When Using SQL Constructs"
Section 17.1.10, "Set REPORTS_DEFAULT_DISPLAY and LDR_CNTRL in the reports.sh File"
Section 17.1.11, "Out of the Box Reports In Process Server Will Not Work with the Demos (Test.rdf)"
Oracle Reports 10g Release 2 (10.1.2) replaces the use of Borland VisiBroker with Sun Microsystems industry-standard Java Developer's Kit Object Request Broker (JDK ORB), providing support for Reports Server requests from clients across subnets, and using the broadcast mechanism for dynamic Reports Server discovery, both within a subnet and across subnets. For information about the changes related to JDK ORB, refer to the Oracle Application Server Reports Services Publishing Reports to the Web manual.
For releases prior to 9.0.4.3, you must apply the patch issued for 9.0.4.2 to achieve ORB backward compatibility between Oracle Reports (9.0.4) client and 10g Release 2 (10.1.2) server, or vice versa. Beginning with 9.0.4.3, the patch is included in the installation.
Platform-specific details for this patch are provided in bug 4092150.
To run OracleAS Reports Services demos properly, do not configure Apache JServ on the computer where OracleAS Reports Services is installed.
If you batch register a report in OracleAS Portal, then subsequently manually edit the report's registration in OracleAS Portal, you may encounter an unexpected Save As dialog box during the manual editing process.
To work around this issue, specify the Display Name property while editing the report's registration in OracleAS Portal.
Refer to the Oracle Application Server Reports Services Publishing Reports to the Web manual for information on how to register a report with OracleAS Portal.
DelimitedData output does not allow multiple queries to be linked to the main query, because sibling groups are not supported.
For example:
Case 1: You have a link between Q1
and Q2
, a link between Q2
and Q3
, and a standalone Q4
query.
Q1<-->Q2<-->Q3 Q4
In this case, DelimitedData output is generated correctly.
Case 2: You have a link between Q1
and Q2
, a link between Q2
and Q3
, and a link between Q4
and Q1
.
Q1<-->Q2<-->Q3 Q1<-->Q4
In this case, DelimitedData output is not generated correctly. Alternatively, you can use XML output.
If any summary column values are not correctly left-aligned in the output of JSP-based Web reports with a Group Above or Matrix style, you can implement the following workaround to get proper alignment:
Open the JSP report in Reports Builder.
Select the Web Source view.
In the Web Source view, locate the section where the summary column is defined, and delete the following line to remove the extra space:
<th class="
summary_column_name
"> </th>
If OracleAS Web Cache is configured as SSL-enabled and Oracle HTTP Server is not, then the images in the HTML output of Oracle Reports is not displayed when viewed from Oracle Enterprise Manager 10g. This is because the image URLs mentioned in the HTML output points to OracleAS Web Cache ports, which are SSL-enabled, whereas the request for past job outputs of Oracle Reports from Oracle Enterprise Manager 10g is non-SSL.
To work around this issue, edit the Servlet property of the URL in the targets.xml
file for Reports Server type such that it points to the OracleAS Web Cache port instead of the Oracle HTTP Server port. The targets.xml
file is available at ORACLE_HOME
/sysman/emd
directory.
For example, if your OracleAS Web Cache is SSL-enabled and the listening port number is 443
, then the Servlet property of the URL for the Reports Server target in the targets.xml
file should be as shown in the following example:
<Target TYPE="oracle_repserv" …..> ...... <Property NAME="Servlet" VALUE="https://xyz.mycompany.com:443/reports/rwservlet"/> ...... </Target>
If you use Acrobat Reader 7.0 to view multibyte and unicode PDF reports that use enhanced font subsetting feature (default) and the report size is very large, then some of the characters displayed will not be aligned properly.
To work around this issue, you can do either of the following:
Set the environment variable REPORTS_ENHANCED_SUBSET
to NO
to revert to the Type 3 font subsetting implementation used in releases prior to Oracle Reports 10g Release 2 (10.1.2).
Use Acrobat Reader 6.0 or earlier.
PL/SQL compilation may fail if you use SQL constructs in your reports and if the following conditions are present:
The SQL constructs were introduced in Oracle Database versions after 9.0.1, for example, ROW_NUMBER()
.
The SQL constructs are used in client side PL/SQL procedures.
To work around this issue, you can do any of the following:
Use Oracle Database Release 10.1.0.4 or later.
Move those SQL constructs to the server-side stored procedures.
Use the SQL constructs within SQL queries directly instead of procedures.
If any of the following conditions are present, then the text in the Paper Design view of Reports Builder may display in an incorrect color:
A text object includes multiline text, which wraps beyond the first line.
The text object's Contains HTML Tags property is set to Yes.
More than one color is applied to different parts of the multiline text.
Note: This issue is shown in the Paper Design view only. The report output in all other output formats show correct colors. |
Ensure that the REPORTS_DEFAULT_DISPLAY
and LDR_CNTRL
variables are set to the following in the reports.sh
file:
LDR_CNTRL=MAXDATA=0x80000000; export LDR_CNTRL REPORTS_DEFAULT_DISPLAY=NO; export REPORTS_DEFAULT_DISPLAY
If the LDR_CNTRL
variable is not set, an "Unable to allocate heap
" message may appear if you run Reports executables. For example, if you run rwrun.sh
, the following message appears if the LDR_CNTRL
variable is not set:
Unable to alloc heap of requested size, perhaps the maxdata value is too small
REPORTS_DEFAULT_DISPLAY
must be set to NO because AIX JDK 1.4.2 does not support the headless option.
If the REPORTS_DEFAULT_DISPLAY
variable is not set to NO, then some Reports executables do not operate. For example, if you run rwrun.sh
and the REPORTS_DEFAULT_DISPLAY
variable is not set to NO, then a core dump and a java core dump are created. Additionally, if you run rwclient.sh
, a message similar to the following appears:
REP-0178: Cannot connect to Reports Server repserver_name
Out of the box Reports In Process server will not work if you try to run the demos (test.rdf). You will get following error:
REP-3000: Internal error starting Oracle Toolkit
In some of the Oracle Business Intelligence and Oracle Application Server Forms Services installations, OC4J_BI_Forms
service keeps restarting frequently after the install. To resolve this issue, you need to perform a post install setup step. Ensure that the DISPLAY environment variable is set correctly in the following configuration file:
$ORACLE_HOME/opmn/conf/opmn.xml
For process-type OC4J_BI_Forms
, the default DISPLAY
entry is as follows:
<variable id="DISPLAY" value="localhost:0"/>
You need to change the default DISPLAY
entry to a computer with a valid X server. For example, to use the X server running on myserver:0.0
, you need to change the following:
<variable id="DISPLAY" value="myserver:0.0"/>
After this change, run opmnctl reload
and restart the OC4J_BI_Forms
instance. One more way to fix this issue is to define a valid DISPLAY
value in the $ORACLE_HOME/bin/reports.sh
script:
DISPLAY=myserver:0.0; export DISPLAY
This section describes vendor-specific issues and their workarounds for Oracle Reports. It includes the following topics:
Section 17.2.1, "Underlines Do Not Display in HTMLCSS Output in Browser"
Section 17.2.2, "JSP-Based Web Report with Large Number of Columns Generates JSP Compilation Error"
In HTMLCSS output, underlines may not display in the browser if you use a custom style for a field object and apply both background color and underline as part of the style, as shown in the following example:
.ReportLevel {text-decoration:underline;color:blue; background-color:yellow}
This is a browser limitation. The browser cannot display underlines, with absolute positioning, for the fields that have both underline and background color applied to them.
When you run a JSP-based Web report with more than 149 columns, you may encounter the oracle.jsp.provider.JspCompileException
error, as shown in the following example:
500 Internal Server Error OracleJSP: oracle.jsp.provider.JspCompileException: Errors ... 6764 code too large for try statement catch( Throwable e) {18 code too large public void _jspService(HttpServletRequest request, HttpServletResponse response) throws java.io.IOException, ServletException
This occurs due to a limitation in the Java language that does not enable compilation of Java files with large methods.
This section describes Globalization Support issues and their workarounds for Oracle Reports. It includes the following topics:
Section 17.3.1, "Images Do Not Display Correctly in Turkish Environment"
Section 17.3.3, "Multibyte Reports Containing Oracle Object Types Hang Report Builder"
Section 17.3.5, "ENVID Ignored While Detecting Duplicate Job"
Section 17.3.6, "Reports Engine Fails When NLS_LANG is Specified As JA16SJISTILDE or JA16EUCTILDE"
If you are running reports that include images and use advanced imaging in Turkish environments (when NLS_LANG
is set to TURKISH_TURKEY.TR8MSWIN125
or TURKISH_TURKEY.WE8ISO8859P9
), then set the environment variable REPORTS_OUTPUTIMAGEFORMAT=[PNG|GIF]
.
Alternatively, you can control the value in the reports request using the command-line keyword, OUTPUTIMAGEFORMAT=[PNG|GIF}
.
When you deploy reports created with Reports Builder on Windows to a Solaris or Linux Reports Server that has NLS_LANG
set to JA16EUC
, the PDF font mappings will not work. This happens if any one of the following fonts is used in the PostScript font mapping entry:
"<MS Mincho in JP>"..... "<MS PMincho in JP>".....
To work around this issue, you must perform one of the following tasks:
Set NLS_LANG
to JA16SJIS
.
Use MS Gothic
instead of MS Mincho
in PostScript font mappings when creating the reports.
Reports Builder may stop responding when you run a multibyte report containing an embedded Oracle Object type. This will be fixed in a future patch set.
This is a known issue.
Oracle Reports status messages on the Job Status page in Application Server Control Console may contain invalid characters if the middle tier character set, NLS_CHARACTERSET
(the third field of NLS_LANG
) does not correspond to the encoding of the Reports Servlet response for the servlet locale.
Note: The middle tier's default encoding can be different from the Servlet's encoding. For example, when you setLANG to ja or ja_JP.eucJP , the default middle tier system encoding is EUC . However, in this locale, Reports Servlet messages are encoded in Shift_JIS . This is because default encoding for ja_JP is Shift_JIS in the servlet.
|
Oracle Enterprise Manager 10g converts the messages from the middle tier's NLS_CHARACTERSET
to UTF8
resulting in invalid characters in the status messages on the Job Status page. For example, the Reports Servlet messages are encoded in Shift_JIS
when the middle tier runs with LANG
set to ja
and NLS_LANG
set to JAPANESE_JAPAN.JA16EUC
. However, Oracle Enterprise Manager 10g assumes that the original message is in JA16EUC
, and converts it to UTF8
, which results in the display of invalid characters in the status messages.
When detecting a new incoming request for a duplicate job where the job request includes the TOLERANCE
keyword, Reports Server ignores the value of the
ENVID
keyword. As a result, the job is marked duplicate of a previous job that was submitted with the same values for all keywords except ENVID
.
The following example illustrates this issue:
Report Request | Report | ENVID | TOLERANCE | Output |
---|---|---|---|---|
1 | Japanese.rdf
|
JA
|
10
|
As expected |
2 | Arabic.rdf
|
UTF
|
10
|
As expected |
3 | Arabic.rdf
|
AR
|
10
|
Same as request 2 (incorrect) |
4 | Japanese.rdf
|
JA
|
10
|
Same as request 1 (correct) |
In this example, request 4 is correctly marked as a duplicate of request 1 as both the requests use the same values for all keywords, including the ENVID
keyword. However, request 3 is incorrectly marked as duplicate of request 2 because both requests use the same values for all keywords, except the ENVID
keyword. As a result, the changed ENVID
will not be accepted in request 3.
To work around this issue, either do not specify TOLERANCE
on the command line or specify a dummy user parameter in the job request to differentiate the job requests in duplicate job detection.
Executing the following command when the NLS_LANG
environment variable is set to JA16SJISTILDE
or JA16EUCTILDE
causes the Reports Engine to crash on the AIX platform:
ORACLE_HOME/bin/rwrun.sh report=test.rdf destype=file desformat=pdf desname=test.pdf
The following error message is displayed:
Error: Couldn't find the display information
The Japanese character sets JA16SJISTILDE
and JA16EUCTILDE
are supported on other platforms (such as Solaris, Linux, Windows, and HP-UX).
To resolve this issue on AIX platforms, set NLS_LANG
to JA16SJIS
or JA16EUC
instead of JA16SJISTILDE
or JA16EUCTILDE
. However, if this workaround is implemented, the Java application issue of FULLWIDTH TILDE cannot be solved. FULLWIDTH TILDE is displayed as WAVE DASH in Oracle Reports.