[#SPAGOBI-2004] The whatif engine doesn`t work with sqlserver

[SPAGOBI-2004] The whatif engine doesn’t work with sqlserver Created:
19/Dec/14 Updated: 23/Dec/14 Resolved: 23/Dec/14
Status:
Project:
Component/s:
Affects
Version/s:
Fix Version/s:
Resolved
SpagoBI
SERVER/OLAP/WhatIf
5.1.0 RC
Type:
Reporter:
Resolution:
Labels:
Remaining
Estimate:
Time Spent:
Original
Estimate:
Bug
Alberto Ghedin
Fixed
None
Not Specified
Bug type:
Regression bug
None
Priority:
Assignee:
Votes:
Blocker
Alberto Ghedin
0
Not Specified
Not Specified
Description
Mondrian can't create the sql query.. it can’t resolve the schema.
it.eng.spagobi.utilities.engines.SpagoBIEngineRuntimeException: Error while executing MDX statement: Il nom
di oggetto 'TabellaFattiVend' non è valido.
at it.eng.spagobi.engines.whatif.WhatIfEngineInstance.<init>(WhatIfEngineInstance.java:135)
at it.eng.spagobi.engines.whatif.WhatIfEngineInstance.<init>(WhatIfEngineInstance.java:71)
at it.eng.spagobi.engines.whatif.WhatIfEngine.createInstance(WhatIfEngine.java:50)
at it.eng.spagobi.engines.whatif.common.WhatIfEngineStartAction.startAction(WhatIfEngineStartAction.java:8
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167)
at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:257)
at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:222)
at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:211)
at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:542)
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524)
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126)
at
org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:20
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
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:51)
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:194)
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:80)
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:42)
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:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
Caused by: com.eyeq.pivot4j.PivotException: org.olap4j.OlapException: mondrian gave exception while
executing query
at com.eyeq.pivot4j.impl.PivotModelImpl.getCellSet(PivotModelImpl.java:482)
at it.eng.spagobi.engines.whatif.model.SpagoBIPivotModel.getCellSet(SpagoBIPivotModel.java:46)
at it.eng.spagobi.engines.whatif.WhatIfEngineInstance.<init>(WhatIfEngineInstance.java:129)
... 46 more
Caused by: org.olap4j.OlapException: mondrian gave exception while executing query
at mondrian.olap4j.MondrianOlap4jConnection$Helper.createException(MondrianOlap4jConnection.java:840)
at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQueryInternal(MondrianOlap4jStatement.java:423)
at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQuery(MondrianOlap4jStatement.java:347)
at com.eyeq.pivot4j.impl.PivotModelImpl.executeMdx(PivotModelImpl.java:523)
at com.eyeq.pivot4j.impl.PivotModelImpl.getCellSet(PivotModelImpl.java:480)
... 48 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [sele
{[Measures].[Quantita]} ON COLUMNS,
{[Clienti]} ON ROWS
from [TabellaFattiVend]
]
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:972)
at mondrian.olap.Util.newInternal(Util.java:2403)
at mondrian.olap.Util.newError(Util.java:2419)
at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:706)
at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:51)
at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:622)
at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:621)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
... 3 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:mondrian.olap.MondrianException: Mondrian
Error:Failed to load segment form SQL
at mondrian.rolap.agg.SegmentLoader.loadImpl(SegmentLoader.java:240)
at mondrian.rolap.agg.SegmentLoader.access$000(SegmentLoader.java:51)
at mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:166)
at mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:140)
... 4 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:Failed to load segment form SQL
at mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:643)
at mondrian.rolap.agg.SegmentLoader.loadImpl(SegmentLoader.java:195)
... 7 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment;
sql=[select sum("TabellaFattiVend"."Quantita") as "m0" from "TabellaFattiVend" as "TabellaFattiVend"]
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:972)
at mondrian.olap.Util.newInternal(Util.java:2403)
at mondrian.olap.Util.newError(Util.java:2419)
at mondrian.rolap.SqlStatement.handle(SqlStatement.java:354)
at mondrian.rolap.SqlStatement.execute(SqlStatement.java:254)
at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:335)
at mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:625)
... 8 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Il nome di oggetto 'TabellaFattiVend' non è
valido.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:616)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
at mondrian.rolap.SqlStatement.execute(SqlStatement.java:201)
... 10 more
Comments
Comment by Alberto Ghedin [ 23/Dec/14 ]
Check to solve: http://wiki.spagobi.org/xwiki/bin/view/spagobi_server/WhatIf#HSQLserver
Generated at Thu Jun 01 00:33:35 CEST 2017 using JIRA 7.2.2#72004sha1:9d5132893cc8c728a3601a9034a1f8547ef5c7be.