Symptom
The error "Dereferencing of the NULL reference" is occurring when refreshing an existing workbook or inserting a query in Analysis for Office.
This might happen after an upgrade in the BW system.
The following entries appear in Analysis Office trace file:
--------------------------------------
Program error in class SAPMSSY1 method : UNCAUGHT_EXCEPTION
ABEND RS_EXCEPTION (000): Dereferencing of the NULL reference
MSGV1: Dereferencing of the NULL reference
com.sap.ip.bi.base.application.message.impl.MessageManager.addMessageInternal(MessageManager:211)
com.sap.ip.bi.base.application.message.impl.MessageManager.addMessageByListener(MessageManager:178)
com.sap.ip.bi.base.application.message.impl.MessageManager.addMessage(MessageManager:131)
com.sap.ip.bi.base.application.message.impl.MessageManager.addMessageInternal(MessageManager:207)
com.sap.ip.bi.base.application.message.impl.MessageManager.addMessageByListener(MessageManager:178)
com.sap.ip.bi.base.application.message.impl.MessageManager.addMessage(MessageManager:131)
com.sap.ip.bi.base.application.service.RfcService.fillMessages(RfcService:358)
com.sap.ip.bi.base.application.service.RfcService.doPostProcessing(RfcService:308)
com.sap.ip.bi.base.application.service.rfcproxy.base.RfcFunction.execute(RfcFunction:95)
com.sap.ip.bi.bics.dataaccess.resource.impl.bi.selector.variableprocessor.ProviderVariableContainer.submitVariables(ProviderVariableContainer:583)
com.sap.ip.bi.bics.dataaccess.consumer.impl.selector.variableprocessor.VariableProcessor.submitVariables(VariableProcessor:533)
cli.com.sap.ip.bi.pioneer.core.models.CrVariableContainer.SubmitVariables(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.models.CrDataProvider.AssignCompletely(Unknown Source)
cli.com.sap.ip.bi.pioneer.core.commands.CrCommandRefreshSingleDp.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.contextMenuControls.CnContextMenuCommandListener.RibbonCommandListener_OnButtonAction(Unknown Source)
cli.com.sap.ip.bi.pioneer.controls.contextMenuControls.CnContextMenuButton.FireActionEvent(Unknown Source)
cli.com.sap.ip.bi.pioneer.shared.addin2007.Connect.ContextMenuOnButtonAction(Unknown Source)
--------------------------------------
Read more...
Environment
SAP Analysis for Microsoft Office All versions
Product
Keywords
refresh, refreshing, error, existing, connection, cache, query, exception, error, nested , KBA , BI-RA-AO-CON , Please use component BI-RA-AO-XLA , BI-RA-AO-PPA , Please use component BI-RA-AO-XLA , BI-RA-AO-XLA , Excel Addin , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview