Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 15 Feb 2007 @ 09:50:09 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Data row too long!!!
From:   Mohd Suhail

Hi Anand,

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.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020