3 Replies Latest reply: May 23, 2013 12:19 PM by JohnGoodwin RSS

    HP in use for ODI reverse model, - Error ODI: 20616

    korrq
      Dear Gurus and Experts.


      -----------------------------------------------------------------------------------------------------------------------------------------------
      This is tread in ODI forum.
      Title: Unable to Perform Reverse Engineering, of Hyperion Planning in ODI 11.1.1.6
      _url:https://forums.oracle.com/forums/thread.jspa?threadID=2539109&tstart=0
      -----------------------------------------------------------------------------------------------------------------------------------------------

      share here also to get a light

      The error is not cataloged in the document Fusion Middleware Error Code List e10113.pdf


      I also tried changing the parameters in ODIPARAMS.bat, but the error message persists.
      ------------------------------------------------------------------------------------------------------------------------------------------------
      Error Context >>>>>


      I'm trying to reverse engineer had made a model of the Hyperion Planning.

      After configuring the topology.

      Steps:

      A)

      Physical Architecture:
      machine.mycompany.com: 11333, user / pdw (here's Hyperion Planning)
      Physical Layout:
      Catalog Application - I wrote: myapphp
      Implementation and Application of Work - I wrote: myapphp

      1_doubt:
      I expected to be able to select the physical layout, the field catalog application, an application name that is in Hyperion Planning.
      But I saw that does not work well. I had to enter.
      is this right? or just this wrong in my settings?

      B)
      Logical Architecture:
      Context: Global
      Associated with LS_HP_myapp

      C)
      In Contexts:
      Global, contains the association.
      logical scheme: LS_HP_myapp for Physical Schema: myapphp

      D)
      In Designer.
      I want to reverse engineer;
      Criated a folder, added a model;
      name: mymodelhp, selected technology: hyperion planning
      logical schema: LS_HP_myapp
      em group of generic actions.
      Saved.

      E)
      And clicked on Reverse Engineering
      Then the error ODI: 20616 Failed Reverse Engineering Standard.

      details:
      ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
      java.util.concurrent.ExecutionException: java.lang.IllegalArgumentException: Driver name cannot be empty
      at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222)
      at java.util.concurrent.FutureTask.get(FutureTask.java:83)
      at com.sunopsis.graphical.tools.utils.swingworker.SwingWorker.get(SwingWorker.java:476)
      at com.sunopsis.graphical.frame.edit.EditFrameSnpModel$8.done(EditFrameSnpModel.java:2622)
      at com.sunopsis.graphical.tools.utils.swingworker.SwingWorker$4.run(SwingWorker.java:615)
      at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
      at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:646)
      at java.awt.EventQueue.access$000(EventQueue.java:84)
      at java.awt.EventQueue$1.run(EventQueue.java:607)
      at java.awt.EventQueue$1.run(EventQueue.java:605)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
      at java.awt.EventQueue.dispatchEvent(EventQueue.java:616)
      at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
      at java.awt.Dialog$1.run(Dialog.java:1044)
      at java.awt.Dialog$3.run(Dialog.java:1096)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.awt.Dialog.show(Dialog.java:1094)
      at java.awt.Component.show(Component.java:1584)
      at java.awt.Component.setVisible(Component.java:1536)
      at java.awt.Window.setVisible(Window.java:841)
      at java.awt.Dialog.setVisible(Dialog.java:984)
      at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:395)
      at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:356)
      at oracle.ide.dialogs.ProgressBar.start(ProgressBar.java:352)
      at oracle.ide.dialogs.ProgressBar.start(ProgressBar.java:243)
      at oracle.ide.dialogs.ProgressBar.start(ProgressBar.java:215)
      at com.sunopsis.graphical.tools.utils.SnpsSwingUtilities.executeAndBlockGUI(SnpsSwingUtilities.java:181)
      at com.sunopsis.graphical.frame.edit.EditFrameSnpModel.jButtonReverse_ActionEvents(EditFrameSnpModel.java:2650)
      at com.sunopsis.graphical.frame.SnpsEditFrame$IvjEventHandler.actionPerformed(SnpsEditFrame.java:206)
      at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
      at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
      at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
      at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
      at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
      at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:273)
      at java.awt.Component.processMouseEvent(Component.java:6290)
      at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
      at java.awt.Component.processEvent(Component.java:6055)
      at java.awt.Container.processEvent(Container.java:2039)
      at java.awt.Component.dispatchEventImpl(Component.java:4653)
      at java.awt.Container.dispatchEventImpl(Container.java:2097)
      at java.awt.Component.dispatchEvent(Component.java:4481)
      at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575)
      at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4236)
      at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166)
      at java.awt.Container.dispatchEventImpl(Container.java:2083)
      at java.awt.Window.dispatchEventImpl(Window.java:2482)
      at java.awt.Component.dispatchEvent(Component.java:4481)
      at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:648)
      at java.awt.EventQueue.access$000(EventQueue.java:84)
      at java.awt.EventQueue$1.run(EventQueue.java:607)
      at java.awt.EventQueue$1.run(EventQueue.java:605)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
      at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
      at java.awt.EventQueue$2.run(EventQueue.java:621)
      at java.awt.EventQueue$2.run(EventQueue.java:619)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
      at java.awt.EventQueue.dispatchEvent(EventQueue.java:618)
      at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
      at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
      at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
      Caused by: java.lang.IllegalArgumentException: Driver name cannot be empty
      at org.springframework.util.Assert.hasText(Assert.java:161)
      at com.sunopsis.sql.SnpsConnection.setDriverName(SnpsConnection.java:302)
      at com.sunopsis.dwg.dbobj.DwgConnectConnection.setDefaultConnectDefinition(DwgConnectConnection.java:380)
      at com.sunopsis.dwg.dbobj.DwgConnectConnection.<init>(DwgConnectConnection.java:274)
      at com.sunopsis.dwg.dbobj.DwgConnectConnection.<init>(DwgConnectConnection.java:288)
      at oracle.odi.core.datasource.dwgobject.support.DwgConnectConnectionCreatorImpl.createDwgConnectConnection(DwgConnectConnectionCreatorImpl.java:53)
      at com.sunopsis.dwg.reverse.Reverse.getLocalConnection(Reverse.java:1286)
      at com.sunopsis.dwg.reverse.Reverse.getLocalConnection(Reverse.java:1336)
      at com.sunopsis.dwg.reverse.Reverse.getLocalConnection(Reverse.java:1301)
      at com.sunopsis.dwg.reverse.Reverse.getMetaData(Reverse.java:1357)
      at com.sunopsis.graphical.frame.edit.EditFrameSnpModel$8.doInBackground(EditFrameSnpModel.java:2587)
      at com.sunopsis.graphical.tools.utils.swingworker.SwingWorker$1.call(SwingWorker.java:240)
      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      at java.util.concurrent.FutureTask.run(FutureTask.java:138)
      at com.sunopsis.graphical.tools.utils.swingworker.SwingWorker.run(SwingWorker.java:278)
      at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:655)
      at java.lang.Thread.run(Thread.java:662)
      ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

      Any light please.

      thank you
        • 1. Re: HP in use for ODI reverse model, - Error ODI: 20616
          JohnGoodwin
          In the reverse engineer tab of the model you will need to select customized and select the knowledge module "RKM Hyperion Planning"

          Cheers

          John
          http://john-goodwin.blogspot.com/
          • 2. Re: HP in use for ODI reverse model, - Error ODI: 20616
            korrq
            Dear John and experts


            The error below is the result of trying to reverse engineer the model of HP.

            -----------------------------------------------------------------------------------------------------------------
            org.apache.bsf.BSFException: exception from Jython:
            Traceback (most recent call last):
            File "<string>", line 41, in <module>
                 java.io.InvalidClassException: com.hyperion.planning.HspException; local class incompatible: stream classdesc serialVersionUID = -2065834634290912749, local class serialVersionUID = 1173493819024915347

                 at com.hyperion.odi.planning.wrapper.PlanningWrapper.login(Unknown Source)

                 at com.hyperion.odi.planning.ODIPlanningConnection.connect(Unknown Source)

                 at com.hyperion.odi.common.ODIModelImporter.importModels(Unknown Source)

                 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

                 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

                 at java.lang.reflect.Method.invoke(Method.java:597)


            com.hyperion.odi.planning.ODIPlanningException: com.hyperion.odi.planning.ODIPlanningException: Error unmarshaling return; nested exception is:
                 java.io.InvalidClassException: com.hyperion.planning.HspException; local class incompatible: stream classdesc serialVersionUID = -2065834634290912749, local class serialVersionUID = 1173493819024915347

                 at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)
                 at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)
                 at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)
                 at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2472)
                 at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:47)
                 at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)
                 at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
                 at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
                 at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
                 at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:558)
                 at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464)
                 at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
                 at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)
                 at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
                 at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)
                 at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)
                 at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)
                 at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
                 at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
                 at java.lang.Thread.run(Thread.java:662)
            Caused by: Traceback (most recent call last):
            File "<string>", line 41, in <module>
                 java.io.InvalidClassException: com.hyperion.planning.HspException; local class incompatible: stream classdesc serialVersionUID = -2065834634290912749, local class serialVersionUID = 1173493819024915347

                 at com.hyperion.odi.planning.wrapper.PlanningWrapper.login(Unknown Source)

                 at com.hyperion.odi.planning.ODIPlanningConnection.connect(Unknown Source)

                 at com.hyperion.odi.common.ODIModelImporter.importModels(Unknown Source)

                 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

                 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

                 at java.lang.reflect.Method.invoke(Method.java:597)


            com.hyperion.odi.planning.ODIPlanningException: com.hyperion.odi.planning.ODIPlanningException: Error unmarshaling return; nested exception is:
                 java.io.InvalidClassException: com.hyperion.planning.HspException; local class incompatible: stream classdesc serialVersionUID = -2065834634290912749, local class serialVersionUID = 1173493819024915347

                 at org.python.core.PyException.fillInStackTrace(PyException.java:70)
                 at java.lang.Throwable.<init>(Throwable.java:181)
                 at java.lang.Exception.<init>(Exception.java:29)
                 at java.lang.RuntimeException.<init>(RuntimeException.java:32)
                 at org.python.core.PyException.<init>(PyException.java:46)
                 at org.python.core.PyException.<init>(PyException.java:43)
                 at org.python.core.Py.JavaError(Py.java:455)
                 at org.python.core.Py.JavaError(Py.java:448)
                 at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:177)
                 at org.python.core.PyObject.__call__(PyObject.java:355)
                 at org.python.core.PyMethod.__call__(PyMethod.java:215)
                 at org.python.core.PyMethod.instancemethod___call__(PyMethod.java:221)
                 at org.python.core.PyMethod.__call__(PyMethod.java:206)
                 at org.python.core.PyObject.__call__(PyObject.java:381)
                 at org.python.core.PyObject.__call__(PyObject.java:385)
                 at org.python.pycode._pyx2.f$0(<string>:41)
                 at org.python.pycode._pyx2.call_function(<string>)
                 at org.python.core.PyTableCode.call(PyTableCode.java:165)
                 at org.python.core.PyCode.call(PyCode.java:18)
                 at org.python.core.Py.runCode(Py.java:1204)
                 at org.python.core.Py.exec(Py.java:1248)
                 at org.python.util.PythonInterpreter.exec(PythonInterpreter.java:172)
                 at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:144)
                 ... 19 more
            Caused by: com.hyperion.odi.planning.ODIPlanningException: Error unmarshaling return; nested exception is:
                 java.io.InvalidClassException: com.hyperion.planning.HspException; local class incompatible: stream classdesc serialVersionUID = -2065834634290912749, local class serialVersionUID = 1173493819024915347
                 at com.hyperion.odi.planning.wrapper.PlanningWrapper.login(Unknown Source)
                 at com.hyperion.odi.planning.ODIPlanningConnection.connect(Unknown Source)
                 at com.hyperion.odi.common.ODIModelImporter.importModels(Unknown Source)
                 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                 at java.lang.reflect.Method.invoke(Method.java:597)
                 at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java:175)
                 ... 33 more
            Caused by: java.rmi.UnmarshalException: Error unmarshaling return; nested exception is:
                 java.io.InvalidClassException: com.hyperion.planning.HspException; local class incompatible: stream classdesc serialVersionUID = -2065834634290912749, local class serialVersionUID = 1173493819024915347
                 at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:227)
                 at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:142)
                 at com.hyperion.planning.HyperionPlanningBean_Stub.Login(Unknown Source)
                 ... 41 more
            Caused by: java.io.InvalidClassException: com.hyperion.planning.HspException; local class incompatible: stream classdesc serialVersionUID = -2065834634290912749, local class serialVersionUID = 1173493819024915347
                 at java.io.ObjectStreamClass.initNonProxy(ObjectStreamClass.java:562)
                 at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1582)
                 at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1495)
                 at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1582)
                 at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1495)
                 at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1582)
                 at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1495)
                 at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1731)
                 at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1328)
                 at java.io.ObjectInputStream.readObject(ObjectInputStream.java:350)
                 at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:225)
                 ... 43 more

            -----------------------------------------------------------------------------------------------------------------


            I believe the problem may be being generated as a result of the execution of step 71 of the RKM Start Reverse, especially the code below.

            -------------------------------------------------- ----------------------------------------
            #
            # START THE REVERSE
            #
            odiModelImporter = ODIModelImporter (imod, Happ repCon)
            odiModelImporter.importModels ()
            -------------------------------------------------- ----------------------------------------
            I tested commenting all the lines of this piece of code in step 71.

            The result was: run ended with success and any object in the model.


            My interpretation is;
            class has changed between the time it was stored and when it is being retrieved, so you could not define a serialVersionUID for it before you changed.

            I believe that this error should be related to user permissions or connection in HP.
            However, I've tested it and is working perfectly.

            versions of ODI and HP, the penultimate sane published by Oracle.



            idea how I can change something to make new tests, are welcome.

            thanks
            • 3. Re: HP in use for ODI reverse model, - Error ODI: 20616
              JohnGoodwin
              So the last answer I gave resolved the issue? the new error usually relates to incorrect credentials or is not an administrator of the application.

              Cheers

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