3 Replies Latest reply: Jul 27, 2010 2:36 PM by JohnGoodwin RSS

    ODI Essbase Reverse engineering fails RKM essbase

    787672
      I am trying to integrate Flat file metadata with a sample BSO app. using 10.1.3.5
      Have defined the topology, created an agent .... but when i TEST the connection from Essbase data server (in physical architecture) i get the following error :
      Note that my server and client are on the same machine (localhost) and i think i am defining the DataServer field incorrectly.

      java.lang.Exception:
           at com.sunopsis.graphical.l.pm.a(pm.java)
           at com.sunopsis.graphical.l.pm.s(pm.java)
           at com.sunopsis.graphical.l.pm.g(pm.java)
           at com.sunopsis.graphical.l.pm.a(pm.java)
           at com.sunopsis.graphical.l.pm.a(pm.java)
           at com.sunopsis.graphical.l.iz.actionPerformed(iz.java)
           at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
           at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Unknown Source)
           at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
           at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
           at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
           at java.awt.Component.processMouseEvent(Unknown Source)
           at java.awt.Component.processEvent(Unknown Source)
           at java.awt.Container.processEvent(Unknown Source)
           at java.awt.Component.dispatchEventImpl(Unknown Source)
           at java.awt.Container.dispatchEventImpl(Unknown Source)
           at java.awt.Component.dispatchEvent(Unknown Source)
           at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
           at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

      Later, at the RKM Essbase stage i get the famous java error :

      org.apache.bsf.BSFException: exception from Jython:
      Traceback (innermost last):
      File "<string>", line 1, in ?
      ImportError: no module named java
           at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)
           at com.sunopsis.dwg.codeinterpretor.k.a(k.java)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTas......

      YELP !!
        • 1. Re: ODI Essbase Reverse engineering fails RKM essbase
          JohnGoodwin
          First of all you cannot click the test button, that is only for jdbc type technologies.

          The other error seems to indicate it can't see any of the java components which learns more to an installation issue.

          Cheers

          John
          http://john-goodwin.blogspot.com/
          • 2. Re: ODI Essbase Reverse engineering fails RKM essbase
            787672
            1) ok, could it be b'coz i jus hav JRE running and not the JDK 6 ?

            2) John - on a different note; Is it possible to confirm if the ODI has connected successfully with Essbase while we are in the Topology Mngr.
            See, earlier when i 'Test' the essbase physical connection i would normally get an error on the lines of +'JDBC driver missing/invalid ...'+ jus like u say.
            But until then i had not created any Agent....after reading yur blog i created one and I wondered if i selected the logical agent in the Essbase (Physical architec), i could get ODI to confirm whether the essbase connection has set successfully (i.e, even before i go to the Designer) but just selecting an agent - That gave me a totally different error !!

            Will indulge in some more hands-on later today and keep everybody updated .
            • 3. Re: ODI Essbase Reverse engineering fails RKM essbase
              JohnGoodwin
              using a JRE should not make any difference that is pretty standard.
              The only real way you know if you can connect is when the reverse is run, if there is a problem an essbase error will be generated which can be view in the operator.
              Using an agent will not really make any difference in that respect.

              Cheers

              John
              http://john-goodwin.blogspot.com/