Cannot open webi report through HTML View

[Former Member]

Hi,

When i Open any web intelligence report it gives an error saying Could Not Get Page Number.(Error: RwI 00223) (Error INF).

Can any one help me on this. Its very Urgent.

Thanks,

Bernard.

[Former Member]

This is a tough one to answer because the RWI0023 is quite generic. With some luck, you might be able to turn on tracing and find more detailed information on why it errored. It could be because of a specific way the report was formatted, or a specific query. There are so many possibilities. Is the report 'refreshing on open'? does it only happen in the HTML View and not JRP?

If memory serves, this problem happened more frequently with older versions of BOEXIR2 (pre SP2). Consider testing out a recent patch level if you aren't already on one.

[Former Member]

Hi,

Yes it is happening when i open it through HTML view.....

I am on BO XI R2 SP3..... but the problem is still there.....

Any ways thanks for the reply.

Bernard.

[Former Member]

Hi Tony

I have installed the SAP Integration Kit and I am getting the same error when trying to display a Webi document through the Folder iView that comes with the SAP (Portal) Integration Kit. Do you have any idea as to what could be wrong here? If I refresh the report, it seems like the data are fetched as they should be, but the following error occus just before rendering time:

Could not get page number. (Error: RWI 00223) (Error: INF)

Anyway, if you dont have any good ideas as to what could be the problem, could you please advice on how to highten til trace level in BO?

Thanks!

Martin Søgaard

Addition from trace file (tomcat):

com.businessobjects.rebean.wi.CommunicationException: Could not get page number. (Error: RWI 00223)

at com.businessobjects.rebean.wi.occa.OccaReportComAdapter.setBlobKey(OccaReportComAdapter.java:542)

at com.businessobjects.rebean.wi.occa.OccaReportComAdapter.getView(OccaReportComAdapter.java:376)

at com.businessobjects.rebean.wi.occa.OccaReportComAdapter.getView(OccaReportComAdapter.java:297)

at com.businessobjects.rebean.wi.ReportImpl.getView(ReportImpl.java:384)

at com.businessobjects.rebean.wi.ReportImpl.getView(ReportImpl.java:407)

at org.apache.jsp.viewers.cdz_005fadv.viewReport_jsp._jspService(viewReport_jsp.java:1182)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

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

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)

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

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

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

at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704)

at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:474)

at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:409)

at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)

at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:670)

at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:637)

at org.apache.jsp.viewers.cdz_005fadv.report_jsp._jspService(report_jsp.java:325)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

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

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)

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

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

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

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

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)

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

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

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

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

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

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

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

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)

at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)

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

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)

at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)

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

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

Edited by: Søgaard Martin on Jul 3, 2008 1:24 PM

[Former Member]

Hello Florencio

Of course, I'd like to know if you managed to solve the problem as well.

Kind regards,

Martin Søgaard

[Former Member]

hi,

try this http://www.forumtopics.com/busobj/viewtopic.php?t=90448 and see if it can solve your problem or not.

Edited by: jim ji on Jul 4, 2008 7:03 AM