Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Columbus Signals Image Artist
Downloads
Downloads
Community
Support Forums Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

TIBCO Spotfire Data Connector for SAP BW fails to load data with error "External error:Unable to read beyond the end of the stream".

Rich Talbot
  • Updated
Date Posted:
Product: TIBCO Spotfire®

Problem:

TIBCO Spotfire Data Connector for SAP BW fails to load data with error "External error:Unable to read beyond the end of the stream".


Solution:

When the result of SAP BEx query or data selection from the TIBCO Spotfire Data Connection for SAP BW is more than 1 million cells, it may fail to load with below error in either of the two scenarios:
1) Using ODBO driver
2) Though SAP BAPI driver is installed, preference 'UseNativeSapFunctionsAllowingMoreThanOneMillionCells' have not been enabled from Administration Manager 

Could not connect due to an unknown error.
External error:
Unable to read beyond the end of the stream.

  There are 2 options to resolve the issue:

1) Install the SAP BAPI driver (SAP NetWeaver RFC SDK). See "Installing BAPI driver" reference for more details

or

2) Set the 'UseNativeSapFunctionsAllowingMoreThanOneMillionCells' preferce to "True" using Administration Manager (TIBCO Spotfire Analyst > Tools > Administration Manager > Preferences > Select desired user group or Everyone on Left side > On Right side, Connectors > SAP BW) which will allow to load more than 1 million cells without any error. Doc: Installing Drivers for the SAP BW Connector

Related articles