1 2 Previous Next 22 Replies Latest reply on Sep 11, 2012 11:13 AM by 961342

    No content in files through  BI Publisher

    455447
      Hello developers,<br>
      <br>
      I have a problem during the implementation of the BI Publisher 10.1.3.2.
      Whenever I start the process to print I get always an empty file (tried with excel (empty file) and pdf (error)).
      The installation worked fine and the BI Publisher started correctly. In APEX I used the following settings :
      <br>
      Version: APEX: 3.0<br>
      Language: German<br>
      <br>
      Instance Settings:<br>
      Printserver: %ip-address%<br>
      Port: 9704<br>
      Script: /xmlpserver/convert<br>
      <br>
      I looked in the internet for same errors and tried the following options with no positive result:
      - Gobalization attributes from German(de) to English(en)
      - Print attributes from millimeter to Point with integer values
      - used my own link instead of the apex print layout: a href="/pls/apex/f?p=&APP_ID.:&APP_PAGE_ID.:&SESSION.:FLOW_XMLP_OUTPUT_R2294213895835754_en" Print /a
      <br>
      Nothing worked and now I have no idea what to do. Any idea!?
      <br>
      Thanks ahead
        • 1. Re: No content in files through  BI Publisher
          Marc Sewtz-Oracle
          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.

          Marc
          • 2. Re: No content in files through  BI Publisher
            455447
            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)

            access_log.1177329600

            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

            access_log
            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"
            • 3. Re: No content in files through  BI Publisher
              Marc Sewtz-Oracle
              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:

              /oc4j/j2ee/home/application-deployments/xmlpserver/application.log

              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:

              host:port/xmlpserver/convert

              This should at least generate an entry in the log,

              Regards,
              Marc
              • 4. Re: No content in files through  BI Publisher
                455447
                When I try to create a pdf over APEX then I get no entry into the

                /oc4j/j2ee/home/application-deployments/xmlpserver/application.log

                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 oracle.apps.xdo.servlet.Converter.doPost(Converter.java:99)
                     at oracle.apps.xdo.servlet.Converter.doGet(Converter.java:50)
                     at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
                     at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
                     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 oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
                     at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:239)
                     at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:34)
                     at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:880)
                     at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
                     at java.lang.Thread.run(Thread.java:595)

                But I checked the entries in the APEX Instance settings and they are all okey. (For the server I used the ip-address.)
                Any idea?
                • 5. Re: No content in files through  BI Publisher
                  455447
                  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.
                  • 6. Re: No content in files through  BI Publisher
                    455447
                    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:
                    http://www.oracle.com/technology/products/database/application_express/html/configure_printing.html
                    and the german one:
                    http://www.oracle.com/global/de/community/tipps/bip/index.html
                    • 7. Re: No content in files through  BI Publisher
                      314175
                      Hello gentlemen,
                      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
                      r 22293
                      [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.

                      Any ideas?
                      • 8. Re: No content in files through  BI Publisher
                        Marc Sewtz-Oracle
                        "tarnhold":

                        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.

                        Maxym:

                        Which database version are you using? I've seen customers reporting similar issues when they ran this on a version of Oracle 9i.

                        Thanks,
                        Marc
                        • 9. Re: No content in files through  BI Publisher
                          314175
                          You are right, Marc, our database version is 9.2.0.4.
                          Could you possibly suggest us what we can try to solve this issue?
                          • 10. Re: No content in files through  BI Publisher
                            Marc Sewtz-Oracle
                            Maxym,

                            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,

                            Regards,
                            Marc
                            • 11. Re: No content in files through  BI Publisher
                              314175
                              Thank you, Marc, I'll be looking forward for your reply.
                              • 12. Re: No content in files through  BI Publisher
                                37852
                                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.

                                Thanks,
                                Bob Davidson
                                • 13. Re: No content in files through  BI Publisher
                                  Marc Sewtz-Oracle
                                  Bob,

                                  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.

                                  Thanks,
                                  Marc
                                  • 14. Re: No content in files through  BI Publisher
                                    575524
                                    Try use Application LOCALE en-us

                                    My problem:
                                    in locale RU - not work (empty file)
                                    in locale en-us normal work
                                    1 2 Previous Next