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.