APEX PDF problems.
- From: Michael Moore <michaeljmoore@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 24 Oct 2011 10:37:17 -0700
Hello,
I am trying to get my APEX 4.1 to generate PDF downloads. I understand
conceptually what needs to happen. I also understand the BI Publisher is
the preferred Oracle solution. However, it is not free.
My hope is that somebody here who is familiar with APEX can look at the
results I am getting back from my PDF service (J4LFOPServer) and tell me
what I need to do to make it work.
I?ve installed J4LFOPServer on my windows XP machine. The Example provided
with the J4LFOPServer install works fine, so no problem there.(I can access
it from a web page and it properly generates PDFs
After setting up APEX 4.1 Report Printing
I get a corrupt PDF back that contains the following text:
ORA-20001: The printing engine could not be reached because either the URL
specified is incorrect or a proxy URL needs to be specified.
</td>
<td class="tbl-sidebar"></td>
</tr>
</tbody>
</table>
</div><div id="footer"><div class="content">
<div id="customize"></div>
<div class="app-version">Release 4.1</div>
<div class="clear"></div>
</div></div>
<input type="hidden" name="p_md5_checksum" value="" /></form>
<div id="apex-dev-toolbar"><ul>
<li ><a class="apex-toolbar" title="Application Express Home Page"
href="f?pE00:1000:2645798598167220">Home</a></li>
<li ><a class="apex-toolbar" title="Application 105"
href="f?p@00:1:2645798598167220::NO:1,4150,RP:FB_FLOW_ID,FB_FLOW_PAGE_ID,F4000_P1_FLOW,F4000_P4150_GOTO_PAGE,F4000_P1_PAGE:105,4,105,4,4">Application
105</a></li>
<li ><a class="apex-toolbar" title="Edit Page 4"
href="f?p@00:4150:2645798598167220::NO:1,4150:FB_FLOW_ID,FB_FLOW_PAGE_ID,F4000_P1_FLOW,F4000_P4150_GOTO_PAGE,F4000_P1_PAGE:105,4,105,4,4">Edit
Page 4</a></li>
<li ><a class="apex-toolbar" title="Create"
href="f?p@00:336:2645798598167220::NO::FB_FLOW_ID,FB_FLOW_PAGE_ID,F4000_P1_FLOW,F4000_P4150_GOTO_PAGE,F4000_P1_PAGE:105,4,105,4,4">Create</a></li>
<li ><a class="apex-toolbar" title="Session"
href="javascript:popupSessionInfo();">Session</a></li>
<li ><a class="apex-toolbar" title="Caching"
href="f?p@00:14:2645798598167220::::FB_FLOW_ID,FB_FLOW_PAGE_ID,F4000_P1_FLOW,F4000_P4150_GOTO_PAGE,F4000_P1_PAGE:105,4,105,4,4">Caching</a></li>
<li ><a class="apex-toolbar" title="View Debug"
href="javascript:popupViewDebug();">View Debug</a></li>
<li ><a class="apex-toolbar" title="Debug"
href="f?p5:4:939718999261319::YES">Debug</a></li>
<li id="hideEdit" style="display:none;"><a class="apex-toolbar" title="Hide
Edit Links" href="javascript:quickLinks('HIDE');">Hide Edit Links</a></li>
<li id="showEdit"><a class="apex-toolbar" title="Show Edit Links"
href="javascript:quickLinks('SHOW');">Show Edit Links</a></li>
</ul></div>
<script type="text/javascript">
<!--
function popupSessionInfo(){var w
open("f?p@00:34:2645798598167220:PAGE:NO:34:F4000_P34_SESSION,F4000_P34_FLOW,F4000_P34_PAGE,FB_FLOW_ID:939718999261319,105,4,105","winLov","Scrollbars=1,resizable=1,widthp0,heightE0");if
(w.opener == null){w.opener = self;}w.focus();}
function popupViewDebug(){var w
open("f?p@00:19:2645798598167220:::RIR,19:IR_APPLICATION_ID,IR_PAGE_ID:105,4","winLov","Scrollbars=1,resizable=1,widthp0,heightE0");if
(w.opener == null){w.opener = self;}w.focus();}
apex.jQuery(document).ready(function(){
(function(){if(GetCookie('ORA_WWV_QUICK_EDIT')
!null){if(GetCookie('ORA_WWV_QUICK_EDIT') ==
'SHOW'){quickLinks('SHOW');}}})();
});
//-->
</script></body>
</html>
A couple of times I got something slightly different when I set up the print
parameters differently (I mention this because it seems to indicate that
J4LFOPServer is reachable by my APEX install) ?
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"/>
<title>Error 500 C:\Program
Files\J4LFOPServer\webapps\J4LFOPServer\WEB-INF\classes (The filename,
directory name, or volume label syntax is incorrect)</title>
</head>
<body><h2>HTTP ERROR 500</h2>
<p>Problem accessing /J4LFOPServer/servlet. Reason:
<pre> C:\Program Files\J4LFOPServer\webapps\J4LFOPServer\WEB-INF\classes
(The filename, directory name, or volume label syntax is
incorrect)</pre></p><h3>Caused by:</h3><pre>javax.servlet.ServletException:
C:\Program Files\J4LFOPServer\webapps\J4LFOPServer\WEB-INF\classes (The
filename, directory name, or volume label syntax is incorrect)
at com.java4less.xreport.fop.FOPServer.doPost(FOPServer.java:338)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at
org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:547)
at
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:480)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
at
org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:483)
at
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:227)
at
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:940)
at
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:409)
at
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186)
at
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:874)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
at
org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:250)
at
org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:149)
at
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:110)
at org.eclipse.jetty.server.Server.handle(Server.java:349)
at
org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:441)
at
org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:936)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:801)
at
org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:218)
at
org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:52)
at
org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:586)
at
org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:44)
at
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:598)
at
org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:533)
at java.lang.Thread.run(Thread.java:619)
</pre>
<hr /><i><small>Powered by
Jetty://</small></i><br/>
<br/>
<br/>
</body>
*TIA for any help.*
*
*
*Mike*
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » APEX PDF problems. - Michael Moore
