DATA Step, Macro, Functions and more

Teradata execute: The Maximum Possible Row Length in the Table is too Large..

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 9
Accepted Solution

Teradata execute: The Maximum Possible Row Length in the Table is too Large..

Hi all,

 

In the past, the following code has worked for me in moving a data set containing 14 million rows into Teradata without a hiccup. 

 

%put *** rchtera;
%dbcon(rchtera);
%libdbcon(tera,rchtera, dsw_raroc);

proc sql;
create table tera.LMA_1712 (fastload=yes sessions=4 tenacity=5 sleep=5 dbcommit=100000) as
select *
from data.LMA_1712_1;
quit; 

However this happened when I tried to do the same with another dataset I have:

 

ERROR: Error attempting to CREATE a DBMS table. ERROR: Teradata execute: The Maximum Possible Row Length in the Table is too Large.. So I divided my data into smaller datasets yet still no luck. Even cutting down the number of rows and dropping columns I don't need, I still get this error even when USCF_raw contains less than 600 rows. What can I do to get over this? 

 

proc sql;
create table tera.USCF_acclv_CO_Rcv (fastload=yes dbcommit=10000) as
select *
from myQRE.USCF_raw;
quit; 

 

Thanks again for any input.


Accepted Solutions
Solution
‎05-04-2018 02:37 PM
PROC Star
Posts: 2,319

Re: Teradata execute: The Maximum Possible Row Length in the Table is too Large..

The message is about row length, so splitting the table while keeping the same row length is not helping.

Have a look at your variables to see what could be causing the issue as @kiranv_ said. Can you shorten or remove some of them?

 

View solution in original post


All Replies
PROC Star
Posts: 504

Re: Teradata execute: The Maximum Possible Row Length in the Table is too Large..

if you teradata sql assistant check whether you character column which is very long. do a describe table in SAS for teradta table using libname or do a show table in Teradata SQL assistant.

Solution
‎05-04-2018 02:37 PM
PROC Star
Posts: 2,319

Re: Teradata execute: The Maximum Possible Row Length in the Table is too Large..

The message is about row length, so splitting the table while keeping the same row length is not helping.

Have a look at your variables to see what could be causing the issue as @kiranv_ said. Can you shorten or remove some of them?

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 222 views
  • 2 likes
  • 3 in conversation