Hi, You can test your cubes and queries with REX or Mondrian Workbench: http://sourceforge.net/projects/whex http://mondrian.pentaho.org/documentation/workbench.php
Unfortunately, Tequila does not give very informative error messages (just null pointers). We are actually in the process of removing the dependency on Tequila for now (perhaps to be replaced later by another ESB like Mule). Knut On Tue, Nov 4, 2008 at 5:19 PM, Fabio D'Ovidio <[EMAIL PROTECTED]>wrote: > When OH try to query my new cube (cubo2): > > http://127.0.0.1:8180/openhealth-fp/prototype/olap/query/cubo2?columns=[Prenotazioni].Members,[OK].Members&rows=[Data.Data].[Tutto],[Provincia.Province].[Tutte%20le%20Province]&aggregate=&filter=&slicer=&_dc=1225815268234 > > It seems to fetch data because all POST requests like /levelmembers...., > /members..... are done, > but on GET request the error is: > * INFO 17:14:28,250 > cube=cubo2;columns=[Prenotazioni].Members,[OK].Members;columnsNonEmpty=null;rows=[Data.Data].[Tutto],[Provincia.Province].[Tutte > le Province];rowsNonEmpty=null;aggregate=null;filter=null;slicer=null > (SimpleOlap.java [http-8180-1]) > * INFO 17:14:28,250 > cube=cubo2;columns=[Prenotazioni].Members,[OK].Members;columnsNonEmpty=null;rows=[Data.Data].[Tutto],[Provincia.Province].[Tutte > le Province];rowsNonEmpty=null;aggregate=null;slicer=null (SimpleOlap.java > [http-8180-1]) > * INFO 17:14:28,250 Invoking generateMdxQuery with > cube=cubo2;columns=[Prenotazioni].Members,[OK].Members;columnsNonEmpty=null;rows=[Data.Data].[Tutto],[Provincia.Province].[Tutte > le Province];rowsNonEmpty=null;aggregate=null;filter=null;slicer=null > (MondrianOlapQueryProcessor.java [http-8180-1]) > * INFO 17:14:28,250 GenerateMdxQuery returns with value: SELECT > NON EMPTY > { > Crossjoin ({ > [Prenotazioni].Members} > ,{[OK].Members} > ) > } ON COLUMNS, > > NON EMPTY > { > Crossjoin ({ > [Data.Data].[Tutto]} > ,{[Provincia.Province].[Tutte le Province]} > ) > } ON ROWS > FROM [cubo2] > (MondrianOlapQueryProcessor.java [http-8180-1]) > * INFO 17:14:28,250 Invoking executeMdxQuery with argument: SELECT > NON EMPTY > { > Crossjoin ({ > [Prenotazioni].Members} > ,{[OK].Members} > ) > } ON COLUMNS, > > NON EMPTY > { > Crossjoin ({ > [Data.Data].[Tutto]} > ,{[Provincia.Province].[Tutte le Province]} > ) > } ON ROWS > FROM [cubo2] > (MondrianOlapQueryProcessor.java [http-8180-1]) > * INFO 17:14:29,218 ExecuteMdxQuery returns with value: null > (MondrianOlapQueryProcessor.java [http-8180-1]) > 4-nov-2008 17.14.29 org.apache.catalina.core.StandardWrapperValve invoke > GRAVE: Servlet.service() for servlet tequila threw exception > java.lang.NullPointerException > at > org.tequilaframework.core.web.view.renderer.StringRenderer.render(StringRenderer.java:53) > at > org.tequilaframework.core.web.controller.TequilaDispatcher.handleRequest(TequilaDispatcher.java:112) > at > org.tequilaframework.core.web.controller.integration.springmvc.SpringMVCTequilaController.handleRequestInternal(SpringMVCTequilaController.java:51) > at > org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) > at > org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) > at > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:857) > at > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:792) > at > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:461) > at > org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:416) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263) > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) > at > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584) > at > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) > at java.lang.Thread.run(Thread.java:619) > > -- > Fabio D'Ovidio > Geospatial solutions > > INOVA s.r.l. > Web : http://www.inovaos.it > Tel.: 081 197 57 600 > mail: [EMAIL PROTECTED] > > > My new qury will be this one: > browse.html?cube=cubo2&columns=[Prenotazioni].Members,[OK].Members&rows=[Data.Data].[Tutto],[Provincia.Province].[Tutte > le Province]&aggregate=&filter=&slicer= > > Knut Staring ha scritto: > >> On Tue, Nov 4, 2008 at 12:45 PM, Fabio D'Ovidio <[EMAIL PROTECTED]<mailto: >> [EMAIL PROTECTED]>> wrote: >> >> Hello. >> I want now to try change cube... >> I change my cubes.xml and my DB connection in the following files: >> >> * datasources.xml >> * hibernate.properties >> >> what about the other xml files in /WEB-INF/calsses directory such as >> openhealth.xml? >> >> >> openhealth.xml is just an old cube definition file. You control the name >> of your cube definition file in datasources.xml. >> >> Knut >> >> >> Thanks >> >> -- >> Fabio D'Ovidio >> Geospatial solutions >> >> INOVA s.r.l. >> Web : http://www.inovaos.it >> Tel.: 081 197 57 600 >> mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> >> >> _______________________________________________ >> Dhis-users mailing list >> [email protected] <mailto:[email protected]> >> http://www.hisp.info/mailman/listinfo/dhis-users >> >> >> >> >> -- >> Cheers, >> Knut Staring >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> Dhis-users mailing list >> [email protected] >> http://www.hisp.info/mailman/listinfo/dhis-users >> >> > > -- > Fabio D'Ovidio > Geospatial solutions > > INOVA s.r.l. > Web : http://www.inovaos.it > Tel.: 081 197 57 600 > mail: [EMAIL PROTECTED] > > > > _______________________________________________ > Dhis-users mailing list > [email protected] > http://www.hisp.info/mailman/listinfo/dhis-users > > -- Cheers, Knut Staring
_______________________________________________ Dhis-users mailing list [email protected] http://www.hisp.info/mailman/listinfo/dhis-users
