Error - The stream provided does not contain the number of bytes specified.

Created
October 08, 2021 23:15

Date Posted: 2020-05-20
Product: TIBCO Spotfire®

Problem:

Solution:

You may see the following error while accessing data from Oracle Data source using the Data Direct Drivers -
=============================================
[tibcosoftwareinc][Oracle JDBC Driver]Communication error: The stream provided does not contain the number of bytes specified. For batches, please ensure that streams are reset before subsequent addBatch calls. This is a non-recoverable error and the connection has been terminated.
============================================= - Update the Data Source Properties in Information Designer to use the Oracle Native driver.
- If you get this error while fetching the data from the Spotfire Database, you need to update the bootstrap to use the Oracle Native drivers. You can achieve this by creating a new bootstrap.xml .

https://wiki.scn.sap.com/wiki/display/ASJAVA/(ASJava)(Deploy)P015+-+MSSQL+database+Communication+error