Today while I was working on one of RDF report used in Oracle Applications, I face this problem and I was clueless what to do. I searched on the internet with error message and it was saying some thing which is not at all related to report. The error message reflect some issue with the server configs.
Since same reports works fine for some of the order then I realized some thing must be wrong in my report only.
Detailed Error Log -
+---------------------------------------------------------------------------+
Custom Application: Version : UNKNOWN
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
C_CC_RETURN_ACK module: Cust Callcenter Receipt Acknowledgment
+---------------------------------------------------------------------------+
Current system time is 13-NOV-2013 18:22:34
+---------------------------------------------------------------------------+
+-----------------------------
| Starting concurrent program execution...
+-----------------------------
Arguments
------------
P_HEADER_ID='64749637'
P_TO_EMAIL_ADDRESS='tauseefcafe@gmail.com'
------------
Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing
APPLLCSP Environment Variable set to :
Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.AL32UTF8
'.,'
stat_low = 6
stat_high = 0
emsg:was terminated by signal 6
Enter Password:
#
# An unexpected error has been detected by HotSpot Virtual Machine:
#
# SIGSEGV (0xb) at pc=0xf68cbd7e, pid=15307, tid=3449813904
#
# Java VM: Java HotSpot(TM) Server VM (1.4.2_14-b05 mixed mode)
# Problematic frame:
# C [libca.so.0+0x2dd7e] caupzsearch+0x1e
#
# An error report file with more information is saved as hs_err_pid15307.log
#
# If you would like to submit a bug report, please visit:
# http://java.sun.com/webapps/bugreport/crash.jsp
#
Report Builder: Release 10.1.2.3.0 - Production on Wed Nov 13 18:22:36 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Program was terminated by signal 6
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 44707475.
Review your concurrent request log and/or report output file for more detailed information.
+---------------------------------------------------------------------------+
Executing request completion options...
Output file size:
0
Output is not being printed because:
The print option has been disabled for this report.
+------------- 1) PUBLISH -------------+
Disabling requested Output Post Processing. Nothing to process. The output of the request is zero byte.
+--------------------------------------+
Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 13-NOV-2013 18:22:38
+---------------------------------------------------------------------------+
I check all the queries and found the issue. One of the inline queries was returning more that one number of records.
Solution - Fixed the query that all so that it give only one record for the given order, issue is gone.
Since same reports works fine for some of the order then I realized some thing must be wrong in my report only.
Detailed Error Log -
+---------------------------------------------------------------------------+
Custom Application: Version : UNKNOWN
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
C_CC_RETURN_ACK module: Cust Callcenter Receipt Acknowledgment
+---------------------------------------------------------------------------+
Current system time is 13-NOV-2013 18:22:34
+---------------------------------------------------------------------------+
+-----------------------------
| Starting concurrent program execution...
+-----------------------------
Arguments
------------
P_HEADER_ID='64749637'
P_TO_EMAIL_ADDRESS='tauseefcafe@gmail.com'
------------
Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing
APPLLCSP Environment Variable set to :
Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.AL32UTF8
'.,'
stat_low = 6
stat_high = 0
emsg:was terminated by signal 6
Enter Password:
#
# An unexpected error has been detected by HotSpot Virtual Machine:
#
# SIGSEGV (0xb) at pc=0xf68cbd7e, pid=15307, tid=3449813904
#
# Java VM: Java HotSpot(TM) Server VM (1.4.2_14-b05 mixed mode)
# Problematic frame:
# C [libca.so.0+0x2dd7e] caupzsearch+0x1e
#
# An error report file with more information is saved as hs_err_pid15307.log
#
# If you would like to submit a bug report, please visit:
# http://java.sun.com/webapps/bugreport/crash.jsp
#
Report Builder: Release 10.1.2.3.0 - Production on Wed Nov 13 18:22:36 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Program was terminated by signal 6
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 44707475.
Review your concurrent request log and/or report output file for more detailed information.
+---------------------------------------------------------------------------+
Executing request completion options...
Output file size:
0
Output is not being printed because:
The print option has been disabled for this report.
+------------- 1) PUBLISH -------------+
Disabling requested Output Post Processing. Nothing to process. The output of the request is zero byte.
+--------------------------------------+
Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 13-NOV-2013 18:22:38
+---------------------------------------------------------------------------+
I check all the queries and found the issue. One of the inline queries was returning more that one number of records.
Solution - Fixed the query that all so that it give only one record for the given order, issue is gone.
No comments :
Post a Comment