[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.