Monday, October 20, 2008

Migration to BusinessObjects Enterprise XI 3.0 - part 4

One of the more serious issues after the migration from XI R2 was that all (about 640) schedules where missing! Not a single one had been migrated. This was clearly a problem with the migration tool.
The explanation from Business Objects was that the permissions where incorrect applied in the old environment and because of that all schedules where lost. I don't buy that at all. All other reports with instances were there and working but only the reports with scheduling where erratic. The schedules where created by a huge amount of different users and rights. The fact that exactly all schedules are missing points to the fact that it must be due to a bug in the migration tool.

The error is occurring when viewing history on a scheduled report or if you try to schedule it again. The error messages are different depending on the report type.

Crystal Reports error message

HTTP Status 500



HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:395) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) 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)
root cause
java.lang.NullPointerException com.businessobjects.clientaction.crystalreport.history.SendToAbleCustomColumn.render(SendToAbleCustomColumn.java:75) com.businessobjects.components.explorer.model.impl.ColumnWrapper.render(ColumnWrapper.java:113) com.businessobjects.jsf.explorer.renderkit.ResizableContentListViewRenderer.displayNode2(ResizableContentListViewRenderer.java:447) com.businessobjects.jsf.explorer.renderkit.ResizableContentListViewRenderer.displayNode(ResizableContentListViewRenderer.java:380) com.businessobjects.jsf.explorer.renderkit.ResizableContentListViewRenderer.renderHtml(ResizableContentListViewRenderer.java:994) com.businessobjects.jsf.explorer.renderkit.ResizableContentListViewRenderer.encodeBegin(ResizableContentListViewRenderer.java:112) javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:703) javax.faces.render.Renderer.encodeChildren(Renderer.java:136) javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:721) javax.faces.render.Renderer.encodeChildren(Renderer.java:138) javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:721) javax.faces.webapp.UIComponentTag.encodeChildren(UIComponentTag.java:629) javax.faces.webapp.UIComponentTag.doEndTag(UIComponentTag.java:566) org.apache.jsp.jsp.CrystalReport_005fHistory.history_jsp._jspx_meth_ure_explorer_0(history_jsp.java:1694) org.apache.jsp.jsp.CrystalReport_005fHistory.history_jsp._jspService(history_jsp.java:492) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) 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)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.20 logs.
--------------------------------------------------------------------------------
Apache Tomcat/5.5.20

Web Intelligence error message

The page cannot be found

The workaround for this type of issue is to save the report with new name and reschedule it. We didn't get a fix from Business Objects for this problem.

2 comments:

Anonymous said...

we're having this problem as well. Tried installing Fixpack 3 which didn't do a thing. Any other thoughts besides just rescheduling everything?

Oakleaf said...

No. The customer rescheduled all reports.

As things are now we are considering upgrading to 3.1. That is the latest recommendation from SAP support as they can't find any solution to the other problems we are experiencing.