Connecting the CubeGrid with Pentaho Mondrian

[b.kazybaev]

Hey, Isomorphic

I am trying to connect to Pentaho Mondrian OLAP Server but I have faced with some problems.

I did:
1) Setted up test data(Foodmart) in a MySQL database
2) Deployed and run the web application in the Tomcat

I have attached the ServerLog.txt file.

Could you help me to solve the issue?

[b.kazybaev]

After doing some customizations I have resolved my issues.

[b.kazybaev]

Hey, Isomorphic

When I try to draw a chart from generated CubeGrid JavaScript exceptions occurs.
Stacktrace from Developer Console:

17:35:31.410:XRP5:WARN:CubeGrid:isc_CubeGrid_1:Component chartConstructor attribute set to "FacetChart" - this cannot be resolved to a valid SmartClient class. Verify that all appropriate modules are loaded and that this class exists.
17:38:23.031:MUP8:WARN:Log:TypeError: isc.ClassFactory.getClass(...) is null
Stack from error.stack:
    unnamed(isc_CubeGrid__finishChar) @ smartgwtolap/sc/modules/ISC_Analytics.js:404
    unnamed(isc_CubeGrid_makeChar) @ smartgwtolap/sc/modules/ISC_Analytics.js:401
    unnamed(isc_CubeGrid_showChartDialo) @ smartgwtolap/sc/modules/ISC_Analytics.js:407
    unnamed(isc_CubeGrid_chartLas) @ smartgwtolap/sc/modules/ISC_Analytics.js:395
    unnamed(anonymou) @ smartgwtolap/sc/modules/ISC_Core.js:65
    unnamed(isc_Menu_selectMenuIte) @ smartgwtolap/sc/modules/ISC_Grids.js:2416
    unnamed(isc_Menu_rowClic) @ smartgwtolap/sc/modules/ISC_Grids.js:2409
    unnamed(anonymou) @ smartgwtolap/sc/modules/ISC_Grids.js:658
    unnamed(isc_GridRenderer__rowClic) @ smartgwtolap/sc/modules/ISC_Grids.js:522
    unnamed(isc_c_Class_invokeSupe) @ smartgwtolap/sc/modules/ISC_Core.js:247
    unnamed(isc_c_Class_Supe) @ smartgwtolap/sc/modules/ISC_Core.js:240
    unnamed(isc_GridBody__rowClic) @ smartgwtolap/sc/modules/ISC_Grids.js:583
    unnamed(isc_GridRenderer_clic) @ smartgwtolap/sc/modules/ISC_Grids.js:520
    unnamed(isc_Canvas_handleClic) @ smartgwtolap/sc/modules/ISC_Core.js:2139
    unnamed(isc_c_EventHandler_bubbleEven) @ smartgwtolap/sc/modules/ISC_Core.js:1188
    unnamed(isc_c_EventHandler_handleClic) @ smartgwtolap/sc/modules/ISC_Core.js:1064
    unnamed(isc_c_EventHandler__handleMouseU) @ smartgwtolap/sc/modules/ISC_Core.js:1055
    unnamed(isc_c_EventHandler_handleMouseU) @ smartgwtolap/sc/modules/ISC_Core.js:1047
    unnamed(isc_c_EventHandler_dispatc) @ smartgwtolap/sc/modules/ISC_Core.js:1218
    unnamed(anonymou) @ smartgwtolap/sc/modules/ISC_Core.js:63
    unnamed() @

and Server Side Log:

Uncaught JavaScript exception [TypeError: isc.ClassFactory.getClass(...) is null] in http://127.0.0.1:8888/smartgwtolap/sc/modules/ISC_Analytics.js, line 404

How to resolve this issue?

[Isomorphic]

The Charting module has not been loaded (see Optional Modules overview).

[b.kazybaev]

Thank you for you answer! But when I click on chart in context menu an errors occurs.
ServerSide Log:

=== 2013-03-28 21:30:11,260 [l0-2] WARN  RequestContext - dsRequest.execute() failed: 
java.lang.NullPointerException
	at com.smartgwt.sample.server.OLAPDataSource.fetchRecordsAll(OLAPDataSource.java:32)
	at com.smartgwt.sample.server.OLAPDataSource.executeFetch(OLAPDataSource.java:23)
	at com.isomorphic.datasource.DataSource.execute(DataSource.java:1367)
	at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:726)
	at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658)
	at com.isomorphic.application.AppBase.execute(AppBase.java:491)
	at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2030)
	at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:216)
	at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:173)
	at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:138)
	at com.isomorphic.servlet.IDACall.doPost(IDACall.java:74)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
	at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:362)
	at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
	at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
	at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:729)
	at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
	at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
	at org.mortbay.jetty.handler.RequestLogHandler.handle(RequestLogHandler.java:49)
	at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
	at org.mortbay.jetty.Server.handle(Server.java:324)
	at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
	at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:843)
	at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:647)
	at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
	at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
	at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
	at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:488)
=== 2013-03-28 21:30:11,265 [l0-2] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
=== 2013-03-28 21:30:11,265 [l0-2] DEBUG RPCManager - non-DMI response, dropExtraFields: false
Uncaught JavaScript exception [TypeError: _1 is undefined] in http://127.0.0.1:8888/smartgwtolap/sc/modules/ISC_Charts.js, line 393chartConstructor attribute set to "FacetChart" - this cannot be resolved to a valid SmartClient class. Verify that all appropriate modules are loaded and that this class exists.

log from Development Mode in Eclipse:

21:30:11.490 [ERROR] [smartgwtolap] 21:30:11.487:XRP3:WARN:RPCManager:Server returned FAILURE with no error message performing operation 'custom'. - response: {operationId: "custom", clientContext: undef, context: Obj, transactionNum: 7, httpResponseCode: 200, httpResponseText: "//isc_RPCResponseStart-->[{invalidateCac..."[123], xmlHttpRequest: [object XMLHttpRequest], transport: "xmlHttpRequest", status: -1, clientOnly: undef, httpHeaders: Obj, isStructured: true, callbackArgs: null, results: Obj, invalidateCache: false, isDSResponse: true, queueStatus: -1, data: null}
com.smartgwt.client.core.JsObject$SGWT_WARN: 21:30:11.487:XRP3:WARN:RPCManager:Server returned FAILURE with no error message performing operation 'custom'. - response: {operationId: "custom", clientContext: undef, context: Obj, transactionNum: 7, httpResponseCode: 200, httpResponseText: "//isc_RPCResponseStart-->[{invalidateCac..."[123], xmlHttpRequest: [object XMLHttpRequest], transport: "xmlHttpRequest", status: -1, clientOnly: undef, httpHeaders: Obj, isStructured: true, callbackArgs: null, results: Obj, invalidateCache: false, isDSResponse: true, queueStatus: -1, data: null}
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at com.google.gwt.dev.shell.MethodAdaptor.invoke(MethodAdaptor.java:105)
    at com.google.gwt.dev.shell.MethodDispatch.invoke(MethodDispatch.java:71)
    at com.google.gwt.dev.shell.OophmSessionHandler.invoke(OophmSessionHandler.java:172)
    at com.google.gwt.dev.shell.BrowserChannelServer.reactToMessages(BrowserChannelServer.java:292)
    at com.google.gwt.dev.shell.BrowserChannelServer.pr

21:30:21.174 [ERROR] [smartgwtolap] 21:30:21.174:TMR9:WARN:FacetChart:isc_FacetChart_0:getChartRect(): chart rect not available yet
com.smartgwt.client.core.JsObject$SGWT_WARN: 21:30:21.174:TMR9:WARN:FacetChart:isc_FacetChart_0:getChartRect(): chart rect not available yet
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at com.google.gwt.dev.shell.MethodAdaptor.invoke(MethodAdaptor.java:105)
    at com.google.gwt.dev.shell.MethodDispatch.invoke(MethodDispatch.java:71)
    at com.google.gwt.dev.shell.OophmSessionHandler.invoke(OophmSessionHandler.java:172)
    at com.google.gwt.dev.shell.BrowserChannelServer.reactToMessages(BrowserChannelServer.java:292)
    at com.google.gwt.dev.shell.BrowserChannelServer.processConnection(BrowserChannelServer.java:546)
    at com.google.gwt.dev.shell.BrowserChannelServer.run(BrowserChannelServer.java:363)
    at java.lang.Thread.run(Thread.java:662)

21:30:21.237 [ERROR] [smartgwtolap] 21:30:21.176:TMR9:WARN:Log:TypeError: _1 is undefined
Stack from error.stack:
    unnamed(isc_FacetChart_mouseMov) @ smartgwtolap/sc/modules/ISC_Charts.js:393
    unnamed(isc_Canvas_handleMouseMov) @ smartgwtolap/sc/modules/ISC_Core.js:2137
    unnamed(isc_c_EventHandler_bubbleEven) @ smartgwtolap/sc/modules/ISC_Core.js:1188
    unnamed(isc_c_EventHandler___handleMouseMov) @ smartgwtolap/sc/modules/ISC_Core.js:1042
    unnamed(isc_c_EventHandler__handleMouseMov) @ smartgwtolap/sc/modules/ISC_Core.js:1028
    unnamed(isc_c_EventHandler__delayedMouseMov) @ smartgwtolap/sc/modules/ISC_Core.js:1028
    unnamed(isc_c_Class_fireCallbac) @ smartgwtolap/sc/modules/ISC_Core.js:256
    unnamed(isc_c_Timer__fireTimeou) @ smartgwtolap/sc/modules/ISC_Core.js:944
    unnamed() @ smartgwtolap/sc/modules/ISC_Core.js:940
    unnamed() @ 
com.smartgwt.client.core.JsObject$SGWT_WARN: 21:30:21.176:TMR9:WARN:Log:TypeError: _1 is undefined
Stack from error.stack:
    unnamed(isc_FacetChart_mouseMov) @ smartgwtolap/sc/modules/ISC_Charts.js:393
    unnamed(isc_Canvas_handleMouseMov) @ smartgwtolap/sc/modules/ISC_Core.js:2137
    unnamed(isc_c_EventHandler_bubbleEven) @ smartgwtolap/sc/modules/ISC_Core.js:1188
    unnamed(isc_c_EventHandler___handleMouseMov) @ smartgwtolap/sc/modules/ISC_Core.js:1042
    unnamed(isc_c_EventHandler__handleMouseMov) @ smartgwtolap/sc/modules/ISC_Core.js:1028
    unnamed(isc_c_EventHandler__delayedMouseMov) @ smartgwtolap/sc/modules/ISC_Core.js:1028
    unnamed(isc_c_Class_fireCallbac) @ smartgwtolap/sc/modules/ISC_Core.js:256
    unnamed(isc_c_Timer__fireTimeou) @ smartgwtolap/sc/modules/ISC_Core.js:944
    unnamed() @ smartgwtolap/sc/modules/ISC_Core.js:940
    unnamed() @ 
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at com.google.gwt.dev.shell.MethodAdaptor.invoke(MethodAdaptor.java:105)
    at com.google.gwt.dev.shell.MethodDispatch.invoke(MethodDispatch.java:71)
    at com.google.gwt.dev.shell.OophmSessionHandler.invoke(OophmSessionHandler.java:172)
    at com.google.gwt.dev.shell.BrowserChannelServer.reactToMessages(BrowserChannelServer.java:292)
    at com.google.gwt.dev.shell.BrowserChannelServer.processConnection(BrowserChannelServer.java:546)
    at com.google.gwt.dev.shell.BrowserChannelServer.run(BrowserChannelServer.java:363)
    at java.lang.Thread.run(Thread.java:662)

How to fix this issue?

[Isomorphic]

NOTE: if you are providing new information please make a new post, don't edit an existing post with entirely new information (as you did in this case). We do not receive a notification if you just edit a post.

The first error is the issue, the rest are just consequences.

It's an NPE in sample code from the wiki, so you can directly debug it to find the issue.

If you need our help, make sure you provide the complete server log for the failing request, and tell us what you've found from debugging the sample code.

[b.kazybaev]

Hey, Isomorphic

I need your help. A complete Server Log and Log from Development Mode in attachment.

And I did not find anything while debugging.
Could you show me your standard approach while debugging?

[Isomorphic]

This appears to be essentially the same log as before.

Our approach while debugging does not differ from standard Java/GWT debugging - in this case, find out what's null and why?

[b.kazybaev]

It seems to me that I caught a NPE. It occurs in the method:

IDACall.handleDSRequest(DSRequest, RPCManager, RequestContext) line: 242

Here are variables from Eclipse Debug Mode:

NAME                 VALUE
this	             IDACall  (id=95)	
dsRequest	     DSRequest  (id=194)	
rpc	             RPCManager  (id=208)	
context              RequestContext  (id=212)	
e	             NullPointerException  (id=213)	
errorToString        "java.lang.NullPointerException" (id=217)	
stack	             StackTraceElement[31]  (id=218)	
t	             NullPointerException  (id=213)

But I do not know why it occurs. I need your help, Isomorphic?

[Isomorphic]

This does not agree with your previous posted stack trace (see below). This stack shows that there was an NPE in OLAPDataSource.fetchRecordsAll() (sample code that you can easily debug yourself). The NPE which occurs in this method is simply being *caught and reported* in handleDSRequest.

java.lang.NullPointerException
at com.smartgwt.sample.server.OLAPDataSource.fetchRecordsAll(OLAPDataSource.java:31)
at com.smartgwt.sample.server.OLAPDataSource.executeFetch(OLAPDataSource.java:22)
at com.isomorphic.datasource.DataSource.execute(DataSource.java:1367)
at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:726)
at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658)
at com.isomorphic.application.AppBase.execute(AppBase.java:491)
at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2030)
at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:216)
at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:173)
at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:138)
at com.isomorphic.servlet.IDACall.doPost(IDACall.java:74)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:362)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:729)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.handler.RequestLogHandler.handle(RequestLogHandler.java:49)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:843)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:647)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:488)