Fetching morethan 10k rows from Teradata datasource via Information services results in "Socket communication failure for Packet receive" error

book

Article ID: KB0079474

calendar_today

Updated On:

Products Versions
Spotfire Server All Supported Versions

Description

With Teradata JDBC driver version 15.10.00.14, trying to fetch morethan 10000 records via Information Services may throw the following error:

------------------------
Caused by: com.spotfire.ws.im.IMException: Failed to execute query: [Teradata JDBC Driver] [TeraJDBC 15.10.00.14] [Error 804] [SQLState 08S01] Socket communication failure for Packet receive
------------------------

Environment

All Supported Environments

Resolution

This is caused by the JDBC driver incompatibility. To resolve this issue, use the latest & compatible JDBC driver.

Issue/Introduction

Unable to fetch morethan 10 k rows from Teradata datasource via Information services.

Additional Information

https://community.teradata.com/t5/Connectivity/Error-quot-java-io-IOException-Bad-response-message-header-with/td-p/77492

http://developer.teradata.com/doc/connectivity/jdbc/reference/current/platformMatrix.html