Exception when enabling profiling in Analysis for Office

Former Member — Wed, 16 Jul 2014 07:23:57 GMT

I'm using Analysis for Microsoft Excel (Virtual) tool. Due to the requirement we have enabled profiling in our tool. But i have observed that whenever I enable profiling I get exception and I cannot run the reports.

I'm attaching a screenshot of my exception.

Below is the contents of the log file.

- Information:	@@@@@ Application Start. (SharedAddIn 2007 Build 1.4.5.2826 loaded/OnConnection method) @@@@@	\| 2014-07-16T12:31:38	\| com.sap.ip.bi.pioneer.shared.addin2007.Connect.OnConnection() ()
- Error:	No valid URL entered for service, Url = http://<boe server hostname>:<port>/dswsbobje/services/Session

General .NET Exception:

Invalid URI: The hostname could not be parsed.

at System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind uriKind)

at System.Uri..ctor(String uriString)

at com.sap.ip.bi.pioneer.controls.connections.CnLogonControlEx.GetBoeSystemInfoFromServiceUrl(String strServiceUrl)

	\| 2014-07-16T12:32:11	\| com.sap.ip.bi.pioneer.controls.connections.CnLogonControlEx.GetBoeSystemInfoFromServiceUrl() ()
- Error:	URL not set	\| 2014-07-16T12:32:12	\| com.sap.ip.bi.pioneer.core.boe.CrBoeInternalServiceBase.CheckBoeSystem() ()
- Error:	Bali Exception:

Application step already finished!

	com.sap.ip.bi.base.application.statistic.impl.StatisticApplicationStep.endEvent(StatisticApplicationStep:206)
	com.sap.ip.bi.base.application.statistic.impl.StatisticManager.endEvent(StatisticManager:170)
	cli.com.sap.ip.bi.pioneer.core.statistic.CrStatisticManager.EndEvent(Unknown Source)
	cli.com.sap.ip.bi.pioneer.core.statistic.CrStatisticAdaptor.EndEvent(Unknown Source)
	cli.com.sap.ip.bi.pioneer.controls.uiservices.CnVariableProcessService.LaunchVariablePrompt(Unknown Source)
	cli.com.sap.ip.bi.pioneer.core.models.CrVariableContainer.ShowVariablePromptIfPossible(Unknown Source)
	cli.com.sap.ip.bi.pioneer.core.models.CrModelApplication.AssignDpsCompletely(Unknown Source)
	cli.com.sap.ip.bi.pioneer.core.commands.CrVarContextChangeCommandHelper.Execute(Unknown Source)
	cli.com.sap.ip.bi.pioneer.core.commands.CrCommandInsertQuery.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.common.commands.CoCommandProcessor.DoExecuteCommand(Unknown Source)
	cli.com.sap.ip.bi.pioneer.controls.ribbonControls.CnRibbonBaseMenu.OnActionHandler(Unknown Source)
	cli.com.sap.ip.bi.pioneer.controls.ribbonControls.CnRibbonButtonControl.OnAction(Unknown Source)
	cli.com.sap.ip.bi.pioneer.shared.addin2007.Connect.OnButtonAction(Unknown Source)
	\| 2014-07-16T12:34:53	\| com.sap.ip.bi.pioneer.common.messagehandling.CoMessenger.WriteToLog() ()
- Critical:	Bali Exception:

bali.util.EmptyStackException

at bali.util.Stack.peek()

at com.sap.ip.bi.base.application.statistic.impl.StatisticApplicationStep.endEvent(IStatisticEvent )

at com.sap.ip.bi.base.application.statistic.impl.StatisticManager.endEvent(IStatisticEvent event)

at com.sap.ip.bi.base.application.impl.Application.endApplicationStep(Int32 commitMemoryTag, Int32 exceptionReason)

at com.sap.ip.bi.base.application.impl.Application.endApplicationStep()

at com.sap.ip.bi.pioneer.core.statistic.CrStatisticManager.EndApplicationStep()

at com.sap.ip.bi.pioneer.core.commands.CrCommandProcessor.DoExecuteCommand(CoCommandBase iCommand, CoCommandParameters iParameters)

at com.sap.ip.bi.pioneer.common.commands.CoCommandProcessor.DoExecuteCommand(CoCommandBase iCommand)

at com.sap.ip.bi.pioneer.controls.ribbonControls.CnRibbonBaseMenu.OnActionHandler(CnRibbonButtonControl iCommandControl)

at com.sap.ip.bi.pioneer.controls.ribbonControls.CnRibbonButtonControl.OnAction()

at com.sap.ip.bi.pioneer.shared.addin2007.Connect.OnButtonAction(IRibbonControl iRibbonControl)

	bali.util.Stack.peek(Unknown Source)
	com.sap.ip.bi.base.application.statistic.impl.StatisticApplicationStep.endEvent(StatisticApplicationStep:210)
	com.sap.ip.bi.base.application.statistic.impl.StatisticManager.endEvent(StatisticManager:170)
	com.sap.ip.bi.base.application.impl.Application.endApplicationStep(Application:479)
	com.sap.ip.bi.base.application.impl.Application.endApplicationStep(Application:427)
	cli.com.sap.ip.bi.pioneer.core.statistic.CrStatisticManager.EndApplicationStep(Unknown Source)
	cli.com.sap.ip.bi.pioneer.core.commands.CrCommandProcessor.DoExecuteCommand(Unknown Source)
	cli.com.sap.ip.bi.pioneer.common.commands.CoCommandProcessor.DoExecuteCommand(Unknown Source)
	cli.com.sap.ip.bi.pioneer.controls.ribbonControls.CnRibbonBaseMenu.OnActionHandler(Unknown Source)
	cli.com.sap.ip.bi.pioneer.controls.ribbonControls.CnRibbonButtonControl.OnAction(Unknown Source)
	cli.com.sap.ip.bi.pioneer.shared.addin2007.Connect.OnButtonAction(Unknown Source)
	\| 2014-07-16T12:34:54	\| com.sap.ip.bi.pioneer.common.messagehandling.CoMessenger.WriteToLog() ()
- Critical:	102001 #msl.genexcept	\| 2014-07-16T12:34:54	\| com.sap.ip.bi.pioneer.common.messagehandling.CoMessenger.WriteToLog() ()

If anyone has faced the same issue could you please help me.

Re: Exception when enabling profiling in Analysis for Office

Former Member — Wed, 16 Jul 2014 07:33:01 GMT

Hi Vivek,

sorry there are to many types of "Profiling" in AO
which one do you mean? BW Profiling (RSTT), VBA Profiling, AO Profiling via Regestry, Bics Statistics?

Regards

Thorsten

Re: Exception when enabling profiling in Analysis for Office

Former Member — Wed, 16 Jul 2014 08:05:07 GMT

I have enabled BW profiling through settings.

Below is the screenshot for the same.

Re: Exception when enabling profiling in Analysis for Office

Former Member — Wed, 18 Nov 2015 23:09:35 GMT

Hi Vivek

Have you solved this issue? I get the same error after my Business Objects upgrade to 4.1 SP06. I do not have 'Profiling' checked - we get the error just by opening any Analysis Workbook that is published on the BI LauncPad.

Thanks

Question Re: Exception when enabling profiling in Analysis for Office in Technology Q&A

Exception when enabling profiling in Analysis for Office

Re: Exception when enabling profiling in Analysis for Office

Re: Exception when enabling profiling in Analysis for Office

Re: Exception when enabling profiling in Analysis for Office