US and Worldwide: +1 (866) 660-7555
Results 1 to 6 of 6

Thread: MS SSAS Problem to connecto via XMLA

  1. #1
    Join Date
    Apr 2012
    Posts
    3

    Default MS SSAS Problem to connecto via XMLA

    Hi,
    I`m trying to connect Pentaho BI Server 4.5 with SSAS (SQL Server 2008). I can connect and view cubes using Saiku server but when i try to create a connection in Admin Consolo in BI Server i get an error.

    I'm using olap4j.xmla for create de connection in Saiku and also in Pentaho.

    I review the logs of Console Admin, and found the following errori( have already installed the driver in admin-console/jdbc):

    08:25:06,378 ERROR [/] Exception while dispatching incoming RPC call
    com.google.gwt.user.server.rpc.UnexpectedException: Service method 'public abstr
    act boolean org.pentaho.pac.client.PacService.testDataSourceConnection(org.penta
    ho.pac.common.datasources.PentahoDataSource) throws org.pentaho.pac.common.PacSe
    rviceException' threw an unexpected exception: java.lang.NoClassDefFoundError: C
    ould not initialize class org.olap4j.driver.xmla.XmlaOlap4jDriver

    at com.google.gwt.user.server.rpc.RPC.encodeResponseForFailure(RPC.java:
    378)
    at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:5
    81)
    at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(Remot
    eServiceServlet.java:188)
    at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(Remot
    eServiceServlet.java:224)
    at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(Ab
    stractRemoteServiceServlet.java:62)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487
    )
    at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:3
    67)
    at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:1
    81)
    at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:7
    12)
    at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.
    java:114)
    at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:1
    39)
    at org.mortbay.jetty.Server.handle(Server.java:285)
    at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:50
    2)
    at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnectio
    n.java:835)
    at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:638)
    at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:202)
    at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:378)
    at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.
    java:226)
    at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool
    .java:450)
    Caused by: java.lang.NoClassDefFoundError: Could not initialize class org.olap4j
    .driver.xmla.XmlaOlap4jDriver
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:169)
    at org.pentaho.pac.server.PacServiceImpl.getDataSourceConnection(PacServ
    iceImpl.java:582)
    at org.pentaho.pac.server.PacServiceImpl.testDataSourceConnection(PacSer
    viceImpl.java:610)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
    java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
    sorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:5
    62)
    ... 19 more
    -
    Thanks,

    Julio

  2. #2

    Default

    Did you add the olap4j-xmla.jar file to your library path already? That jar file contains the driver you are referencing. I have no experience with Pentaho BI Server myself, but you can try downloading the olap4j files from here and put the jar I mentioned (the olap4j-[version].zip file contains it) on the classpath / library directory of Pentaho BI Server. That should do the trick.

  3. #3
    Join Date
    Apr 2012
    Posts
    3

    Default

    Thanks dknippers,

    Yes, I do that. The drivers are located in the library and also in the console library. But still not work. I gave the same error.

    other suggestions?

    Thanks in advanced.

  4. #4

    Default

    I am afraid the issue is really related to not having the .jar in the Java CLASSPATH, somehow. That's pretty much always the cause (as far as I know) of getting the 'NoClassDefFound' error. Make sure you have done something similar as in this guide on setting your CLASSPATH.

    If it still does not work I hope others can help you :-)

  5. #5
    Join Date
    Apr 2013
    Posts
    2

    Default

    Hi Julio
    Can you please share how you have configured Pentaho BI Server 4.5 with SSAS (SQL Server 2008) and view cubes using Saiku server?
    I am struggling to get that work first.

    Thanks in advance
    Vinoth

  6. #6
    Join Date
    Apr 2012
    Posts
    3

    Default

    Hi Vinoth,
    Unfortunatelly, i cannot get that Pentaho BI 4.5 works with SSAS. At the end, I used mySql and Mondrian for the cubes. I read somewhere that exist a bug in pentaho with SSAS and is not fixed right now.


    Maybe you can try using saiku server alone, and connecting to XMLA to SSAS. There are several samples in the web to do it.






    Regards,
    Julio





    Quote Originally Posted by vinothindia View Post
    Hi Julio
    Can you please share how you have configured Pentaho BI Server 4.5 with SSAS (SQL Server 2008) and view cubes using Saiku server?
    I am struggling to get that work first.

    Thanks in advance
    Vinoth

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •