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
- Start Analysis for Office.
- 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.
- 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