This content has been marked as final. Show 22 replies
Looks like you already tried one way to work around the A4 page size / decimal separator issue, I addressed this issue in the following thread using another solution:
Re: empty PDF files generated within APEX 3.0
We'll fix that with the next patch. But if this solution doesn't work, perhaps there's something else not configured correctly. So if it still doesn't work, perhaps you could check your OC4J logs to see what's going on and perhaps post back on the forum, what you can find in there.
Ithink I can't reach the publisher because I tested the output of a pdf-file around 17:32 and no files under bipublisher have been changed.
The only one what I found is the Apache Webserver for APEX with some entries:
(192.168.1.22 is the webserver and 192.168.2.31 is the client)
192.168.1.22 - APEX_PUBLIC_USER [23/Apr/2007:17:31:45 +0200] "POST /pls/apex/wwv_flow.accept HTTP/1.1" 302 161
192.168.1.22 - APEX_PUBLIC_USER [23/Apr/2007:17:31:45 +0200] "GET /pls/apex/f?p=300:2:197969852401431::NO::: HTTP/1.1" 200 31546
192.168.1.22 - APEX_PUBLIC_USER [23/Apr/2007:17:31:46 +0200] "GET /pls/apex/wwv_flow_file_mgr.get_file?p_security_group_id=2127411430829714&p_fname=logo.gif HTTP/1.1" 200 1946
192.168.1.22 - APEX_PUBLIC_USER [23/Apr/2007:17:31:46 +0200] "GET /pls/apex/wwv_flow_file_mgr.get_file?p_security_group_id=2127411430829714&p_fname=Find_Next.gif HTTP/1.1" 200 1322
192.168.1.22 - APEX_PUBLIC_USER [23/Apr/2007:17:31:50 +0200] "GET /pls/apex/f?p=300:2:197969852401431:FLOW_XMLP_OUTPUT_R2294213895835754_en HTTP/1.1" 200 5
192.168.1.22 - - [23/Apr/2007:17:31:22 +0200] "GET /forms/lservlet HTTP/1.1" 200 223 "6909315066325,0"
127.0.0.1 - - [23/Apr/2007:17:31:34 +0200] "GET /_oracle_http_server_webcache_static_.html HTTP/1.1" 200 99 "5895702796987,0"
192.168.2.31 - - [23/Apr/2007:17:31:45 +0200] "POST /pls/apex/wwv_flow.accept HTTP/1.1" 302 161 "5586465162343,0"
192.168.2.31 - - [23/Apr/2007:17:31:45 +0200] "GET /pls/apex/f?p=300:2:197969852401431::NO::: HTTP/1.1" 200 31546 "5586465162663,0"
192.168.2.31 - - [23/Apr/2007:17:31:46 +0200] "GET /pls/apex/wwv_flow_file_mgr.get_file?p_security_group_id=2127411430829714&p_fname=logo.gif HTTP/1.1" 200 1946 "5586465162999,0"
192.168.2.31 - - [23/Apr/2007:17:31:46 +0200] "GET /pls/apex/wwv_flow_file_mgr.get_file?p_security_group_id=2127411430829714&p_fname=Find_Next.gif HTTP/1.1" 200 1322 "6119041108269,0"
192.168.2.31 - - [23/Apr/2007:17:31:50 +0200] "GET /pls/apex/f?p=300:2:197969852401431:FLOW_XMLP_OUTPUT_R2294213895835754_en HTTP/1.1" 200 0 "5586465163597,0"
127.0.0.1 - - [23/Apr/2007:17:31:54 +0200] "GET /_oracle_http_server_webcache_static_.html HTTP/1.1" 200 99 "5002349619899,0"
127.0.0.1 - - [23/Apr/2007:17:32:14 +0200] "GET /_oracle_http_server_webcache_static_.html HTTP/1.1" 200 99 "5947242445499,0"
192.168.1.22 - - [23/Apr/2007:17:32:22 +0200] "GET /forms/lservlet HTTP/1.1" 200 223 "5328767162853,0"
The request to BI Publisher never reaches the Apache log. What you have in your log is the request to APEX, but then APEX takes that request, renders the XML data, and sends that directly to BI Publisher using UTL_HTTP along with a report layout (XSL-FO or RTF).
You can find the BI Publisher log in your OC4J Enterprise Manager, it's typically located here:
If you can't find any errors in that file, it's possible that you can in fact not reach your BI Publisher instances from APEX. Try call the servlet directly from the instance where you have your database running:
This should at least generate an entry in the log,
When I try to create a pdf over APEX then I get no entry into the
APEX and BIPublisher are on the same Server and I tried to access over a webbrowser on this server and the following entry become create through bi publisher in the application.log:
07/04/24 07:22:19.246 xmlpserver: Servlet error
javax.servlet.ServletException: XML data or RTF template is null.
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:711)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:368)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:866)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:448)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:216)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:117)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:110)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
But I checked the entries in the APEX Instance settings and they are all okey. (For the server I used the ip-address.)
I also tried the apex instance settings under servername with localhost and %server%.%domain% with no success.
Can't reach with APEX the BI Publisher although they are on the same server.
When I start my webbrowser and user /xmlpserver/convert I get the following answer:
500 Internal Server Error
Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in this response. Please consult the application log for details.
If I'm right the BI Publisher works.
How is it now possible that I can't reach the BI Publisher with APEX. Not even the applicaton.log say something.
I went step by step through the:
and the german one:
We are facing similar problems integrating APEX and BI Publisher, the difference is that we always get 404 Not Found error instead of empty document:
The requested URL /pls/apexprint/f was not found on this server.
Apache in the error.log shows the following:
[Thu Apr 26 11:40:51 2007] [warn] mod_plsql: Stale Connection due to Oracle erro
[Thu Apr 26 11:40:51 2007] [error] mod_plsql: /pls/apexprint/f ORA-22293
ORA-22293: LOB already opened in the same transaction
We have tested the RTF template in the BI Publisher itself and found out that it works, right now we considering to create reports there separately, but it would be better to finish the integration with APEX.
application.log shows nothing, except when trying to load /xmlpserver/convert (same error as tarnhold described).
Application language is ukrainian, but we have also tested printing with the external link, and also created a separate application in english for printing and the 404 error is still there, so the problem is not with the internationalization settings.
Thanks for posting all this information, unfortunately I still can't see what the problem could be. Just to rule out that it's your report or template, could you please re-create your application on a workspace on apex.oracle.com and check if it works there? Because if it does, at least we know that it's somehow related to your setup.
Which database version are you using? I've seen customers reporting similar issues when they ran this on a version of Oracle 9i.
You are right, Marc, our database version is 184.108.40.206.
Could you possibly suggest us what we can try to solve this issue?
I'll have yet to exactly track down why this isn't working in 9.2, and under what circumstances. So the only suggestions I have at this point is running this on a 10g database. I'll reply back when I know more,
Thank you, Marc, I'll be looking forward for your reply.
I am having the exact same problem as Maxym and "tarnhold" with APEX printing through BI Publisher. Have you found out any new information on this issue? I am running on a 10g database.
There seem to be different problems being reported in the previous posts. One related to running this on 9i - which is not the problem you're having, since you're running 10g. In order for me to try disagnosing your particular problem, I would need some more information. So please describe exactly how you set this up, which OS, which database, patch, etc., how you setup BI Publisher, which version, which JDK, using the OC4J that came with BIP, or Oracle Application Server? Which language you're running your APEX app in, and anything else you can think off.
Try use Application LOCALE en-us
in locale RU - not work (empty file)
in locale en-us normal work