Product:TIBCO Spotfire Server
Versions:All Versions
Summary:
This article describes the meaning of the the mentioned Teradata exception and how to address it.
Details:
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:
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.
Versions:All Versions
Summary:
This article describes the meaning of the the mentioned Teradata exception and how to address it.
Details:
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.