0 Replies Latest reply: Oct 30, 2008 5:36 AM by 634173 RSS

    MemberStep problem

    634173
      Hi,

      i have problem with using Steps. All steps except "AllStep" are not working properly and throwing QueryRuntimeException, but i am unable to find out, what is the reason.

      1. When I use this code in page, it works fine, and chosen level is selected:

      Presentation pres1 = (Presentation)pageContext.findAttribute("trzba_test3_pres1");
      ThinDataviewCommon crosstab = (ThinDataviewCommon)pres1.getView();
      QueryClient query = (QueryClient)crosstab.getDataSource();

      Selection sel = query.findSelection("MDM!D_MIS.MIS3_V2_ID_CAS");
      sel.setHierarchy("MDM!D_MIS.MIS3_V2_ID_CAS.RKMTD");
      sel.removeAllSteps();

      Vector vec = new Vector();
      vec.addElement("MDM!D_MIS.MIS3_V2_ID_CAS.RKMTD.L.MESIC");
      AllStep allStep = new AllStep("MDM!D_MIS.MIS3_V2_ID_CAS");
      allStep.setLevels(vec);

      sel.addStep(allStep);
      query.applySelection(sel);
      query.refreshAll();

      2. When I use MemberStep to select some of the members, it leads to exception:

      Presentation pres1 = (Presentation)pageContext.findAttribute("trzba_test3_pres1");
      ThinDataviewCommon crosstab = (ThinDataviewCommon)pres1.getView();
      QueryClient query = (QueryClient)crosstab.getDataSource();

      Selection sel = query.findSelection("MDM!D_MIS.MIS3_V2_ID_CAS");
      sel.setHierarchy("MDM!D_MIS.MIS3_V2_ID_CAS.RKMTD");
      sel.removeAllSteps();

      Vector vec = new Vector();
      vec.addElement("MESIC_200801");
      vec.addElement("MESIC_200802");
      vec.addElement("MESIC_200803");
      MemberStep ms = new MemberStep("MDM!D_MIS.MIS3_V2_ID_CAS");
      ms.addMembers(vec);

      sel.addStep(ms);
      query.applySelection(sel);
      query.refreshAll();

      Exception:

      oracle.dss.dataSource.common.QueryException:
      Step: oracle.dss.selection.step.MemberStep;
      Enabled: true Valid: true Action: SELECT; Dimension: MDM!D_MIS.MIS3_V2_ID_CAS; Hierarchy: MDM!D_MIS.MIS3_V2_ID_CAS.RKMTD
      Member array: [MESIC_200801, MESIC_200802, MESIC_200803]
      RangeCollection:[]
      oracle.dss.dataSource.LocalStepRuntimeException:
      Step: oracle.dss.selection.step.MemberStep;
      Enabled: true Valid: true Action: SELECT; Dimension: MDM!D_MIS.MIS3_V2_ID_CAS; Hierarchy: MDM!D_MIS.MIS3_V2_ID_CAS.RKMTD
      Member array: [MESIC_200801, MESIC_200802, MESIC_200803]
      RangeCollection:[]
           oracle.dss.dataSource.common.Query.exceptionThrower(Query.java:2281)
           oracle.dss.dataSource.QueryServer.applySelection(QueryServer.java:2338)
           sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
           sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
           java.lang.reflect.Method.invoke(Unknown Source)
           oracle.dss.util.Operation.execute(Operation.java:72)
           oracle.dss.dataSource.QueryManagerServer.sendQueue(QueryManagerServer.java:2001)
           oracle.dss.dataSource.common.OperationQueue.update(OperationQueue.java:207)
           oracle.dss.dataSource.common.BaseOperationQueue.addOperation(BaseOperationQueue.java:176)
           oracle.dss.dataSource.common.BaseOperationQueue.addOperation(BaseOperationQueue.java:146)
           oracle.dss.dataSource.common.OperationQueue.addOperation(OperationQueue.java:127)
           oracle.dss.dataSource.client.QueryClient.applySelection(QueryClient.java:1398)
           org.apache.jsp.trzba_005ftest_005fMS_jsp._jspService(trzba_005ftest_005fMS_jsp.java:156)
           org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
           javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
           org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
           org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
           org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
           javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

      I imported this project from JDev9.0.4 (BiB 9.0.4) to Jdev 10.1.2.2 with BiB 10.1.2.2 installed. Everything works fine, but i can't make Steps working.

      Thanks for any advice!
      Vlcik