All Forums Connectivity
MaSEL 2 posts Joined 07/10
15 Dec 2010
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] [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?

tomnolan 594 posts Joined 01/08
20 Dec 2010

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.

You must sign in to leave a comment.