SAP AUTHENTICATION- ROLE IMPORT BOBJ 4.0 SP 2 giving HTTP STATUS 500 ERROR

[Former Member]

Hi ,

We have installed BOBJ 4.0 SP 2 with FP 6 on LINUX with ORACLE 11 G R2 as DB. Running TOMCAT 6.0.33 as Web App Server. We are having issue when we goto Authentication->SAP->ROLE IMPORT location in CMC. As soon as we click on ROLE IMPORT, it is issuing HTTP STATUS 500 error. Not sure if we need to manually provide the sapjco.jar files as we do in BOBJ 3.1 BOE SAP Integration Kit installation. Tried re-deploying the applications using wdeploy.

Here is the error message:

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

java.lang.RuntimeException: java.lang.RuntimeException: javax.servlet.ServletException: java.lang.NoClassDefFoundError: com/sap/conn/jco/JCoException

com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.serviceHelper(BundlePathAwareServiceHandler.java:254)

com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.service(BundlePathAwareServiceHandler.java:197)

com.businessobjects.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:248)

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:220)

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

com.businessobjects.pinger.TimeoutManagerFilter.doFilter(TimeoutManagerFilter.java:159)

root cause

java.lang.RuntimeException: javax.servlet.ServletException: java.lang.NoClassDefFoundError: com/sap/conn/jco/JCoException

com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.serviceHelper(BundlePathAwareServiceHandler.java:254)

com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.service(BundlePathAwareServiceHandler.java:197)

com.businessobjects.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:248)

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:220)

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

com.businessobjects.http.servlet.internal.servlet.RequestDispatcherAdaptor.forward(RequestDispatcherAdaptor.java:31)

com.sun.faces.context.ExternalContextImpl.dispatch(ExternalContextImpl.java:346)

com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:152)

com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:107)

com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:245)

com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:137)

javax.faces.webapp.FacesServlet.service(FacesServlet.java:214)

com.businessobjects.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:110)

com.businessobjects.http.servlet.internal.ServletLastFilterChainElement.service(ServletLastFilterChainElement.java:30)

com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:46)

com.businessobjects.webutil.BOEInitializerFilter.doFilter(BOEInitializerFilter.java:36)

com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)

com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)

com.businessobjects.webutil.boetrustguard.BOETrustValidateFilter.doFilter(BOETrustValidateFilter.java:53)

com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)

com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)

com.businessobjects.webutil.internal.filters.BrowserRenderingModeFilter.doFilter(BrowserRenderingModeFilter.java:20)

com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)

com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)

com.businessobjects.webutil.boetrustguard.BOETrustPrepareFilter.doFilter(BOETrustPrepareFilter.java:32)

com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)

com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)

com.businessobjects.swd.shared.tracelog.TraceLogScopeFilter.doFilter(TraceLogScopeFilter.java:38)

com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)

com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)

com.businessobjects.sdk.actionfilter.WorkflowFilter.doFilter(WorkflowFilter.java:45)

com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)

com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)

com.businessobjects.swd.appcontext.RequestInitFilter.doFilter(RequestInitFilter.java:26)

com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)

com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)

com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.serviceHelper(BundlePathAwareServiceHandler.java:235)

com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.service(BundlePathAwareServiceHandler.java:197)

com.businessobjects.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:248)

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:220)

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

com.businessobjects.pinger.TimeoutManagerFilter.doFilter(TimeoutManagerFilter.java:159)

root cause

javax.servlet.ServletException: java.lang.NoClassDefFoundError: com/sap/conn/jco/JCoException

org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)

org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)

org.apache.jsp.jsp.secSAPR3_005fProperties.import_005frole_jsp._jspService(import_005frole_jsp.java:180)

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

org.eclipse.equinox.jsp.jasper.JspServlet.service(JspServlet.java:121)

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

com.businessobjects.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:110)

com.businessobjects.http.servlet.internal.ServletLastFilterChainElement.service(ServletLastFilterChainElement.java:30)

com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:46)

com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.serviceHelper(BundlePathAwareServiceHandler.java:235)

com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.service(BundlePathAwareServiceHandler.java:197)

com.businessobjects.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:248)

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:220)

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

com.businessobjects.http.servlet.internal.servlet.RequestDispatcherAdaptor.forward(RequestDispatcherAdaptor.java:31)

com.sun.faces.context.ExternalContextImpl.dispatch(ExternalContextImpl.java:346)

com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:152)

com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:107)

com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:245)

com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:137)

javax.faces.webapp.FacesServlet.service(FacesServlet.java:214)

com.businessobjects.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:110)

com.businessobjects.http.servlet.internal.ServletLastFilterChainElement.service(ServletLastFilterChainElement.java:30)

com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:46)

com.businessobjects.webutil.BOEInitializerFilter.doFilter(BOEInitializerFilter.java:36)

com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)

com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)

com.businessobjects.webutil.boetrustguard.BOETrustValidateFilter.doFilter(BOETrustValidateFilter.java:53)

com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)

com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)

com.businessobjects.webutil.internal.filters.BrowserRenderingModeFilter.doFilter(BrowserRenderingModeFilter.java:20)

com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)

com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)

com.businessobjects.webutil.boetrustguard.BOETrustPrepareFilter.doFilter(BOETrustPrepareFilter.java:32)

com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)

com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)

com.businessobjects.swd.shared.tracelog.TraceLogScopeFilter.doFilter(TraceLogScopeFilter.java:38)

com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)

com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)

com.businessobjects.sdk.actionfilter.WorkflowFilter.doFilter(WorkflowFilter.java:45)

com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)

com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)

com.businessobjects.swd.appcontext.RequestInitFilter.doFilter(RequestInitFilter.java:26)

com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72)

com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43)

com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.serviceHelper(BundlePathAwareServiceHandler.java:235)

com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.service(BundlePathAwareServiceHandler.java:197)

com.businessobjects.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:248)

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:220)

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

com.businessobjects.pinger.TimeoutManagerFilter.doFilter(TimeoutManagerFilter.java:159)

Thanks,

Sandeep

Edited by: Sandeep Bomidika on Oct 13, 2011 11:29 PM

[Former Member]

refer to sap notes

1994137 - Error: "HTTP Status 500 - java.lang.Runtime... JCo Exception" while clicking on Role Impor...

1619344 - Error: "Could not initialize class com.sap.conn.jco.JCo" when attempting to access the Rol...

[Former Member]

We found a fix without reinstalling Tomcat. Open tomcat configuration and add the following to the Tomcat Classpath::::::D:\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\lib\sapjco3.jar

[Former Member]

Thanks a lot, Its worked after i add "SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\lib\sapjco3.jar" into my Tomcat's Java Classpath: and restart my Tomcat service.

[Former Member]

Finally I am able to resolve the issue by re-installing TOMCAT and re-deploying the webapps using wdeploy.sh.

Thanks,

Sandeep

[Former Member]

Is there a root cause to this issue? We do not want to reinstall tomcat, as there is a lot of custom config

[Former Member]

Hi Seb,

Actually, I am getting this error as soon as we goto the Role Import Tab (tried both ways 1) by defining the Entitlement Systems & 2) without Entitlement Systems). I dont think it is relevant to the transports (Yes. I have imported all the BW relevant transports into BW system.).

Thanks,

Sandeep

[former_member136842]

Hi,

yes, thats right. You dont need to deploy manually the .jar file anymore in BI4.

Beside that it looks like an error on BOE side, are all transports imported on the BW?

Regards

-Seb.