SAP Knowledge Base Article - Public

2325425 - Exception when using Analysis for Office to connect to HANA multi tenant landscape

Symptom

When using Analysis for Office to connect to HANA multi tenant landscape, error "Object reference not set to an instance of an object" occurs.

In log file, below error information could be found:

General .NET Exception:
Object reference not set to an instance of an object.
   at com.sap.ip.bi.pioneer.core.connections.json.CrBicsJsonObject.get(String s)
   at com.sap.ip.bi.pioneer.core.connections.json.CrBicsJsonObject.getJSONObject(String s)
   at com.sap.ip.bi.bics.service.connection.ina.impl.INASystemService.parseJSON(IJSONObject )
   at com.sap.ip.bi.bics.service.connection.ina.impl.INASystemService.isApplicable()
   at com.sap.ip.bi.bics.dataaccess.resource.impl.ina.objectservices.INAObjectServices.isApplicable()

Environment

SAP Analysis for Microsoft Office

Reproducing the Issue

  1. Start Analysis for Office.
  2. Click "Insert Data Source" button  -> "Select Data Source" -> right click on blank area -> "Create New SAP HANA Connection" -> input the information and click "Create" button.
  3. Double click the new created HANA Connection and input the logon information, then click "OK" button.

Cause

This is a bug that InA-Service works only with HANA servers in single container mode.

Resolution

This bug has been fixed in HANA revision 1.00.112.02. Please upgrade HANA revision to 1.00.112.02 or above.

Keywords

"Object reference not set to an instance of an object", AO, HANA, CrBicsJsonObject.get(String s), CrBicsJsonObject.getJSONObject(String s), connect, Analysis for Office, Analysis for Excel,multi, tenant, landscape, multi-tenant, database, configuration , KBA , BI-RA-AO-CON , Please use component BI-RA-AO-XLA , BI-RA-AO-XLA , Excel Addin , HAN-AS-INA-SVC , deprecated - please use HAN-DB-ENG-MDS instead , Bug Filed

Product

SAP Analysis for Microsoft Office all versions