Error when trying to display a Webi report through the Folder iView

[Former Member]

Hi all

I am getting the following error when Im trying to display a Webi report through the SAP Portal. We have installed the SAP Integration Kit and are able to see the content of the Infoview. However when we click on a Webi report, we receive the following error:

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

Have anyone else encountered this problem? Please assist! Any help will be rewarded.

(We are running XI Rel 2).

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)

Furthermore I'd like to see an example of the cms_name entry. The documentation states: In addition, specify the Application Parameter for each iView. For this property, enter cms_name=[cms] for the fully qualified server name., but I have doubts as to what format to use.

Kind regards,

Martin Søgaard

[Former Member · Accepted solution]

hi Søgaard ,

Issue is not caused by Folder Iview. Can you view this webi report when you log on to infoview, not from iview? I think you will meet the same error. After google search, I find this http://www.forumtopics.com/busobj/viewtopic.php?t=90448, which may solve you problem

[Former Member · Accepted solution]

Hi Jim Ji

The report can be displayed from the java infoview, no doubt, so the report itself works.

But the report cannot be seen from the "SAP Infoview" (

:

/businessobjects/enterprise115/sap) which is the infoview, I reference from the Folder iView (through the system in the SAP portal). And since the SAP Portal Integration Kit seems very old - the Folder iView was created 12-08-2004 by Ingo Hilgefort - there might be an old version of the jar-files somewhere in the installation.

I guess I should check the version of the jar-files in WEB-INF/lib of our web application (Tomcat) folder, and see if they have been overwritten by the SAP Portal Integration Installation or are an older version of the files in Program FilesBusiness Objectscommon3.5javalib? And also check if somewhere in the .../sap installation there are some old jar-files?

Kind regards,

Martin Søgaard

[Former Member · Accepted solution]

Hi Jim Ji

Thanks for the answer, it worked!

I replaced all the jar files in ...Program FilesBusiness ObjectsTomcatwebapps usinessobjectsenterprise115sapdesktoplaunchWEB-INFlib with the jars in ...Program FilesBusiness Objectscommon3.5javalib, and the end users were able to open the reports.

I guess this is a procedure that has to be done every time you upgrade BO?

Kind regards,

Martin Søgaard

[Former Member · Accepted solution]

hi Søgaard,

In which FixPack or Service Pack did you encourter this problem?

[Former Member · Accepted solution]

Hi Jim Ji

We did a reinstall of service pack 3, and the problem was still there.

Kind regards,

Martin

[Former Member · Accepted solution]

Thanks for the answer, it worked!

I replaced all the jar files in ...\Program Files\Business Objects\Tomcat\webapps\businessobjects\enterprise115\sap\desktoplaunch\WEB-INF\lib with the jars in ...\Program Files\Business Objects\common\3.5\java\lib, and the end users were able to open the reports.

HOWEVER....

This solution has created new issue for us. Now when we try to create new Webi report it gives error like,

"The Web Intelligence Java Report Panel cannot connect to the server. Close the report and try to connect again or see you BusinessObjects administrator. (Error: WIJ 20002)"

working on BO XI R2; SP-3.

Thanks in advance.

:- Vills

Edited by: Vills on Jan 28, 2009 8:27 AM

[Former Member]

Hello Martin,

Please refer to my reply from the following thread on details on how you can access Webi reports using URL Iviews:

Another option for you is to use the Knowledge Management and Collaboration solution to access your Webi documents. Please refer to the BusinessObjects XI Integration for SAP Installation Guide for details around the KMC solution.

<<<

https://websmp204.sap-ag.de/~form/sapnet?_SHORTKEY=01100035870000712716&_SCENARIO=011000358700000002...

>>>

thanks,

Mike

[Former Member]

Hi Mike

Thanks a lot for your post.

Can you please explain to me why the Folder Iview works in order to see Webi documents, and not only Crystal Reports? According to your other post, that should not be the case, should it?

Kind regards,

Martin Søgaard