Hi All, I am very new to XML Publisher reports and I am facing the following issue in a report - Program was terminated by signal 11 I created the data model in RDF and for this I. Process Locboxes: ARLPLB Program was terminated by signal 11 We were upgrading from 11.5.9 to Release 12.1.2. We have a request set that submits many jobs and one of the jobs submits 'Process Lockboxes'. WHAT IS SIGNAL 11. In layman term, Signal 11 is an obscure way to say that there is hardware problem with the system's memory 'Unaligned memory access' is a message coming back from the UNIX operating system letting you know that an Oracle executable has tried to access memory incorrectly.
Hi All, I am very new to XML Publisher reports and I am facing the following issue in a report - Program was terminated by signal 11 I created the data model in RDF and for this I created the corresponding RTF file.
Hello Jonathan,
As I mentioned in a separate conversation I had to build smcpp as I am trying to run it on a system with GLIBC_2.12 (for which there are not executables available). I have used gcc/4.9.3, python/3.6.1 and mpfr/3.1.5 (as mpfr version 3.1.5 is installed in a non default location I had to modify mpreal.h so that it would find the correct header mpfr file). The software compiled OK (“python3 setup.py build 2>&1 | tee IDRE_setupbuild.log “and “python3 setup.py install —prefix=/u/local/apps/python/3.6.1 2>&1 | tee IDRE_setupinstall.log”) however when I try to execute it I get a Segmentation Fault. I have run the core.XXXX file generated under gdb (gdb python3 core.19167) to try to get a stack trace as you suggest. However the only helpful information that I seem to get is:
Program terminated with signal 11, Segmentation fault.
Oracle Program Was Terminated By Signal 11
I think that the problem is that while it found the correct header files for mpfr is still linking to the system (older) mpfr library. How would I change the setup so that I can make it look for the mpfr in the non standard location? Perhaps instead of modifying mpreal.h there is a way to just modify the setup.py so that it looks in non default location for libraries and header files?
Thanks,
RD
This section describes common problems and solutions. It contains the following topics:
D.1.1 Hanging Report Requests
When running report requests with Reports Server, the report request may 'hang' for various reasons. This can lead to stability issues if not noticed in time. This section highlights such scenarios, explains the issues, how you can identify such patterns, take corrective measures, and gather sufficient information to raise such issues with Oracle Support Services.
To begin with, it is important to understand how Reports Server identifies duplicate jobs. When a job is submitted to Reports Server, it checks whether a similar job exists in its job queue. If it finds a currently running job that is the same as the submitted job, then Reports Server considers the submitted job a duplicate job and the currently running job as the master job. Reports Server does not execute the duplicate job; instead, it waits for the master job to finish and passes the same output to the duplicate job. Although an idle engine is available, the duplicate job is not submitted to the engine. This is expected behavior and does not mean that the request is hanging.
In addition to the Solutions provided in this section, refer to Section 24.4, 'Tuning Reports Server Configuration'.
Note:
Scalability improvements in Oracle Reports 10g Release 2 (10.1.2) and 11g Release 1 (11.1.1) improve the stability of Reports Server to ensure report requests complete successfully.
Problem 1
Master job 'hangs' before finishing.
Solution 1
If a master job hangs for some reason, then the next duplicate job in line is made the master job.
Check the
engineResponseTimeOut attribute in the engine element of the rwserver .conf file (see Section 8.2.1.9, 'engine'). Set this attribute judiciously to avoid server instability. This enables Reports Server to automatically detect and recover from this type of hanging situation. You can also use the showjobs command to end the hanging job and allow Reports Server to continue processing other requests. For information about the showjobs command, see Section A.8.8, 'SHOWJOBS'.
For example, consider a scenario where you have a set of reports. The largest report takes a maximum of 5 minutes to run. In this case, you can set
engineResponseTimeOut to 5 minutes.
Notes:
Despite setting the
engineResponseTimeOut attribute (or ENGINERESPONSETIMEOUT keyword on the command line) judiciously, if you still encounter instability and crashes, perform the following steps to report the problem to Oracle Support Services:
Problem 2
Reports Server stops responding or crashes when running report requests, exhibited by any of the following:
Solution 2
Restart Reports Server to attempt to recover from this problem. If the problem persists, report it to Oracle Support Services with the following information:
Problem 3
The in-process Reports Server fails to start and the browser displays the following message while trying to run a report with the in-process Reports Server:
REP-52266: The in-process Reports Server failed to start.
When the standalone server is started, it shuts down immediately.
Solution 3
Enable tracing (see Section 24.3.7, 'Tracing Report Execution') and start the in-process Reports Server. The default Reports Server
rwserver_diagnostic.log file should capture the actual cause of the problem:
Problem 4
Reports Engine crashes or hangs when running report requests.
Solution 4
Case 1: Consider the scenario where Reports Server is running thousands of reports every day, printing reports, and publishing them to the Web. In this scenario, the browser may wait for the response and eventually time out. Even Web commands to see the job queue may not work.
Turn on tracing (see Section 24.3.7, 'Tracing Report Execution') and when this problem occurs, take a thread dump by running the
kill -3 server_pid command on Solaris (as described under Solution 2. The following lines of code are the result of running the kill -3 server_pid command. These lines indicate a hang when Reports Server is trying to write the report to a network drive:
The trace file for this scenario is as follows:
In this trace file, note the following:
After this there is no update on the job. The
Finished successfully line is not present. This indicates that there is a problem with the job.
The following example shows a trace file for a job that finished successfully:
In this trace file, after formatting the page 1, note the following:
These lines were not present in the first example. All jobs must contain these lines in the Reports Server trace files. A missing event or abrupt end means that the job has not finished successfully and is a potential cause for the hang.
Case 2: Consider the scenario where the following error displays:
REP-56048: Engine rwEng-0 crashed, job Id: 17
In this scenario, check the Reports Server and engine trace files. A typical crash resembles the following in the Reports Server trace file:
In the engine trace file, the last few lines of the crash trace resemble the following:
Note:
The engine trace file ends abruptly whenever the engine crashes.
Action: Identify the report that is causing the engine crash. You can do this by identifying the job ID. In the preceding examples, the engine crashed while running
jobid 17 . In the server trace file, search for the jobid = 17 Get command line string. This line contains the complete command line that includes the report name also. Enable tracing and engine diagnosis. Run the problematic report multiple times to reproduce the crash. When the crash is reproduced, pass on the trace files and diagnosis output to Oracle Support Services for analysis.
D.1.2 Reports Server Activity Generates Error REP-50125REP-50125 is a common error message issued in multiple situations involving Reports Server:
REP-50125: Caught exception: {0}
Cause: Oracle Reports has caught an internal exception.
Action: Contact Oracle Support Services for additional assistance.
Problem 1
The Cause and Action in the help topic for
REP-50125 do not contain enough information to effectively identify and diagnose the problem.
Solution 1
With Oracle Reports 10g Release 2 (10.1.2), the following new error messages addressed specific scenarios to provide focused troubleshooting assistance in the Cause and Action exposed in the help topics:
Problem 2
REP-50125 displays when starting up Reports Server.
Solution 2
Refer to Note 289748.1 on Oracle MetaLink at
http://metalink.oracle.com : Troubleshooting Problems When Starting Up Reports Server.
Problem 3
REP-50125 displays when running report requests.
Solution 3
Refer to Note 290827.1 on Oracle MetaLink at
http://metalink.oracle.com : Troubleshooting Failed Reports Requests Issued Against Reports Server.
Problem 4
REP-50125 displays with segmentation violation when starting Reports Server on SLES-8/UnitedLinux 1.0.
Solution 4
With Oracle Reports 10g Release 2 (10.1.2), SLES8 and SLES9 were supported. However, Oracle Reports 11g Release 1 (11.1.1) does not support UnitedLinux 1.0, so you cannot use this platform to run report requests.
Problem 5
REP-50125 displays when running reports on Linux with openmotif.
Solution 5
Only openmotif 2.1.30 (not higher) is supported for Oracle Reports 6i, 9i, and 10g on Linux.
D.1.3 Long Running Report Failure with Oracle Reports Servlet
Long running report requests submitted through Oracle Reports Servlet (
rwservlet ) may not succeed or cause crashing/hanging engines and timeouts on dependent AS components.
Problem
A report that runs for a long time with
rwservlet does not finish.
Solution
Perform the following checks:
D.1.4 Fonts Do Not Display Consistently On Different Platforms
Deploying reports on multiple platforms may result in font issues.
Problem
When you deploy a report on multiple platforms, font rendering and mapping is not consistent across all platforms.
Solution
With Oracle Reports 10g Release 2 (10.1.2), this issue was addressed in new documentation in the following chapters:
D.1.5 Running Reports on UNIX Platforms Generates REP-56048REP-56048 is a common error message issued when running a report (for example, using rwservlet , rwclient , or through Oracle Forms) on UNIX. The Reports Server passes the job to a Report Engine that is responsible for running the report. The Report Engine crashes, resulting in this error:
REP-56048: Engine {0} crashed
Cause: Reports Server detected the specified engine crashed.
Action: Reports Server should restart another engine. Report the problem to Oracle Support Services with the test case that causes engine crash.
Refer to the solutions below and to Solution 4 in Section D.1.1, 'Hanging Report Requests' to attempt to resolve the problem. If REP-56048 persists, perform the following steps to report the problem to Oracle Support Services:
Problem 1
REP-56048 displays when running reports on UNIX platforms, and character sets defined in NLS_LANG are other than WE8ISO8859P1 or IW8ISO8859P8 .
Solution 1
Modify entries in
Tk2Motif.rgb for mapping Oracle character set names and XLFD's CHARSET_REGISTRY to CHARSET_ENCODING (the last two fields; for example, iso8859-1 ). For more information, see:
You can also try to run this report with Reports Runtime (
rwrun ) to verify the environment settings before running it through the Report Engine.
Problem 2
REP-56048 displays when running reports on UNIX platforms, and DISPLAY environment variable is not set.
Solution 2
With Oracle Reports 10g Release 1 (9.0.4), the
REPORTS_DEFAULT_DISPLAY environment variable removes the dependency on the DISPLAY environment variable. By default, REPORTS_DEFAULT_DISPLAY=YES . Make sure that REPORTS_DEFAULT_DISPLAY has not been set to NO .
For more information, see Section B.1.42, 'REPORTS_DEFAULT_DISPLAY'.
Problem 3
REP-56048 displays when tracing is enabled while running a big report.
Solution 3
If tracing is enabled, Reports Engine might crash for reports with large output. This may be due to the size of the trace file and that there was insufficient disk space, memory, or processor capacity available to create it. To avoid this error, enable engine diagnostic logging only by modifying the
engine element to include the diagnosis property in the rwserver .conf file (see 'Properties' in Section 8.2.1.9, 'engine'), when diagnostic information is required to troubleshoot a problem with a report. You can also restrict the trace file generated using the traceModule attribute of the trace element in the rwserver .conf configuration file.
For general information about tracing, see Section 24.3.7, 'Tracing Report Execution'.
Problem 4
REP-56048 displays when DISTRIBUTE=YES on UNIX.
Solution 4
Distribution fails on UNIX if the
PRINTER environment variable is not set to a valid printer when one of the destinations specified in the distribution file is a printer. Set the following environment variables:
In
ORACLE_INSTANCE/config/FRComponent/frcommon/guicommon/tk/admin/uiprint.txt, add the following line:
For more information on report distribution, see Chapter 20, 'Creating Advanced Distributions'.
Problem 5
REP-56048 displays when printing a report on UNIX.
Solution 5
Oracle Reports uses the shell script
rwlpr.sh for printing on UNIX. Directly modifying this file is not supported. Please contact Oracle Support Services for assistance.
For more information on printing on UNIX, see Chapter 10, 'Printing on UNIX with Oracle Reports'.
Problem 6
REP-56048 displays when running a report containing graphics on UNIX.
Solution 6
This error may result if Oracle Reports is linked against a version of Motif other than the operating system's default. Refer to the Oracle Reports chapter in the Oracle Fusion Middleware Release Notes for Microsoft Windows for the correct version of Motif to which to link.
Problem 7
REP-56048 displays when generating delimited report output for a matrix report.
Solution 7
Generate the report output to DelimitedData (
DESFORMAT=DELIMITEDDATA ) or spreadsheet (DESFORMAT=SPREADSHEET ) output instead of Delimited. DelimitedData supports large reports, but the output in Microsoft Excel displays only data (as defined by the report data model), no layout information. To generate report output that preserves the formatting defined in report layout, use the output format DESFORMAT=SPREADSHEET .
For more information on delimited and spreadsheet output, see 'About delimited output' and 'About spreadsheet output' in the Oracle Reports online Help (and also in the 'Advanced Concepts' chapter in the Oracle Reports Building Reports manual). Also see Section A.5.27, 'DESFORMAT'.
Problem 8
REP-56048 displays when running a report through the Reports Engine when none of the previous solutions resolve the problem.
Solution 8
This error may be related to your environment settings or caused by the report itself. By checking the Oracle Reports Servlet (
rwservlet ) showjobs page for your Reports Server, you should be able to determine the job that resulted in the error. If you are on a UNIX machine, there should be a core dump created in your environment. To facilitate searching for related bugs, extract a stack trace from this core dump. Note that the executable should be java rather than rwrun .
In previous releases, to get a stack trace from the core file, you ran a debugger on the runtime component. This is still applicable if you are able to reproduce the problem with only the
rwrun component. However, if the crash occurs only through the Reports Server, then the engine will be called using a Java wrapper, and you must run the debugger on the Java executable. This will automatically load any Oracle Reports libraries.
For example:
This example is for
dbx . Once you have the stack trace, you will be able to search Oracle MetaLink at http://metalink.oracle.com for any related issues using the last few calls in the stack.
If a particular job seems to be causing the problem, then the next step would be to try running that report with
rwclient and rwrun . Running with rwclient removes the Web component from the environment. Running with rwrun is equivalent to bypassing the Reports Server and running with just the engine.
D.1.6 Font Issues with Right-to-Left Languages
Bidirectional support enables you to display report output in either a left-to-right or right-to-left orientation, depending on the requirements of your audience. Font issues with right-to-left languages generate imperfect report output.
Problem
Misalignment of right-aligned text and limitations requiring fixed width fonts.
Solution
With Oracle Reports 10g Release 2 (10.1.2), this issue was addressed with improvements to PDF output with font subsetting enabled for languages that read right to left (such as Hebrew and Arabic), ensuring that text will be accurately right-aligned. However, on UNIX platforms, you may see some misalignment for right-aligned text.
To resolve font issues related to right-to-left text, refer to the information in the following sections:
D.1.7 Errors When Running Reports from Oracle Forms Using RUN_REPORT_OBJECT
The most secure approach for calling Oracle Reports from Oracle Forms on the Web is to use Oracle Reports Services in combination with
RUN_REPORT_OBJECT . For detailed information about using RUN_REPORT_OBJECT to call Oracle Reports from Oracle Forms, refer to the Oracle Application Server 10g Integrating Oracle Reports in Oracle Forms Services Applications white paper on OTN (http://otn.oracle.com/products/forms/pdf/10g/frm10gsrw10g.pdf) .
Also refer to Oracle Fusion Middleware Forms Services Deployment Guide.
Problem 1
RUN_REPORT_OBJECT generates the following error:
FRM-41214: Unable to run report .
Solution 1
When deploying a report over the Web with output to be shown in the browser window,
DESTYPE should be set to CACHE , not SCREEN or PREVIEW . To display the output of report in the browser use WEB.SHOW_DOCUMENT , rather than RUN_REPORT_OBJECT .
Problem 2
RUN_REPORT_OBJECT generates the following error:
FRM-41213: Unable to connect to the report server server_name .
Solution 2
Check the following:
Problem 3
RUN_REPORT_OBJECT generates the following error:
REP-503 You did not specify the name of a report .
Solution 3
Make sure that the report name is specified in the Property Inspector of the Report object in the Oracle Forms Object Navigator.
Problem 4
Unable to run report from a form and pass parameter from a form to the report.
Solution 4
Check the following:
If the issue persists, enable report tracing (see Section 24.3.7, 'Tracing Report Execution') to pinpoint the source of the problem.
Problem 5
Using a report Parameter Form (
PARAMFORM=YES ) in conjunction with RUN_REPORT_OBJECT fails with 'Internal Server Error '.
Solution 5
Refer to the Oracle Forms Services - Using Run_Report_Object() to call Reports with a parameter form white paper on OTN (
http://otn.oracle.com/products/forms/pdf/10g/frmrepparamform.pdf ).
D.1.8 Displaying Report Output in Microsoft Excel
Generating a report to delimited output to display in Microsoft Excel is a common requirement, which can be accomplished in a number of ways. Users are often unsure of which method to choose.
Problem
Which delimited output solution is best for given requirements?
Solution
Depending on your report definition and output display requirements, choose the appropriate method for generating your report to delimited output for Microsoft Excel:
For detailed information on spreadsheet output and delimited output, see the Oracle Reports online Help and Oracle Reports Building Reports manual.
D.1.9 Report Containing User Exit Fails on UNIX
User exits may exist in reports developed in prior releases of Oracle Reports.
Note:
With Oracle Reports 10g, you can call Java methods using the ORA_JAVA built-in package and the Java Importer. This reduces the need to have user exits in a report and allows for a more open and portable deployment. You may also use the ORA_FFI built-in package, which provides a foreign function interface for invoking C functions in a dynamic library. With the availability of these built-in packages, the use of user exits is deprecated in Oracle Reports, though makefiles are still be supplied to permit you to continue to work with existing user exits.
Problem
A report that contains a user exist fails when run on UNIX.
Solution
On UNIX, Reports Builder (
rwbuilder ) and Reports Runtime (rwrun ) dynamically load the user exit library to successfully run reports that contain user exits. When running reports through Reports Server (rwserver ), you must add the following environment variable in rwengine.sh to load the user exit library:
D.1.10 Printing and Font Errors When Using In-process Reports Server
The in-process Reports Server does not recognize the default printer of a user currently logged on to Windows. This is because the service that runs the in-process Reports Server is logged on as the Local System.
Problem
Any of the following:
Solution
To work around all these issues:
Emsg Was Terminated By Signal 11
The pros and cons of running an in-process Reports Server are explored in Chapter 2, 'Understanding the Oracle Reports Services Architecture'. For additional information, see Section 8.3, 'Oracle Reports Servlet Configuration File' (server and inprocess parameter descriptions).
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |