Skip to Content

AO 2.4 slow hierarchy update compared to AO1.4

Hi all,

I have installed the new AO2.4 just last week.

Only me and 2 other users are evaluating the AO2.4

Everyone else still runs on AO1.4.

Now, the issue is, that we have a controlling analysis sheet, that, when we run it in AO1.4 and open the highest level of a hierarchy, the drill down takes 12 seconds in AO1.4.

But, when doing exactly the same thing in AO 2.4, it takes an incredible amount of 5 to 6 minutes for drilling down to the same level.

I mean, this is a horrible worsening of the performance.

We have other reports that I've tested with AO2.4 - all without hierarchy, and there's no performance difference at all.

But, what puzzles me, is that in AO2.4 that drilldown takes 5 minutes now - which is a absolute no go.

As there's no performance difference in reports without hierarchy between 1.4 and 2.4, I conclude that it is not an issue of JDBC/HTTP connection.

I am looking forward for any hints, ideas or whatever to speed up AO2.4.

Regards

Greg

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Dec 15, 2016 at 02:33 PM

    Greg, what is your data source? BW or HANA?

    SAP released this SAP note with some guidance (not specific to 2.4): https://launchpad.support.sap.com/#/notes/2250536

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 15, 2016 at 02:41 PM

    And there are fixes / patches planned for hierarchies in SP1 for 2.4 (not released) - see https://launchpad.support.sap.com/#/notes/2389092

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 15, 2016 at 02:42 PM

    H i Tammy,

    HANA.

    We connect to HANA (I am on 1.00.122.01) using BO (4.1 Sp8).

    I'll check the referred note, thankyou!

    Edit: Note is yet empty.....*sigh*....I should have learned my lessons as an early adopter already years ago.....

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 20, 2016 at 10:08 AM

    Hi Tammy,

    when I check the referred note, I get this:

    No deliverable object available due to objects not available for download yet or insufficient authorization of logged on user.

    So it's not yet released for AO2.4.

    Which is kind of....

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 12, 2017 at 11:30 AM

    Hi there,

    As I got impatient waiting for the release of SP1 for OA2.4 I installed OA2.3 SP1.

    And then I tried again opening that hierarchy that works flawlessly in OA1.4. (opening time less than 10 seconds)

    Result: OA 2.3 crashes too.

    Has anyone any similar issues? Have you been able to solve those?

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Martin,

      Thank you for that hint. I already have seen it and downloaded∈stalled the new patch.

      Still the same behavior.

      AO crashes.

      Here are some lines from the log:

      >> Bali Exception:
      The remote server returned an error: (500) Internal Server Error.
      cli.com.sap.ip.bi.pioneer.core.connections.CrInaConnectionImplementation.HandleException(Unknown Source)
      cli.com.sap.ip.bi.pioneer.core.connections.CrInaConnectionImplementation.postRequest(Unknown Source)
      com.sap.ip.bi.bics.service.model.impl.request.INARequest.postRequest(INARequest:212)
      com.sap.ip.bi.bics.service.model.impl.request.ResultSetRequest.getJSONResponse(ResultSetRequest:92)
      com.sap.ip.bi.bics.dataaccess.resource.impl.ina.queryview.resultset.INAResultSet.execute(INAResultSet:102)
      com.sap.ip.bi.bics.dataaccess.resource.impl.ina.queryview.resultset.INAResultSet.getDetails(INAResultSet:265)
      com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.resultset.ResultSet.readResultSetDetails(ResultSet:2107)
      com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.resultset.ResultSet.drillDown(ResultSet:1863)
      com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.hierarchy.QvDrillOperation.execute(QvDrillOperation:415)
      com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.hierarchy.QvDrillOperations.add(QvDrillOperations:146)
      com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.hierarchy.QvDrillOperations.add(QvDrillOperations:244)
      com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.resultset.tuples.elements.RsAxisTupleElement.setDrillState(RsAxisTupleElement:735)
      com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.resultset.tuples.elements.RsAxisTupleElement.setDrillState(RsAxisTupleElement:712)
      com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.resultset.tuples.elements.RsAxisTupleElement.drillToLevel(RsAxisTupleElement:751)
      com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.command.QvHierarchyCommands.setDrillState(QvHierarchyCommands:159)
      com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.command.QvHierarchyCommands.processCommand(QvHierarchyCommands:49)
      com.sap.ip.bi.bics.dataaccess.consumer.impl.selector.command.CommandManager.processCommand(CommandManager:83)
      com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.command.QvCommandManager.processCommand(QvCommandManager:174)
      com.sap.ip.bi.bics.dataaccess.consumer.impl.selector.SelectionObject.processCommand(SelectionObject:1568)
      cli.com.sap.ip.bi.pioneer.core.commands.CrSyncDimensionHierarchyHelper.ExpandNodeToLevel(Unknown Source)
      cli.com.sap.ip.bi.pioneer.common.commands.CrCommandValueListHierExpandToLevel.ExecuteCommand(Unknown Source)
      cli.com.sap.ip.bi.pioneer.common.commands.CoCommandBase.Execute(Unknown Source)
      cli.com.sap.ip.bi.pioneer.common.commands.CoCommandProcessor.CommandExecute(Unknown Source)
      cli.com.sap.ip.bi.pioneer.common.commands.CoCommandProcessor.InitialCommandExecute(Unknown Source)
      cli.com.sap.ip.bi.pioneer.common.commands.CoCommandProcessor.DoExecuteCommandInternal(Unknown Source)
      cli.com.sap.ip.bi.pioneer.common.commands.CoCommandProcessor.DoExecuteCommand(Unknown Source)
      cli.com.sap.ip.bi.pioneer.core.commands.CrCommandProcessor.DoExecuteCommand(Unknown Source)
      cli.com.sap.ip.bi.pioneer.cofplugin.Commands.RibbonCommandListener.RibbonCommandListener_OnIndexChangedAction(Unknown Source)
      cli.Com.Sap.Cof.Core.Controls.RibbonControls.RibbonDynamicMenuControl.FireActionEvent(Unknown Source)
      cli.Com.Sap.Cof.Core.Controls.RibbonControls.RibbonDynamicMenuControl.ChildControl_OnPressedAction(Unknown Source)
      cli.Com.Sap.Cof.Core.Controls.RibbonControls.RibbonToggleButtonControl.FireActionEvent(Unknown Source)
      cli.Com.Sap.Cof.Core.CustomUI.Ribbon.CofRibbon.OnToggleAction(Unknown Source)
      #
      2017-01-16 08:54:00,183|FATAL|Trace.AoPlugin|?.?|VSTA_Main|Application Exception (ID 103042)
      Nested exception. See inner exception below for more details[msg.NestedException]
      at com.sap.ip.bi.pioneer.core.exceptions.CrExceptionHelper.ThrowRestartException(Exception iEx)
      at com.sap.ip.bi.pioneer.common.commands.CoCommandProcessor.CommandExecute(CoCommandBase iCommand)
      at com.sap.ip.bi.pioneer.common.commands.CoCommandProcessor.InitialCommandExecute(CoCommandBase iCommand)
      at com.sap.ip.bi.pioneer.common.commands.CoCommandProcessor.DoExecuteCommandInternal(CoCommandParameters iParameters)
      at com.sap.ip.bi.pioneer.common.commands.CoCommandProcessor.DoExecuteCommand(CoCommandBase iCommand, CoCommandParameters iParameters)
      at com.sap.ip.bi.pioneer.core.commands.CrCommandProcessor.DoExecuteCommand(CoCommandBase iCommand, CoCommandParameters iParameters)
      at com.sap.ip.bi.pioneer.cofplugin.Commands.RibbonCommandListener.RibbonCommandListener_OnIndexChangedAction(ICustomUiElement iControl, String iSelectedId, Int32 iSelectedIndex)

      Now, I just opened an incident for this.

      Regards

      Greg

  • Jan 25, 2017 at 01:12 PM

    The strange thing is, that when I open this hierarchy in web IDE, the hierarchy opens in about 2 seconds.

    Whereas in OA 2.x (doesn't matter which version) it simply crashes.

    OSS has been opened, but they're not in a helping mood yet.....

    Add comment
    10|10000 characters needed characters exceeded