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 Generic Document OLAP

0 votes
1 view 
When trying to create a generic document OLAP, by loading a mondrian cube. The error is shown

Environment Knowage 6.2, Windows 10 Pro x64, Google Chrome 68
in OLAP and What-If by (120 points)
Please have a look at the KnowageWhatIf.log file to see in detail what is the error.
by (11.6k points)

1 Answer

0 votes
Hi, in my experience there is often something wrong with the cube definition or the MDX query. Make sure that both MDX and your cube are vaild before you use them in KNOWAGE. I use pentaho schema workbench for this, but there are probably other possibilities as well.
by (2.6k points) 
It looks like the error is in the mdx query, but I still can not resolve.
Follow the log

Caused by: org.pivot4j.PivotException: org.olap4j.OlapException: mondrian gave exception while executing query

at org.pivot4j.impl.PivotModelImpl.getCellSet(PivotModelImpl.java:598)

at it.eng.spagobi.engines.whatif.model.SpagoBIPivotModel.getCellSet(SpagoBIPivotModel.java:145)

at it.eng.spagobi.engines.whatif.WhatIfEngineInstance.updateWhatIfEngineInstance(WhatIfEngineInstance.java:228)

... 43 more

Caused by: org.olap4j.OlapException: mondrian gave exception while executing query

at mondrian.olap4j.MondrianOlap4jConnection$Helper.createException(MondrianOlap4jConnection.java:858)

at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQueryInternal(MondrianOlap4jStatement.java:423)

at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQuery(MondrianOlap4jStatement.java:347)

at org.pivot4j.impl.PivotModelImpl.executeMdx(PivotModelImpl.java:646)

at org.pivot4j.impl.PivotModelImpl.getCellSet(PivotModelImpl.java:596)

... 45 more

Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[Quantidade]} ON COLUMNS,

  {[TipoSolicitacao]} ON ROWS

from [UniSolicitacao]

]

at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:977)

at mondrian.olap.Util.newInternal(Util.java:2404)

at mondrian.olap.Util.newError(Util.java:2420)

at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:707)

at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52)

at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:623)

at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:622)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

... 3 more

Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select sum("FatoSolitacaoQuantidade"."Quantidade") as "m0" from "dbo"."FatoSolitacaoQuantidade" as "FatoSolitacaoQuantidade"]

at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:977)

at mondrian.olap.Util.newInternal(Util.java:2404)

at mondrian.olap.Util.newError(Util.java:2420)

at mondrian.rolap.SqlStatement.handle(SqlStatement.java:361)

at mondrian.rolap.SqlStatement.execute(SqlStatement.java:252)

at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:350)

at mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:625)

... 8 more

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Nome de objeto 'dbo.FatoSolitacaoQuantidade' inválido.

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:885)

at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:778)

at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:191)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:166)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:677)

at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)

at mondrian.rolap.SqlStatement.execute(SqlStatement.java:199)

... 10 more

by (120 points)
Powered by Question2Answer
...