WCA unknown error previewing OLAP in CMC

server administration XI Server Discussion
1

Hello All,

We are having a problem with our XI R2 install, relating to opening OLAP documents (pulling data from MS Analysis 2000 cube on seperate server) in the CMC

We are working with tech support, but they can’t recreate the problem on their end (but have used WebEx and have seen the problem occurring.)

Essential info:
Server Platform: Windows Server 2003 w/ SP1
Installed Products:
-BOE XI R2 - Java w/ Tomcat (IIS is installed & running, but www service is disabled. Also, Tomcat is configured to answer requests on port 80)
-OLAP XI R2
-CR XI R1 w/ latest CR XI update.

In InfoView, DHTML and ActiveX both work for OLAP documents. Assuming that DHTML is selected within InfoView as the OLAP viewer, then in the CMC, OLAP docs open with all viewers. Here’s where it gets strange. If I go back to InfoView and change my OLAP viewer to ActiveX, then only the DHTML viewer works when I try to preview OLAP documents. If I try to use any other viewer in the CMC to preview OLAP, I get the following error page:

WCA unknown error
Message:An undefined exception has occurred in the plugin

Stack Trace:
com.businessobjects.enterprise.wca.impl.WCAException$UnknownException: 
	at com.businessobjects.enterprise.wca.impl.internal.WebComponent.process(Native Method)
	at com.businessobjects.enterprise.wca.impl.internal.WebComponent.process(Unknown Source)
	at com.businessobjects.enterprise.wca.servlets.a.a(Unknown Source)
	at com.businessobjects.enterprise.wca.servlets.WCAControllerServlet$DefaultStrategy.apply(Unknown Source)
	at com.businessobjects.enterprise.wca.servlets.WCAControllerServlet.service(Unknown Source)
	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)

It gets better… If I go back to InfoView (didn’t even have to log out) and switch my OLAP viewer back to DHTML, I can go right back to CMC (didn’t even have to log out of that either) and now the other viewers work!

I’ve tried logging out and back in after making selections, but no-go. It seems that having the ActiveX viewer selected as preferred viewer for OLAP in InfoView somehow affects how the viewers work in CMC (sounds like it can’t be possible? Well, support verified that this seems to be the case.)

Oh, and Crystal Reports don’t seem to be affected by this at all, no matter what is selected as the CR viewer in InfoView or CMC, Crystal Reports seem to work just fine.

Anyway, I know that R2 is still so new, but if anyone has come across this and found a way to fix it, I would really appreciate hearing how, or even what the deal is with this.

Many Thanks,
Chad

CFetzer :us: (BOB member since 2005-12-15)

2

I am having an issue with authenicating to Analysis services from BOXI R2 sounds like you have at least gotten past the point where I am stuck. Did you have any issues with authenticating to analysis services running on another server? I can create connections but no cubes show up when I attempt to create an olap report using that connection.

rseese :us: (BOB member since 2005-09-21)

3

I did at first, but found out that the web server that you are using for XI must log in with an account that has permissions on the MSAS box. This is due to MS security constraints with MSAS.

We have a process ID that was created in the domain. I made that ID a member of the “OLAP Administrators” group. The next thing I did was to have the Tomcat service (or IIS WWW service) log in with the same account.

After that, it started working.

HTH,
C

CFetzer :us: (BOB member since 2005-12-15)

4

Also, make sure that you enable “drillthrough” on your cubes (right-click cube, “manage roles”.)

This alleviates sparodic problems when viewing OLAP docs that pull data from a MSAS box.

CFetzer :us: (BOB member since 2005-12-15)

5

Is the ok button on the connection authentication screen enabled without entering a username and password? In my environment I cannot proceed to select a cube until I authenticate and when I attempt to pass a domain account with rights to the cubes it displays nothing. This behavior is can be reproduced in full client only it gives me the option of not providing credentials and the current os user credentials are used.
Thanks for your help,
Robert

rseese :us: (BOB member since 2005-09-21)

6

Thank you for the detailed description Chad.

We are having the exact same situation on site at one of our customers. It would be very interesting to hear if you/BO have found any suitable solution to this problem. We have been searching and doing some testing without any luck so far!! :hb:

BR,
Bjarki

bjarkigu :iceland: (BOB member since 2005-12-01)

7

Hi Rseese, Cfter

I am trying to create an OLAP Intelligence Connection and OLAP Intelligence Report but is having difficulties.

Currently I cannot see any cube when I tried to create OLAPI report.

MSAS : Remote PC (Windows XP)
BOE: Windows 2003 Server, XIR2

Tomcat is running with domain\account,
domain account is added to MSAS and member of OLAP Administrator in Remote PC… IIS is running with local service.

Can you guys give more detail on how you get the cube to show up.

rs90144

rs90144 (BOB member since 2006-04-18)

8

More Info,

MSAS is the standard Foodmart 2000 cube and There is no OLAP Intelligenct rich client installed.

rs90144

rs90144 (BOB member since 2006-04-18)

9

We are seeing the exact same problem with our primary MSAS server. I can connect. We see no cubes after providing the appropriate Network credentials. The interesting thing is we have another MSAS server installed with copies of the same cubes and it sees them along with the Foodmart samples without any problems. I am currently trying to determine what is different between the 2 servers.

jefbuckeye (BOB member since 2006-01-07)

10

Any one of you got resolution for this issue…
pls update …

Thanks

Narne :india: (BOB member since 2005-12-02)