com.essbase.api.base.EssException: Cannot get async process state. Essbase Error(1021001): Failed to Establish Connection With SQL Database Server. See log for more information

Oracle Community | 2694355 | 1 year ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    failed to deploy essbase cube

    Oracle Community | 1 year ago | 2694355
    com.essbase.api.base.EssException: Cannot get async process state. Essbase Error(1021001): Failed to Establish Connection With SQL Database Server. See log for more information
  2. 0

    Essbase Studio Error

    Oracle Community | 6 years ago | 849533
    com.hyperion.cp.datasources.export.essbase.EssbaseDriverException: Failed to deploy Essbase cube.

    Root Cause Analysis

    1. com.essbase.api.base.EssException

      Cannot get async process state. Essbase Error(1021001): Failed to Establish Connection With SQL Database Server. See log for more information

      at com.essbase.server.framework.EssOrbPluginDirect.ex_olap()
    2. com.essbase.server
      EssOrbPluginDirect.essMainGetAsyncProcState
      1. com.essbase.server.framework.EssOrbPluginDirect.ex_olap(Unknown Source)
      2. com.essbase.server.framework.EssOrbPluginDirect.essMainGetAsyncProcState(Unknown Source)
      2 frames
    3. com.essbase.api
      EssOrbPlugin._invokeMethod
      1. com.essbase.api.session.EssOrbPlugin._invokeMainMethod(Unknown Source)
      2. com.essbase.api.session.EssOrbPlugin._invokeMethod2(Unknown Source)
      3. com.essbase.api.session.EssOrbPlugin._invokeMethod(Unknown Source)
      3 frames
    4. com.essbase.server
      EssOrbPluginDirect._invokeProtected
      1. com.essbase.server.framework.EssOrbPluginDirect._invokeProtected(Unknown Source)
      1 frame
    5. com.essbase.api
      EssCube.getAsyncProcessState
      1. com.essbase.api.session.EssOrbPluginEmbedded.invokeMethod(Unknown Source)
      2. com.essbase.api.session.EssOrbPluginEmbedded.invokeMethod(Unknown Source)
      3. com.essbase.api.session.EssOrbPlugin.essMainGetAsyncProcState(Unknown Source)
      4. com.essbase.api.datasource.EssCube.getAsyncProcessState(Unknown Source)
      4 frames
    6. com.hyperion.cp
      RequestListener$ListenerThread.run
      1. com.hyperion.cp.datasources.export.essbase.dimbuild.EssDimensionBuilder.buildDimensionWithRules(EssDimensionBuilder.java:750)
      2. com.hyperion.cp.datasources.export.essbase.dimbuild.EssDimensionBuilder.buildDimension(EssDimensionBuilder.java:403)
      3. com.hyperion.cp.datasources.export.essbase.EssbaseMain.createEssbaseCube(EssbaseMain.java:948)
      4. com.hyperion.cp.datasources.export.essbase.util.EssbaseExportRoutines.export(EssbaseExportRoutines.java:1745)
      5. com.hyperion.cp.datasources.export.essbase.util.EssbaseExportSupport$EssbaseExport.invoke(EssbaseExportSupport.java:885)
      6. com.hyperion.cp.vm.VmTask.runSystemProcedure(VmTask.java:457)
      7. com.hyperion.cp.vm.VmOperatorCall.executeProcedure(VmOperatorCall.java:502)
      8. com.hyperion.cp.vm.VmOperatorCall.run(VmOperatorCall.java:184)
      9. com.hyperion.cp.vm.VmNodeExpression.run(VmNodeExpression.java:1273)
      10. com.hyperion.cp.vm.VmStatementPrimitive.runAssignStatement(VmStatementPrimitive.java:131)
      11. com.hyperion.cp.vm.VmStatementPrimitive.verifyAndRunPrimitiveStatement(VmStatementPrimitive.java:40)
      12. com.hyperion.cp.vm.VmParseTree.verify(VmParseTree.java:421)
      13. com.hyperion.cp.vm.VmTask.runCode(VmTask.java:412)
      14. com.hyperion.cp.vm.VmOperatorCall.executeProcedure(VmOperatorCall.java:520)
      15. com.hyperion.cp.vm.VmOperatorCall.run(VmOperatorCall.java:184)
      16. com.hyperion.cp.vm.VmNodeExpression.run(VmNodeExpression.java:1273)
      17. com.hyperion.cp.vm.VmStatementPrimitive.runAssignStatement(VmStatementPrimitive.java:131)
      18. com.hyperion.cp.vm.VmStatementPrimitive.verifyAndRunPrimitiveStatement(VmStatementPrimitive.java:40)
      19. com.hyperion.cp.vm.VmParseTree.verify(VmParseTree.java:421)
      20. com.hyperion.cp.vm.VmTask.runCode(VmTask.java:412)
      21. com.hyperion.cp.vm.VmOperatorCall.executeProcedure(VmOperatorCall.java:520)
      22. com.hyperion.cp.vm.VmOperatorCall.run(VmOperatorCall.java:184)
      23. com.hyperion.cp.vm.VmNodeExpression.run(VmNodeExpression.java:1273)
      24. com.hyperion.cp.vm.VmWorkflowStatement.runSendStatement(VmWorkflowStatement.java:167)
      25. com.hyperion.cp.vm.VmWorkflowStatement.verifyAndRunWorkflowStatement(VmWorkflowStatement.java:35)
      26. com.hyperion.cp.vm.VmParseTree.verify(VmParseTree.java:570)
      27. com.hyperion.cp.vm.VmTask.runCode(VmTask.java:412)
      28. com.hyperion.cp.cpl.CplCompilerVm.compileMeAndRun(CplCompilerVm.java:162)
      29. com.hyperion.cp.server.ServiceDispatcher.runCplMethods(ServiceDispatcher.java:98)
      30. com.hyperion.cp.server.ServiceDispatcher.run(ServiceDispatcher.java:387)
      31. com.hyperion.cp.server.RequestListener$NetworkTask.run(RequestListener.java:1575)
      32. com.hyperion.cp.server.RequestListener.runNetworkTask(RequestListener.java:1149)
      33. com.hyperion.cp.server.RequestListener.runTask(RequestListener.java:1223)
      34. com.hyperion.cp.server.RequestListener.processReadyConnection(RequestListener.java:1041)
      35. com.hyperion.cp.server.RequestListener.listenToSockets(RequestListener.java:713)
      36. com.hyperion.cp.server.RequestListener.listen(RequestListener.java:553)
      37. com.hyperion.cp.server.RequestListener.access$400(RequestListener.java:25)
      38. com.hyperion.cp.server.RequestListener$ListenerThread.run(RequestListener.java:1472)
      38 frames