Error "Servlet execution threw an exception" when running CR report on BW

[Former Member]

Hi,

Firstly we had an issue applying FP 2, and subsequently we reinstalled XI on the server and so with the help of TechSupport.

Everything was working prior to the FP install issue, and now, when I run a Crystal Report in InfoView connecting to a SQL database, the report runs fine.

When I run a Crystal Report connecting to SAP BW in InfoView, the following Error occurs:

An error has occurred: Servlet execution threw an exception

When I check the log file in the tomcat directory, the following is logged

16-09-08 08:11:08:419 - [/SAP].[action] Thread [http-8080-Processor21]; Servlet.service() for servlet action threw exception

java.lang.NoClassDefFoundError: com/sap/mw/jco/JCO$Exception

at com.crystaldecisions.sap.web.parameter.ParameterUtilityFactory.getParameterUtility(Unknown Source)

at com.businessobjects.clientaction.sap.crystalreport.view.SAPViewReportAction.autoWrapPerform(Unknown Source)

at com.businessobjects.webutil.struts.CheckSessionAction.process(CheckSessionAction.java:79)

at com.businessobjects.webutil.struts.CheckSessionAction.perform(CheckSessionAction.java:59)

Can anyone provide some insight to what possibly the cause could be...

Thanks

Jacques

[adil_madid]

Hi,

Is this happening with newly published reports as well (new reports)?

You have indeed used the same JCO files as before the re-install?

What patch level are you on now? (Core and Integration kit products)

Adil

[Former Member]

The issue has been resolved..

Added the CLASSPATH for JCO to Tomcat - Java.

Regards

Jacques

[Former Member]

Hi, Could you please explain what you mean by "Added the CLASSPATH for JCO to Tomcat - Java."? I am having the same problem but do not understand the solution. I know practically nothing about Tomcat or Java.

Thanks

Rob

[BasicTek]

There are many ways to set a classpath, [use this link |http://www.coreservlets.com/Apache-Tomcat-Tutorial/tomcat-5.5.html#Set-CLASSPATH]to get started, or Google for other methods.

Regards,

Tim

[Former Member]

Thanks - that looks helpful. We have discovered we are missing the necessary files so once we get them I'll be able to move forward.

Rob

[michael_jennings]

Hi Tim,

    I have the same error message, but my tomcat-log is a little bit different :

********************************************************************************************

27-06-12 18:55:33:462 - {ERROR} [/SAP].[action] Thread [http-8080-Processor11];  Servlet.service() for servlet action threw exception

java.lang.NoClassDefFoundError

        at com.crystaldecisions.sap.web.a.a(Unknown Source)

        at com.crystaldecisions.sap.web.parameter.a.i.a(Unknown Source)

        at com.crystaldecisions.sap.web.parameter.a.i.initialize(Unknown Source)

        at com.crystaldecisions.sap.web.parameter.a.i.initialize(Unknown Source)

        at com.businessobjects.clientaction.sap.crystalreport.view.SAPViewReportAction.autoWrapPerform(Unknown Source)

        at com.businessobjects.webutil.struts.CheckSessionAction.process(CheckSessionAction.java:79)

        at com.businessobjects.webutil.struts.CheckSessionAction.perform(CheckSessionAction.java:59)

        at org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1787)

        at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1586)

        at com.businessobjects.webutil.struts.CrystalUTF8InputActionServlet.process(CrystalUTF8InputActionServlet.java:32)

        at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

        at com.businessobjects.webutil.websessiontimeout.WebSessionTimeoutFilter.doFilter(WebSessionTimeoutFilter.java:161)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)

        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)

        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)

        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)

        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)

        at java.lang.Thread.run(Thread.java:595)

********************************************************************************************

Do You think this issue is related to the JCO ?

Best Regards,

M.