Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 11 Dec 2002 @ 13:59:04 GMT

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

Subj:   Re: Compatibility issues between TUF 6.0.1 and TUF 6.1.1
From:   Geoffrey Rommel

  While we ran our existing scripts we got the message  

  5:17:55 UTY8001 RDBMS failure in Packing Test: 5793, Limit on the number of host variables in USING modifier exceeded  

  The packing factor used was 31 and the number of columns in the Teradata table is 23. Is there any relationship between packing factor & number of columns in the target table?  

Well, sort of. I believe this message is telling you that TPump was trying to pack 31 statements into a single request. Each statement required 23 host variables (one for each column), so you needed a total of 31 * 23 = 713 variables in the USING clause. Apparently this is bigger than the maximum; unfortunately the manuals don't seem to say what the maximum is (grrrr...). You should be able to get around this by specifying a lower packing factor.


  <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: 15 Jun 2023