asked on

Runnig 9i Reports JSP's on Apache

Hi,

I'm new to AS and I'm sorry if I use incorrect terms.

The machine that runs the DB also runs Apache + report server. From an unknown reason I cannot call either JSP's from the address bar (i.e http://host:7778/reports/rep.jsp - upon a java error page appears:
Request URI:/reports/rwdemagree2.jsp

Exception:
oracle.jsp.parse.JspParseException: Line # 1,
Error: java.lang.ClassNotFoundException: oracle.reports.jsp.ReportTagExtraInfo
      at oracle.jsp.parse.JspDirectiveTaglib.loadTagLibFromTLD(JspDirectiveTaglib.java)
      at oracle.jsp.parse.JspDirectiveTaglib.validateAttributes(JspDirectiveTaglib.java)
      at oracle.jsp.parse.JspParseTagDirective.validateTagAttributes(JspParseTagDirective.java)
      at oracle.jsp.parse.JspParseTag.parse(JspParseTag.java)
      at oracle.jsp.parse.JspParseTagDirective.parse(JspParseTagDirective.java)
      at oracle.jsp.parse.JspParseTag.parseNextTag(JspParseTag.java)
      at oracle.jsp.parse.JspParseTagFile.parse(JspParseTagFile.java)
      at oracle.jsp.parse.OracleJsp2Java.transform(OracleJsp2Java.java)
      at oracle.jsp.app.JspAppLoader.reloadPage(JspAppLoader.java)
      at oracle.jsp.app.JspAppLoader.loadPage(JspAppLoader.java)
      at oracle.jsp.app.JspAppLoader.getPage(JspAppLoader.java)
      at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java)
      at oracle.jsp.JspServlet.doDispatch(JspServlet.java)
      at oracle.jsp.JspServlet.internalService(JspServlet.java)
      at oracle.jsp.JspServlet.service(JspServlet.java)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
      at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
      at org.apache.jserv.JServConnection.run(JServConnection.java:294)
      at java.lang.Thread.run(Thread.java:484)
)
or invoke a reports using URL+params (i.e. http://host:7778/reports/rwservlet?report=rep.rdf&desformat=html&destype=cache&server=repsvr1&dept_param=10 upon nothing happens).

Any suggestions?

10x DNeeBrkr

ASKER CERTIFIED SOLUTION

bochgoch

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

dneebrkr

ASKER

bochgoch ,

Port 80 belongs to the IIS which is not in use
Port 1810 is not in use
Port 7778 is running well. Demo JSP's and simple HTML work perfect.

The report files are located in a designated directory in the server's root directory (double checked spelling)

bochgoch

1810 not in use? So you're not running App Server -- what versions of Oracle software are you using?

What does:

http://host:7778/reports/rwservlet

...give you?

dneebrkr

ASKER

I'm using 9i.

the URL returns 'Cannot find Server' page.

bochgoch

So you haven't got reports running on the server -- that URL should give you the Reports Services page...

Do you have an ORACLE_HOME\reports directory in your operating system? Have you run reports as jsps or using the reports URL we've discussed previously?

dneebrkr

ASKER

ORACLE_HOME\reports exists on the server and on my workstation.
Tried both ways

dneebrkr

ASKER

I also noticed 2 Apache directories: one under ORACLE_HOME and the other under the iDS.
The one that is in use is the first one which was obviously installed when Oracle was installed.

bochgoch

Sounds to me like you only have Apache running as part of the database install, rather than as part of the App Server install, in this case the reports service will not be available (as it is part of the App Server install).

Are you sure that reports has been properly installed?

We can check:

Go to the command line (on Windows Run cmd).
Change directory to your infrastructure home (i.e. D:\xxxx\DCM\BIN -- amend xxxx as appropriate for your INFRASTRUCTURE home).
Type - 'dcmctl shell'
Depending on what happens:
If you get a command prompt 'dcmctl>' then type 'getstate -v' and let me know what response you get.
If you get an error message then please post it.

(You can search for 'dcmctl.*' to find your Oracle home directories)

dneebrkr

ASKER

No such thing 'dcmctl.*' on my platform

dneebrkr

ASKER

Found some missong classes in the jar file.
Now I get this error: (Althought RWReport exists)

Request URI:/reports/rwdemagree2.jsp

Exception:
java.lang.NoClassDefFoundError: oracle.reports.definition.RWReport
      at oracle.reports.jsp.ReportTagExtraInfo.class$(ReportTagExtraInfo.java:13)
      at oracle.reports.jsp.ReportTagExtraInfo.getVariableInfo(ReportTagExtraInfo.java:15)
      at javax.servlet.jsp.tagext.TagInfo.getVariableInfo(TagInfo.java:149)
      at oracle.jsp.parse.JspRTTag.getDefinedObjects(JspRTTag.java)
      at oracle.jsp.parse.OpenJspTagHandler.validateTagAttributes(OpenJspTagHandler.java)
      at oracle.jsp.parse.JspParseTag.parse(JspParseTag.java)
      at oracle.jsp.parse.OpenJspTagHandler.parse(OpenJspTagHandler.java)
      at oracle.jsp.parse.JspParseTag.parseNextTag(JspParseTag.java)
      at oracle.jsp.parse.JspParseTagFile.parse(JspParseTagFile.java)
      at oracle.jsp.parse.OracleJsp2Java.transform(OracleJsp2Java.java)
      at oracle.jsp.app.JspAppLoader.reloadPage(JspAppLoader.java)
      at oracle.jsp.app.JspAppLoader.loadPage(JspAppLoader.java)
      at oracle.jsp.app.JspAppLoader.getPage(JspAppLoader.java)
      at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java)
      at oracle.jsp.JspServlet.doDispatch(JspServlet.java)
      at oracle.jsp.JspServlet.internalService(JspServlet.java)
      at oracle.jsp.JspServlet.service(JspServlet.java)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
      at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
      at org.apache.jserv.JServConnection.run(JServConnection.java:294)
      at java.lang.Thread.run(Thread.java:484)

bochgoch

I've been away for a few days, are you still stuck with this?

bg

dneebrkr

ASKER

Yep,

still stuck

bochgoch

Exactly which version of 9i are you running? -- this looks like either a 'partial' 9 / 9r2 install or a 10g (9.0.4) Forms and Reports Services only install to me.

Could you also run through this document...

http://www.oracle.com/technology/products/reports/htdocs/getstart/whitepapers/troubleshooting_Server_902.pdf

...and report back?