WD and BI - Error with SLICER_MEMBER

[Former Member]

Hi:

This is the error:

com.sap.ip.bi.sdk.exception.BIJmiVerifyException: Cannot retrieve the result set

at com.sap.ip.bi.sdk.dac.olap.query.impl.QueryExecuterImpl.executeNativeQuery(QueryExecuterImpl.java:207)

at com.sap.ip.bi.sdk.dac.olap.query.impl.QueryExecuterImpl.execute(QueryExecuterImpl.java:79)

at com.sap.ip.bi.sdk.dac.olap.query.main.IBIQueryImpl.execute(IBIQueryImpl.java:233)

at com.repsol.cubo.test.CuboTestView.wdDoInit(CuboTestView.java:189)

at com.repsol.cubo.test.wdp.InternalCuboTestView.wdDoInit(InternalCuboTestView.java:149)

at com.sap.tc.webdynpro.progmodel.generation.DelegatingView.doInit(DelegatingView.java:61)

at com.sap.tc.webdynpro.progmodel.controller.Controller.initController(Controller.java:215)

at com.sap.tc.webdynpro.progmodel.view.View.initController(View.java:275)

at com.sap.tc.webdynpro.progmodel.controller.Controller.init(Controller.java:200)

at com.sap.tc.webdynpro.progmodel.view.ViewManager.getView(ViewManager.java:539)

at com.sap.tc.webdynpro.progmodel.view.ViewManager.bindRoot(ViewManager.java:421)

at com.sap.tc.webdynpro.progmodel.view.ViewManager.init(ViewManager.java:130)

at com.sap.tc.webdynpro.progmodel.view.InterfaceView.initController(InterfaceView.java:41)

at com.sap.tc.webdynpro.progmodel.controller.Controller.init(Controller.java:200)

at com.sap.tc.webdynpro.clientserver.cal.ClientComponent.displayToplevelComponent(ClientComponent.java:135)

at com.sap.tc.webdynpro.clientserver.cal.ClientApplication.init(ClientApplication.java:404)

at com.sap.tc.webdynpro.clientserver.task.WebDynproMainTask.execute(WebDynproMainTask.java:618)

at com.sap.tc.webdynpro.clientserver.cal.AbstractClient.executeTasks(AbstractClient.java:59)

at com.sap.tc.webdynpro.clientserver.cal.ClientManager.doProcessing(ClientManager.java:251)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doWebDynproProcessing(DispatcherServlet.java:154)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doContent(DispatcherServlet.java:116)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doGet(DispatcherServlet.java:48)

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

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

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:401)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:266)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:387)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:365)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:944)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:266)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:95)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:160)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:100)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:170)

Caused by: com.sap.ip.bi.sdk.exception.BIResourceException: Cannot get data set

at com.sap.ip.bi.sdk.dac.connector.xmla.XmlaOlap.executeInternal(XmlaOlap.java:209)

at com.sap.ip.bi.sdk.dac.olap.query.impl.QueryExecuterImpl.executeNativeQuery(QueryExecuterImpl.java:202)

... 37 more

Caused by: com.sap.ip.bi.sdk.exception.BIResourceException: Cannot get data set

at com.sap.ip.bi.sdk.dac.connector.xmla.XmlaOlap.execute(XmlaOlap.java:189)

at com.sap.ip.bi.sdk.dac.connector.xmla.XmlaOlap.executeInternal(XmlaOlap.java:205)

... 38 more

Caused by: com.sap.ip.bi.sdk.exception.BIResourceException: SOAP request failed with return message 2147483653 ( Invalid MDX command with SLICER_MEMBER)

at com.sap.ip.bi.sdk.dac.connector.xmla.impl.Connection$ProxyWrapper.execute(Connection.java:1776)

at com.sap.ip.bi.sdk.dac.connector.xmla.impl.Connection.getDataSet(Connection.java:364)

at com.sap.ip.bi.sdk.dac.connector.xmla.XmlaOlap.execute(XmlaOlap.java:186)

... 39 more

Caused by: javax.xml.rpc.soap.SOAPFaultException: Invalid MDX command with SLICER_MEMBER

at com.sap.ip.bi.sdk.dac.connector.xmla.impl.ServerProxy.execute(ServerProxy.java:149)

at com.sap.ip.bi.sdk.dac.connector.xmla.impl.Connection$ProxyWrapper.execute(Connection.java:1771)

... 41 more

I can't find doc about this error.

Thanks for your time on this thread.

Rocío.

[Former Member]

Note 966414 - Invalid MDX command with

check this one!