Teradata JDBC driver 1013 error

Connectivity
Fan

Teradata JDBC driver 1013 error

In the process of some heavy query (in the mean of data amount) execution my Java application got an Exception

caused by: java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 12.00.00.110] [Error 1013] [SQLState HY000] Request requires message size: 6080294, exceeds system limit: 1048500

Teradata messages documentation tells nothing but this information in TERAJDBC Driver Error Messages chapter:

____
1013 Request requires message size: %1,
exceeds system limit: %2
Explanation: Information not available.
Remedy: Information not available.
____

I have not found any useful information jn the other official Teradata materials also, including Teradata Driver for the JDBC
Interface User Guide.

Does anybody can help me with the root of the problem and possible solution?
Tags (1)
1 REPLY
Teradata Employee

Re: Teradata JDBC driver 1013 error

The most likely reason to get that exception message is if your application attempted to submit a SQL request whose SQL request text length is greater than 1048500 bytes long, after the Java String was converted into bytes per the session character set.

That limit of 1048500 bytes for SQL request text is imposed by the Teradata Database.