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

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
------------------------

Issue/Introduction

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

Environment

All Supported Environments

Resolution

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

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

 
Powered by Wolken Software