Information Link fails with error: “Failed to execute query: [Teradata JDBC Driver] [TeraJDBC <xx.xx.xx.xx>] [Error 1013] [SQLState HY000] Request requires message size: <x>, exceeds system limit: 1048500”
Article ID: KB0081754
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | All Versions |
Description
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)
Resolution
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.
Issue/Introduction
This article describes the meaning of the the mentioned Teradata exception and how to address it.
Additional Information
External: Teradata JDBC driver 1013 error
Feedback
Yes
No
Powered by
