AO 2.4 slow hierarchy update compared to AO1.4

[former_member256353]

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

[former_member256353]

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.....

[former_member256353]

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?

[mrapp]

Hi Gregor

AO 2.4 SP1 has just been released today. Pls check the download area on the service marketplace.

Kr

Martin

[former_member256353]

Hi Martin,

Thank you for that hint. I already have seen it and downloaded&installed 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

[former_member256353]

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....

[TammyPowlas]

Hi Gregor - yes, my earlier post says it is not yet released. SAP Note https://launchpad.support.sap.com/#/notes/1518359/E says patch 1 for 2.4 will be released CW 2, 2017

[former_member256353]

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.....

[TammyPowlas]

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

[TammyPowlas]

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