10 Replies Latest reply on Jun 20, 2005 2:05 PM by 446000

    The page cannot be found - deploy webreport jsps to 9ias j2ee application

    95110
      Hi,
      I created a JSP webreport using 9i reports builder and deployed to 9iAS as part of my J2EE application following the instructions in the following forum link.


      Where to put jsp files for web layout report?

      Where to put jsp files for web layout report?

      I tried to access the reports page but it says page cannot be found - HTTP 404 error. I can see other pages in the same folder. Why cannot I see the report ?
      I could not find any related error in the log files.

      Do I have to do something else to see my report ?

      I appreciate your help.

      Thanks
        • 1. Re: The page cannot be found - deploy webreport jsps to 9ias j2ee application
          393139
          Hi Yudhvir,

          JSP reports are like any other JSP page in your J2EE application. If you have deployed an EAR or a WAR containing JSP reports, make sure that you have restarted your application so that the library paths take effect (Steps 14 to 17 of the post that you referred).

          Navneet.
          • 2. Re: The page cannot be found - deploy webreport jsps to 9ias j2ee application
            95110
            Navneet,
            I have restarted my application as per the instruction 14 to 17 and I get the same problem.
            One thing I did different in the whole thing is that I deployed the application to OC4J_HOME instead of OC4J_DEMOS.
            If I deploy the application to OC4J_DEMOS, it works fine. If I deploy the application to OC4J_HOME, the reports do not work. There seems to be some problem with deploying to OC4J_HOME.
            Any idea ?

            thanks.
            Hi Yudhvir,

            JSP reports are like any other JSP page in your J2EE
            application. If you have deployed an EAR or a WAR
            containing JSP reports, make sure that you have
            restarted your application so that the library paths
            take effect (Steps 14 to 17 of the post that you
            referred).

            Navneet.
            • 3. Re: The page cannot be found - deploy webreport jsps to 9ias j2ee application
              393139
              Hi Yudhvir,

              1. Make sure that in your OC4J_HOME\..\WEB-INF\lib directory you have the reports_tld.jar

              2. How do you access the reports JSP's? Make sure that in the URL you are specifying the correct context-root (and further folder path) while accessing the reports JSP's. The context-root can be found in META-INF\application.xml

              Navneet.
              • 4. Re: The page cannot be found - deploy webreport jsps to 9ias j2ee application
                95110
                Navneet,
                I could see other pages in the same folder where the jsps are located. So I think I am using the right access path. the report_tld.jar is also in the web-inf\lib. The context path is correct too. Only when I access the jsp, the server cannot find them.
                I think I am doing everything right while accessing them because I can access them exactly the same way if I deploy the application to OC4J-DEMO. It is something to do with OC4J-HOME.
                • 5. Re: The page cannot be found - deploy webreport jsps to 9ias j2ee application
                  393139
                  Hi Yudhvir,

                  Try this-

                  Find reports.ear (inside OC4J-BI-FORMS directory) or reports_demo.ear (inside OC4J-DEMO directory), and deploy any one of them on OC4J-HOME. Try accessing the JSPs now.

                  If there is still this problem, create a new instance of OC4J, deploy reports.ear and then your application.

                  Navneet.
                  • 6. Re: The page cannot be found - deploy webreport jsps to 9ias j2ee application
                    95110
                    Navneet,
                    Well, I tried deploying the reports.ear and reports_demo.ear to OC4J_HOME and accessing the page. Now I do not get the error "Page cannot be found" but I do get the following error:

                    javax.servlet.jsp.JspException: com.sun.corba.se.internal.iiop.ORB
                    javax.servlet.jsp.JspException: com.sun.corba.se.internal.iiop.ORB
                         at oracle.reports.jsp.ReportTag.doStartTag(ReportTag.java:341)
                         at testfolder.test._jspService(_test.java:56)
                         at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
                         at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:302)
                         at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:407)
                         at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:330)
                         at javax.servlet.http.HttpServlet.service(HttpServlet.java:336)
                         at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:59)
                         at oracle.security.jazn.oc4j.JAZNFilter.doFilter(JAZNFilter.java:283)
                         at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:523)
                         at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:269)
                         at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:735)
                         at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:151)
                         at com.evermind.util.ThreadPoolThread.run(ThreadPoolThread.java:64)


                    I have not yet tried creating a new OC4J instance and deploying reports.ear.
                    This is a very frustrating problem !!! What do other people do ?
                    • 7. Re: The page cannot be found - deploy webreport jsps to 9ias j2ee application
                      393139
                      Hi Yudhvir,
                      This is a very frustrating problem !!!
                      Yes, I agree, sometimes it can be v difficult to pinpoint the problem.

                      From your exception, it is difficult to make out the reason, because it is some CORBA internal error. Most probably you are getting this exception due to incomplete classpath. I would strongly suggest that you re-confirm that your library paths have been added to your application.xml. I guess you added the library paths using the Enterprise Manager (using the web interface). So in order to re-confirm, what you can do is, take a backup of current application.xml, then make sure that the following entries are present:

                      <library path="../../../reports/jlib/rwrun.jar" />
                      <library path="../../../jlib/zrclient.jar" />

                      Since your JSPs are working fine under OC4J-DEMO, you can also compare its application.xml with that of OC4J-HOME, and make sure that all necessary library paths are present. Note that if you change anything in the application.xml, you will have to restart the application.

                      If the problem is not resolved, you can turn on the trace of the reports server, and post the contents here. You can turn on the trace by un-commenting the following line inside OH/reports/conf/<reports_server_name>.conf

                      <trace traceOpts="trace_all"/>

                      If you are using in-process server, the server name by default should be rep_<your-machine-name>. The trace file is created as OH/reports/logs/<reports_server_name>.trc

                      Navneet.
                      • 8. Re: The page cannot be found - deploy webreport jsps to 9ias j2ee application
                        402831
                        Hi..
                        This is not a reply but i have almost the same query as follows:

                        I am using Oracle 9iAS realease 2 as the client side server machine, and 9iDS Reports for developing the reports.
                        Following the instructions as in "Generating Excel output in browser using Reports9i JSP", i have created an excel template and created a JSP report for output to the WEB.
                        I keep this file at the following location on 9iDS reports server:
                        <drive:>\<Reports_9iDSserver>\reports\j2ee\reports_ids\web\<folder_name>

                        The JSP report runs well on the development server using the URL:

                        http://<host_name>:<port>/reports/<folder_name>/<Report_name>.jsp?UserId=user_name/user_password@user_db&P_arameter=xyz


                        I have tried calling the JSP report on the client web browser by keeping the file at various locations but none of them work.

                        Where exactly should i keep this file(any of the above locations correct or is there some other location for the same)?
                        and is the URL being used correct? Or do I need to do something else too?

                        Swati
                        • 9. Re: The page cannot be found - deploy webreport jsps to 9ias j2ee application
                          393139
                          Hi Swati,

                          Try copying your JSP file to

                          <Oracle_Home>/j2ee/OC4J_BI_Forms/applications/reports/web

                          Basically you can place your JSP under any application names under the j2ee directory. If you create your own application and want to deploy it, you can follow the steps in this post:

                          Where to put jsp files for web layout report?

                          Navneet.
                          • 10. Re: The page cannot be found - deploy webreport jsps to 9ias j2ee application
                            446000

                            I am getting the following Exception while calling the report. But i can call all the demo reports well.
                            Why I am getting this kind of error?



                            javax.servlet.jsp.JspException
                            javax.servlet.jsp.JspException
                            at oracle.reports.jsp.ReportTag.doStartTag(ReportTag.java:341)
                            at paramform.jspService(_paramform.java:55)
                            at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
                            at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:302)
                            at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:407)
                            at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:330)
                            at javax.servlet.http.HttpServlet.service(HttpServlet.java:336)
                            at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:59)
                            at oracle.security.jazn.oc4j.JAZNFilter.doFilter(JAZNFilter.java:283)
                            at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:523)