Thalai Muthu Oracle Apps DBA: July 2012

25 July 2012

[179747:RT11265929] java.io.FileNotFoundException: A file or directory in the path name does not exist

Xml Publisher not Generating the XML the Output

Below the Output postp rocesser Concurrent :-

Error :-

Template code: BC_GL_ANALYSIS

Template app:  SQLGL

Language:      en

Territory:     00

Output type:   EXCEL

[7/25/12 10:36:30 AM] [UNEXPECTED] [179747:RT11265929] java.io.FileNotFoundException: /bcprodfm/bcprodfm/BCPROD/apps/apps_st/comn/temp/xdoiXhQEQmd75072512_1036300871.fo (A file or directory in the path name does not exist.)

        at java.io.FileOutputStream.<init>(FileOutputStream.java:179)

        at java.io.FileOutputStream.<init>(FileOutputStream.java:131)

        at oracle.apps.xdo.common.tmp.TmpFile.createTmpFileJDK118(TmpFile.java:146)

        at oracle.apps.xdo.common.tmp.TmpFile.createTmpFile(TmpFile.java:113)

        at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:987)

        at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)

        at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1665)

        at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:975)

        at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5936)

        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3459)

        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3548)

        at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:285)

        at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:173)

[7/25/12 10:36:30 AM] [179747:RT11265929] Completed post-processing actions for request 11265929.

[7/25/12 10:37:55 AM] [GSMServiceController:179747] Received shutdown request.

[7/25/12 10:37:55 AM] [GSMServiceController:179747] Preparing to shutdown service.

[7/25/12 10:37:55 AM] [GSMServiceController:179747] Stopping all Service Threads.

[7/25/12 10:37:55 AM] [OPPServiceThread0] Preparing to shut down service thread.

[7/25/12 10:37:55 AM] [OPPServiceThread1] Preparing to shut down service thread.

[7/25/12 10:40:18 AM] [OPPServiceThread1] Post-processing request 11265932

Solution :-

invalid Temporary directory path in the XML publisher administrator.(Administration-> Properties-> General

Temp Directory I Given correct Location

Result:-
My concurrent output created

REP-0004: Warning: Unable to open user preference file.

REP-0004: Warning: Unable to open user preference file.

Concurrent Log output File:-
+---------------------------------------------------------------------------+

General Ledger: Version : 12.0.0

BC_GL_ANALYSIS module: BC GL ANALYSIS

+---------------------------------------------------------------------------+

Current system time is 25-JUL-2012 09:48:06

+---------------------------------------------------------------------------+

+-----------------------------

| Starting concurrent program execution...

+-----------------------------

Arguments

------------

P_SET_OF_BOOKS_ID='2021'

P_CHART_OF_ACCOUNTS_ID='50348'

P_START_PERIOD='JUL-12-13'

P_END_PERIOD ='JUL-12-13'

P_MIN_FLEX ='511.10502.19001.5703001.0000.000.000.0000'

P_MAX_FLEX ='511.10502.19001.5703001.9999.999.999.0000'

------------

Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :

American_America.US7ASCII

'.,'

Enter Password:

REP-0004: Warning: Unable to open user preference file.

MSG-00001: Test 1

MSG-00001: SET_OF_BOOKS_ID 2021

MSG-00002: P_CHART_OF_ACCOUNTS_ID 50348

MSG-00003: START_EFFECTIVE_PERIOD_NUM 20130007

MSG-00004: END_EFFECTIVE_PERIOD_NUM 20130007

MSG-00011: Before Start1

MSG-00012: Before Start2

MSG-00015: Before Start5

MSG-00016: Before Start6

MSG-00018: 50348

MSG-00019: CC.SEGMENT1||'

'||CC.SEGMENT2||'

'||CC.SEGMENT3||'

'||CC.SEGMENT4||'

'||CC.SEGMENT5||'

'||CC.SEGMENT6||'

'||CC.SEGMENT7||'

'||CC.SEGMENT8

MSG-00020: CC.SEGMENT1 = '511' AND CC.SEGMENT2 = '10502' AND CC.SEGMENT3 = '19001' AND CC.SEGMENT4 = '5703001' AND CC.SEGMENT5 BETWEEN '0000' AND '9999' AND CC.SEGMENT6 BETWEEN '000' AND '999' AND CC.SEGMENT7 BETWEEN '000' AND '999' AND CC.SEGMENT8 = '0000'

MSG-00021: CC.SEGMENT4

MSG-00022: CC.SEGMENT1

MSG-00201: CC.SEGMENT1 = '511' AND CC.SEGMENT2 = '10502' AND CC.SEGMENT3 = '19001' AND CC.SEGMENT4 = '5703001' AND CC.SEGMENT5 BETWEEN '0000' AND '9999' AND CC.SEGMENT6 BETWEEN '000' AND '999' AND CC.SEGMENT7 BETWEEN '000' AND '999' AND CC.SEGMENT8 = '0000'

MSG-00202: CC.SEGMENT1||'

'||CC.SEGMENT2||'

'||CC.SEGMENT3||'

'||CC.SEGMENT4||'

'||CC.SEGMENT5||'

'||CC.SEGMENT6||'

'||CC.SEGMENT7||'

'||CC.SEGMENT8

MSG-00203: CC.SEGMENT4

MSG-00204: CC.SEGMENT1

MSG-00205: 511.10502.19001.5703001.0000.000.000.0000

MSG-00206: 511.10502.19001.5703001.9999.999.999.0000

MSG-00207: JUL-12-13

MSG-00208: JUL-12-13

Report Builder: Release 10.1.2.3.0 - Production on Wed Jul 25 09:48:08 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.
+---------------------------------------------------------------------------+

Start of log messages from FND_FILE

+---------------------------------------------------------------------------+

End of log messages from FND_FILE

+---------------------------------------------------------------------------+

Executing request completion options...

+------------- 1) PUBLISH -------------+

Beginning post-processing of request 11265730 on node PBCIBMS22 at 25-JUL-2012 09:48:16.

Post-processing of request 11265730 failed at 25-JUL-2012 09:48:18 with the error message:

One or more post-processing actions failed. Consult the OPP service log for details.

+--------------------------------------+

+------------- 2) PRINT -------------+

Not printing the output of this request because post-processing failed.

+--------------------------------------+

Finished executing request completion options.

+---------------------------------------------------------------------------+

Concurrent request completed

Current system time is 25-JUL-2012 09:48:18

+---------------------------------------------------------------------------+

Solution :-

Make sure the following file in the APPS tier linux owner's home, also came over with the cone process:

/home/<Apps owner>/prefs.ora

in my case is :

/home/xappl/prefs.ora

Error: will not be bootstrapped since corresponding module declaration was not found in applic

Error :-

12/07/22 12:45:13 com.evermind.server.http.HttpIOException: There is no process to read data written to a pipe.

at com.evermind.server.http.EvermindServletOutputStream.write(EvermindServletOutputStream.java:210)

at com.evermind.server.http.EvermindJSPWriter.writeOut(EvermindJSPWriter.java:542)

at com.evermind.server.http.EvermindJSPWriter.jspflush(EvermindJSPWriter.java:439)

at com.evermind.server.http.EvermindJSPWriter.close(EvermindJSPWriter.java:409)

at oracle.jsp.runtime.OracleJspRuntime.extraHandlePCFinally(OracleJspRuntime.java:1910)

at _OA._jspService(_OA.java:260)

at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)

at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)

at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)

at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)

at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)

at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259)

at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51)

at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193)

at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)

at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198)

at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)

at _RF._jspService(_RF.java:225)

at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)

at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)

at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)

at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)

at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)

at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)

at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)

at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)

at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)

at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)

at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)

at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)

at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)

at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)

"oacorestd.err" 445 lines, 37264 characters

at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)

at java.lang.Thread.run(Thread.java:735)

12/07/22 13:21:20 Error: <connector name="OracleASjms" path="OracleASjms.rar" /> will not be bootstrapped since corresponding module declaration was not found in applic

ation.xml.

12/07/22 13:23:13 com.evermind.server.http.HttpIOException: There is no process to read data written to a pipe.