 |
 |
Archives of the TeradataForum
Message Posted: Wed, 11 Dec 2002 @ 13:59:04 GMT
| 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.
--wgr
| |
