Archives of the TeradataForum
Message Posted: Thu, 15 Feb 2007 @ 09:50:09 GMT
I checked out the meaning of error no 2513 in teradata help document. It contained the following information:
2513 A data row is too long.
Explanation: The length of the row specified by the caller is greater than SysMaxRow, the maximum length allowed for any row in the database. The row could be either one specified directly by the user, or an intermediate results row required for query processing.
This indicates that a row is too long. Query processing often requires intermediate results rows that are longer than the data being selected. For example, ORDER BY and GROUP BY columns require sort keys that increase intermediate results row size.
You may look for changing the value of the value of SysMaxRow. I am not so sure whether u can do that. Alternately you could think about removing the group by clause and change the query to:
select SqlTextInfo from dbc.QryLogSQL (works fine)
Hope I answered your question.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|