SAP Knowledge Base Article - Public

2547525 - "ReadChannelException" when executing a HANA view in Analysis Office

Symptom

The error below occurs when executing a HANA view in Analysis for Office:

Error Channel.png

The Analysis trace files contain the following entries:

------------------------------

[BICS HANA] InA message ERROR 200 - ReadChannelException at network layer:
message: an error occured while reading from the channel
info: connection broken
param: active channel (since 96092310mues) 263 from XXX to XXX with method MultidimensionalServices with id XXX on host XXX on port XXX from process hdbxsengine with service port XXX, pid XXX and tid XXX #

------------------------------

Environment

SAP BusinessObjects Analysis, edition for Microsoft Office

Reproducing the Issue

  1. Execute HANA view in Analysis for Office tool; 
  2. Error occurs;

Cause

This is a bug, which is caused by a column with the same name as the HANA view.

Resolution

This issue is fixed in HANA revision 122.12 as mentioned in SAP note 2507876.

See MDS section:

-----------------------

>> Fixed a bug which had caused a dimension to not be exposed to the client if it was used within a Calculation View using the same name.

-----------------------

The workaround is to change the view/column name to avoid the error.

See Also

2507876 - SAP HANA 1.0 SPS 12 Database Maintenance Revision 122.12

Keywords

ReadChannelException, exception, error, hana, calculation, no service implementation available , KBA , BI-RA-AO-XLA , Excel Addin , HAN-DB , SAP HANA Database , Problem

Product

SAP Analysis for Microsoft Office all versions