SAP Knowledge Base Article - Public

3726006 - Changing hierarchy metadata, causes Analysis Office workbooks to throw exception during refresh

Symptom

After changing hierarchy metadata in a BW system, the Analysis Office workbook where data sources use this hierarchy crash on opening.
The following error is visible in the Analysis Office trace file:

General .NET Exception [5a73-4c85-1b]:
Object reference not set to an instance of an object.
   at com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.hierarchy.QvDrillOperation.verifyAgainstCharacteristicsSettings()
   at com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.hierarchy.QvDrillOperations.verifyAgainstCharacteristicsSettings()
   at com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.QueryView.verifyDrillOperationsAgainstCharacteristicsSettings()
   at com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.QvCharacteristic.setHierarchy(IMdHierarchy hierarchy)
   at com.sap.ip.bi.bics.dataaccess.consumer.impl.base.StateDomParser.parseCharacteristicNode(ICharacteristic , IDomReader , Boolean )
   at com.sap.ip.bi.bics.dataaccess.consumer.impl.base.StateDomParser.parseQvCharacteristicNode(IQvCharacteristicInternal , IDomReader , Boolean )
   at com.sap.ip.bi.bics.dataaccess.consumer.impl.base.StateDomParser.parseCharacteristic(ICharacteristic characteristic, IDomReader domReader, Boolean defaultState)
   at com.sap.ip.bi.bics.dataaccess.consumer.impl.selector.CharacteristicList.setStateFromDom(String name, IStateDomParser parser, IDomReader domReader, Boolean defaultState)
   at com.sap.ip.bi.bics.dataaccess.consumer.impl.base.StateDomParser.readListObjectDetails(IDomReader , Boolean , String , IUnmodifiableList )
   at com.sap.ip.bi.bics.dataaccess.consumer.impl.base.StateDomParser.parseSelectorNode(ISelector , IDomReader , Boolean , Int64 )
   at com.sap.ip.bi.bics.dataaccess.consumer.impl.base.StateDomParser.parseQueryViewNode(IQueryViewInternal , IDomReader , Boolean , Int64 )
   at com.sap.ip.bi.bics.dataaccess.consumer.impl.base.StateDomParser.parseSelectorNodeBase(ISelector , IDomReader , Boolean , Boolean , Int64 )
   at com.sap.ip.bi.bics.dataaccess.consumer.impl.base.StateDomParser.parseSelector(ISelector selector, IDomReader domReader, Boolean defaultState, Int64 mode)
   at com.sap.ip.bi.bics.dataaccess.consumer.impl.selector.SelectionObject.setStateByXml(String xml, Int64 mode)
   at com.sap.ip.bi.pioneer.core.models.CrDataProvider.AssignQueryViewFinish(CrePromptShown lPromptShown)
   at com.sap.ip.bi.pioneer.core.models.CrModelApplication.AssignDpsCompletely(List`1 completeDpList, List`1 dpListForVarScreenPossible, CreWithVariablePrompt withVariablePrompt, Boolean withMessageIfNoVar, CrePromptShown& promptShown, Boolean forceDocumentModePromptsScreen)
#

Environment

SAP Analysis for Microsoft Office All versions

Reproducing the Issue

  1. change hierarchy metadata in BW
  2. open a saved Analysis Office workbook
  3. Refresh

Cause

Program error.

Resolution

Implement these notes in the BW system:
SAP Note 3630720 - Error when Refresh AO Workbook using a CDS query with a Multiple Key Header Hierarchy in Local Name
SAP Note 3551444 - Hierarchy deactivations are lost

Keywords

Analysis Office, hierarchy, workbook, General .NET Exception, 5a73-4c85-1b,  [5a73-4c85-1b], Object reference not set to an instance of an object , KBA , BI-RA-AO-XLA , Excel Addin , Known Error

Product

SAP Analysis for Microsoft Office all versions