Information Link fails with error: “Failed to execute query: [Teradata JDBC Driver] [TeraJDBC ] [Error 1013] [SQLState HY000] Request requires message size: , exceeds system limit: 1048500”

Created
October 08, 2021 23:26

Date Posted: 2018-06-01
Product: TIBCO Spotfire®

Problem:

Solution:

When executing an Information Link based on a Teradata data source, it may fail with the following error seen in the TIBCO Spofire Server server.log file. For example:

api.common.InformationModelServiceCommon: Failed to execute query: [Teradata JDBC Driver] 
[TeraJDBC 15.10.00.35] [Error 1013] [SQLState HY000] Request requires message size: 4053867,
exceeds system limit: 1048500
com.spotfire.ws.api.common.InformationModelWebServiceException: Failed to execute query: [Teradata JDBC Driver] 
[TeraJDBC 15.10.00.35] [Error 1013] [SQLState HY000] Request requires message size: 4053867, 
exceeds system limit: 1048500 at 
com.spotfire.ws.api.common.InformationModelServiceCommon.wrapException(InformationModelServiceCommon.java:654)
at com.spotfire.ws.api.common.InformationModelServiceCommon.wrapException(InformationModelServiceCommon.java:582)

This exception is thrown from the Teradata server if the submitted SQL query from Spotfire exceeds 1048500 bytes. This limit is from the Teradata instance that is being used which does not accept the query with size greater than 1048500 bytes. This is not a Spotfire specific issue, so to resolve please contact the Teradata administrators.
External: Teradata JDBC driver 1013 error

https://community.teradata.com/t5/Connectivity/Teradata-JDBC-driver-1013-error/td-p/51194