While i convert report text to pdf i got error

Current system time is 09-JUL-2007 14:28:38
+---------------------------------------------------------------------------+

+-----------------------------
Starting concurrent program execution...
+-----------------------------
Arguments
------------
P_FROM_TRX_DATE='01-JUL-2007'
P_TO_TRX_DATE='15-JUL-2007'
P_FROM_CURRENCY_NO='KWD'
P_TO_CURRENCY_NO='KWD'
------------
Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.AR8ISO8859P6
'.,'
X connection to deverp:0.0 broken (explicit kill or server shutdown).
Report Builder: Release 6.0.8.25.0 - Production on Mon Jul 9 14:28:39 2007
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Enter Username:
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Program exited with status 1
Concurrent Manager encountered an error while running Oracle*Report for your concurren
t request 299656.
Review your concurrent request log and/or report output file for more detailed information.

+---------------------------------------------------------------------------+
Executing request completion options...

Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 09-JUL-2007 15:15:12
+---------------------------------------------------------------------------+
.
UPDATE

1. Is this issue happen to all requests? (try on active users as an example)
2. Was it working before? If Yes please inform me with the recent changes?
3. Provide the output of the following in Excel sheet in a readable format
replace with the request id that you submitted for the report.
(a)
SELECT NUMBER_OF_COPIES,
NLS_LANGUAGE,
NLS_TERRITORY,
PRINTER,
PRINT_STYLE,
COMPLETION_TEXT,
OUTPUT_FILE_TYPE,
NLS_CODESET,
OUTFILE_NODE_NAME,
OUTFILE_NAME
FROM FND_CONCURRENT_REQUESTS
WHERE REQUEST_ID = <>;
(b)
SELECT PRINTER_STYLE_NAME, SRW_DRIVER, WIDTH, LENGTH, ORIENTATION
FROM FND_PRINTER_STYLES
WHERE PRINTER_STYLE_NAME =
(SELECT PRINT_STYLE
FROM FND_CONCURRENT_REQUESTS
where request_id = <>);
(c)
SELECT PRINTER_DRIVER_NAME,
USER_PRINTER_DRIVER_NAME,
PRINTER_DRIVER_METHOD_CODE,
SPOOL_FLAG,
SRW_DRIVER,
COMMAND_NAME,
ARGUMENTS,
INITIALIZATION,
RESET
FROM FND_PRINTER_DRIVERS
WHERE PRINTER_DRIVER_NAME =
(SELECT PRINTER_DRIVER
FROM FND_PRINTER_INFORMATION
WHERE PRINTER_STYLE =
(SELECT PRINT_STYLE
FROM FND_CONCURRENT_REQUESTS
where request_id = <>)
AND PRINTER_TYPE =
(SELECT PRINTER_TYPE
FROM FND_PRINTER
WHERE PRINTER_NAME =
(SELECT PRINTER
FROM FND_CONCURRENT_REQUESTS
where request_id = <>)))
(d)
SELECT *
FROM FND_ENV_CONTEXT
WHERE CONCURRENT_PROCESS_ID =
(SELECT CONCURRENT_PROCESS_ID
FROM FND_CONCURRENT_PROCESSES A, FND_CONCURRENT_REQUESTS B
WHERE B.CONTROLLING_MANAGER = A.CONCURRENT_PROCESS_ID
AND B.REQUEST_ID = <>)
AND (VARIABLE_NAME IN
('XENVIRONMENT', 'IX_PRINTING', 'ORACLE_HOME', 'LD_LIBRARY_PATH',
'NLS_LANG', 'REPORTS60_NO_DUMMY_PRINTER', 'TK6_PRINT_STATUS',
'TK6_PRINTER', 'TK_PRINTER', 'PRINTER', 'DISPLAY', 'TK_LOCALE',
'PASTA', 'APPLLCSP', 'ORACLE_PRINTER', 'TK_PRINT_STATUS') OR
(VARIABLE_NAME LIKE '%REPORT%' OR VARIABLE_NAME LIKE 'IX_%'));


ISSUE CLARIFICATION
====================
On 11.5.10.2 in Production:
When attempting to submit any PDF report ,
the following error occurs.
ERROR
-----------------------
X connection to deverp:0.0 broken (explicit kill or server shutdown).
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. For any concurrent program change the output format to PDF
2. Submit this concurrent request
3. Face the above error
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot Submit any PDF concurrent Requests.

.
ISSUE VERIFICATION
===================
Verified the issue in the log file as noted below:
LOG FILE
-----------------------
Filename =Logl299966_req.htm
See the following error:
X connection to deverp:0.0 broken (explicit kill or server shutdown).

DATA COLLECTED
===============
Query Results
--------------
NUMBER_OF_COPIES 0
NLS_LANGUAGE AMERICAN AMERICA
NLS_TERRITORY AMERICA
PRINTER noprint
PRINT_STYLE LANDSCAPE
COMPLETION_TEXT "Concurrent Manager encountered an error
OUTPUT_FILE_TYPE PDF
OUTFILE_NAME /d02/appsdev/devcomn/admin/out/DEV_deverp/o299966.out
PRINTER_DRIVER_NAME LANDSCAPEHPLJ4SI
USER_PRINTER_DRIVER_NAME LANDSCAPE for Printer HPLJ4SI
PRINTER_DRIVER_METHOD_CODE
SPOOL_FLAG
SRW_DRIVER HPL
COMMAND_NAME lpr -P$PROFILES$.PRINTER -#$PROFILES$.CONC_COPIES -T"$PROFILES$.TITLE" $PROFILES$.FILEN
AME
ARGUMENTS /eE/e&l1o2a5.45C/e(s0p16.66H/e&k6.75H
INITIALIZATION /eE
DISPLAY deverp:0.0
IX_PRINTING /fnd/11.5.0/resource/ixlib.cfg
IX_RENDERING /fnd/11.5.0/resource/pasta.cfg
NLS_LANG American_America.AR8ISO8859P6
XENVIRONMENT /guicommon6/tk60/admin/Tk2Motif_UTF8.rgb
XML_REPORTS_XENVIRONMENT /guicommon6/tk60/admin/Tk2Motif_UTF8.rgb
.
RESEARCH
=========
Note.252715.1 X Connection To 1.0 Broken - Explicit Kill Or Server Shutdown
Note.230810.1 X Display Server Connection Broken When Printing Reports

Please perform the following:
ACTION PLAN
============
1. Was the PDF reports working before? If Yes please inform me with the recent changes?
2. - Login to the machine where Reports Server is installed.
- From the UNIX command prompt, set the DISPLAY to a valid X Windows session:
setenv DISPLAY :0.0
replace the host name with the ipaddress of the host
- Ensure that DISPLAY was set correctly:
echo $DISPLAY
- Type command "xclock"
Did the clock came up?
3. Try the command (xhost +) in the report server ?
4. Issue the following command on that server
xterm -display .:0.0
or
xterm -display :0.0
Note: the xterm should open a window on the display
:0.0
- verify that a window is open on the display
use the applmgr user not the root user in this step
5. Issue the following command on that server
xdpyinfo -display .:0.0
or
xdpyinfo -display :0.0
Note: the xdpyinfo should show some information about the display
6. In the Application go to HELP > Diagnostic > Examine -
Click on the LOV for Block and choose
$ENVIRONMENT$
Then go to the 'Field' Section and type in 'DISPLAY'
If "There is no field named DISPLAY under $ENVIRONMENT$ block."
Then just Type it then Click on Value
This will show the Forms Server DISPLAY setting
Please update the SR with this value and confirm that it is the correct display
7. Run the request (Prints environment variable values) and put in the parameters
(Display). Please update the SR with this value and confirm that it is the correct
display
8. Does a report in Postscript format run successfully from the OS command line?
a) Login as the applmgr on the host where the concurrent processing server resides
and source the main environment file.
b) Set the DISPLAY environment variable, if not already set by the main environment file.
echo $DISPLAY
DISPLAY=:0.0 ; export DISPLAY
c) Run the "Active Users" report in Postscript format with the ar60runb executable
and the following options.
Provide the apps password an populate the parameters with
the full path of $FND_TOP and $APPLTMP.
ar60runb userid=apps/apps report=/<$FND_TOP>/reports/US/FNDSCURS.rdf batch=yes destype=file
mode=bitmap desname=/<$APPLTMP>/ActUsr.ps des
format=/<8.0.6$oracle_home>/reports60/admin/printer/psl132.prt errfile=//ActUsr.log

ACTION PLAN
============
1. In the file Tk2Motif_UTF8.rgb
change the following line
Tk2Motif*fontMapCs: iso8859-1=UTF8
to
Tk2Motif*fontMapCs: iso8859-1=AR8ISO8859P6
2. In the file Tk2Motif.rgb
add the following line
Tk2Motif*fontMapCs: iso8859-1=AR8ISO8859P6
3. Rebounce the managers and retest the issue and tell me the results


Helpful search results follow from AutoDiagnose:


1. Note 179801.1 Printing and Previewing Arabic Reports using PASTA in Oracle Applications 11i
2. Note 139654.1 Oracle Applications Release 11i with UTF8 FAQ
3. Note 179801.1 Printing and Previewing Arabic Reports using PASTA in Oracle Applications 11i
4. Note 159225.1 PASTA Required For Printing With UTF8 For Any Release of 11. 5 (Pasta ver 2.0.1)
5. Note 115233.1 How To View Web Report containing Arabic Data
6. Note 115232.1 Arabic Decimal Symbol Appears Incorrectly in Web HTML Reports
7. Note 199429.1 Arabic Appears As Question Marks In Reports
The correct font for Arabic is:
Font.Default.Plain=//ADUO.ttf
Font.Default.Bold=//ADUOB.ttf

1 comment:

Sridevi Koduru said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.