APEX PDF problems.
Date: Mon, 24 Oct 2011 10:37:17 -0700
Message-ID: <CACpWLjP8dSAgxoaEbthoMwXs0MF5ASnBeXvQEsGE_tup-n8=2w_at_mail.gmail.com>
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_at_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_at_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_at_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_at_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_at_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_at_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*
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 24 2011 - 12:37:17 CDT