SAP Knowledge Base Article - Preview

3809353 - Analysis for Office refresh error - Object reference not set to an instance of an object

Symptom

  • When reopening and refreshing a saved workbook, one data source fails with error: [5a73-4c85-1b] Object reference not set to an instance of an object.
  • The affected crosstab is not rendered and its range collapses from several rows/columns to a single cell.
  • Other data sources in the same workbook refresh successfully and Refresh All reports success.
  • Observed in different workbooks by different users.
  • The failure occurs only on the data source that has saved expanded hierarchy nodes (persisted drill state).
  • SU53 shows "Authorization check not successful" for RFC function module BICS_PROV_GET_HIERARCHIES, however authorizations seem to be as expected


Read more...

Environment

  • Analysis for Office 2.8

Product

SAP S/4HANA 2022

Keywords

Analysis for Office, AO, Refresh All, crosstab collapses, Object reference not set to an instance of an object, [5a73-4c85-1b], persisted drill state, hierarchy drill operations, Hierarchy Valid On, key date, P_KEYDATE, NullReferenceException, QvDrillOperation.verifyAgainstCharacteristicsSettings, data source fails, hierarchy parameter , KBA , 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.