Welcome to Knowage Q&A, where you can ask questions and receive answers from other members of the community.

Categories

Most popular tags

cockpit dataset error chart datasource installer datasets installation widget parameters business-model olap knowage knowage_7_1 integration login knowage_7_1-ce report-designer cross-navigation analyticaldriver

Error while sending the MDX query

0 votes
1 view
where Can I the logs to know the problem?
in Analytical Driver by (400 points)
we are having the same problem. schema validates on other Bi tools but error on Knowage
by (280 points)
reshown by

1 Answer

0 votes
Dear,

You should  check knowageWhatIf.log

Let me know

Angelo
by (20.7k points)
thank you for your answer, but this file doea not appear, the file I have is knowageWhatIfEngine.log

The log error I dont understand.

Also I am using PostgreSQL 9.2

My Mondrian Schema created using SQL Power Architect is the following:

thank you in advance.

<?xml version="1.0" encoding="UTF-8"?>
<Schema name="SCH_DM_TEST">
 <Dimension name="Pais" type="StandardDimension" caption="Pais">
  <Hierarchy name="Paises" hasAll="true" allLevelName="All" primaryKey="id_pais" caption="Paises">
   <Table name="Paises" schema="DM_Test.public"/>
   <Level name="Paises_level" column="Pais" uniqueMembers="true" caption="Paises_level"/>
  </Hierarchy>
 </Dimension>
 <Cube name="Ventas" caption="Ventas">
  <Table name="Ventas" schema="DM_Test.public"/>
  <DimensionUsage source="Pais" name="Pais" caption="Pais_Rel_Cube" foreignKey="id_pais"/>
  <Measure name="MontoVentas" column="ventas" aggregator="sum"/>
 </Cube>
</Schema>
 

05 Dec 2017 16:00:32,492 ERROR it.eng.spagobi.engines.whatif.model.PivotJsonHTMLSerializer.serialize:296 - Error serializing the pivot table

java.lang.NullPointerException

at it.eng.spagobi.engines.whatif.calculatedmember.MDXFormulaHandler.loadFile(MDXFormulaHandler.java:74)

at it.eng.spagobi.engines.whatif.calculatedmember.MDXFormulaHandler.getFormulasFromXML(MDXFormulaHandler.java:84)

at it.eng.spagobi.engines.whatif.calculatedmember.MDXFormulaHandler.getFormulas(MDXFormulaHandler.java:96)

at it.eng.spagobi.engines.whatif.model.PivotJsonHTMLSerializer.serializeFunctions(PivotJsonHTMLSerializer.java:382)

at it.eng.spagobi.engines.whatif.model.PivotJsonHTMLSerializer.serialize(PivotJsonHTMLSerializer.java:280)

at it.eng.spagobi.engines.whatif.model.PivotJsonHTMLSerializer.serialize(PivotJsonHTMLSerializer.java:76)

at com.fasterxml.jackson.databind.ser.DefaultSerializerProvider.serializeValue(DefaultSerializerProvider.java:108)

at com.fasterxml.jackson.databind.ObjectMapper._configAndWriteValue(ObjectMapper.java:2407)

at com.fasterxml.jackson.databind.ObjectMapper.writeValueAsString(ObjectMapper.java:1983)

at it.eng.spagobi.engines.whatif.model.PivotJsonSerializer.serialize(PivotJsonSerializer.java:49)

at it.eng.spagobi.engines.whatif.model.PivotJsonSerializer.serialize(PivotJsonSerializer.java:32)

at it.eng.spagobi.engines.whatif.serializer.SerializationManager.serialize(SerializationManager.java:121)

at it.eng.spagobi.engines.whatif.common.AbstractWhatIfEngineService.serialize(AbstractWhatIfEngineService.java:141)

at it.eng.spagobi.engines.whatif.common.AbstractWhatIfEngineService.renderModel(AbstractWhatIfEngineService.java:81)

at it.eng.spagobi.engines.whatif.api.ModelResource.setMdx(ModelResource.java:174)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)

at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:294)

at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:248)

at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:235)

at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:398)

at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:205)

at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:228)

at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)

at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at it.eng.spagobi.utilities.filters.SpagoBIAccessFilter.doFilter(SpagoBIAccessFilter.java:206)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at it.eng.spagobi.utilities.filters.EngineCheckSessionFilter.doFilter(EngineCheckSessionFilter.java:92)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at it.eng.spagobi.utilities.filters.EncodingFilter.doFilter(EncodingFilter.java:54)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:409)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1044)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)
by (400 points)

I meet the problem too.

my operations are follow:

  1. create foodmart_demo in mysql database

  2. in datasource create new one .the url is "jdbc:mysql://localhost:3306/foodmart_demo"

  3.download a mondrian document from a demo project. (I attached it )

  4.in document development. create "Generic Document"

  5.set Type is "on-line analytical processing"

  whether I choice Engine "What-If Engine" or "OLAP Engine". At the time I edit "Template build". Set "Select type of Template" is "Mondrian" ,Set "Select Mondrian Schema" is "footmart",Set "select Cube" is "Sales".if I click "START",The Error Message "Error An error occurred while sending MDX query" show on the new webpage.

the full stack error message is : 

https://www.knowage-suite.com/qa/?qa=blob&qa_blobid=10251724128111848616

this is foormart.xml

https://www.knowage-suite.com/qa/?qa=blob&qa_blobid=10071733497416798658

by (100 points)
reshown by

I meet the problem too.

my operations are follow:

  1. create foodmart_demo in mysql database

  2. in datasource create new one .the url is "jdbc:mysql://localhost:3306/foodmart_demo"

  3.download a mondrian document from a demo project. (I attached it )

  4.in document development. create "Generic Document"

  5.set Type is "on-line analytical processing"

  whether I choice Engine "What-If Engine" or "OLAP Engine". At the time I edit "Template build". Set "Select type of Template" is "Mondrian" ,Set "Select Mondrian Schema" is "footmart",Set "select Cube" is "Sales".if I click "START",The Error Message "Error An error occurred while sending MDX query" show on the new webpage.

the full stack error message is : 

https://www.knowage-suite.com/qa/?qa=blob&qa_blobid=10251724128111848616

this is foormart.xml

https://www.knowage-suite.com/qa/?qa=blob&qa_blobid=10071733497416798658

by (100 points)
More Info...

I created the mondrian schema with SQL Power Architect and it works perfect using Wabit.

but Knowage raise the error.

I hope to found soon a solution.
by (400 points)

HI  alvarohenriquez777:

 I sloved the problem. The runtime contianer (Tomcat) lost a key file in webapps/knowagewhatifengine

I make two folders "Olap" and "calculated_fields_formulas" which contains a  formulas.xml  you can find at ${Knowage-Server-CE}/resources/DEMO/Olap ,And copy both folders  to the path ${Knowage-Server-CE}/webapps/knowagewhatifengine  ,  ${Knowage-Server-CE}/webapps/knowagewhatifengine/WEB-INF  ,${Knowage-Server-CE}/webapps/knowagewhatifengine/WEB-INF/resources  and ${Knowage-Server-CE}/webapps/knowagewhatifengine/WEB-INF/classes

if you want make sure which path is right ,you can read https://github.com/KnowageLabs/Knowage-Server/blob/master/knowagewhatifengine/src/main/java/it/eng/spagobi/engines/whatif/calculatedmember/MDXFormulaHandler.java

line number is 70 . I think the developer forgot to pack the formulas.xml  in the build time.

by (100 points)
reshown by
Hello, I have the same error and tried to resolved following your instructions, but I don't have the DEMO folder, so I couldn't copy the folders. I also tried to manually creating the folders, but it didn't work.

¿Can you send me the folders in a zip file?

Thank you.
Regards.
by (100 points)
Hello all,

I dont have Demo also, and my WhatIf engine is not working with same error.

Can anyone be kind to post formulas.xml, or its content.

Regards
by (100 points)
we are having the same problem. schema validates on other Bi tools but error on Knowage
by (280 points)
can anyone help us get the formulas.xml file? cheers
by (280 points)
Powered by Question2Answer
...