Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 20 Sep 2007 @ 14:07:47 GMT


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


Subj:   FastExport Error from NT
 
From:   Watry, Mike

When running a fastExport from Informatica on an NT Server the CTL file contains the following.

".EXPORT OUTFILE '\\.\pipe\StoreItemPrice' FORMAT FASTLOAD MODE INDICATOR;"


When the dataset has a lot of columns I get the following Error.

**** 08:32:33 UTY8725 Select execution completed. 308 data blocks generated.

**** 08:32:38 UTY4014 Access module error '34' received during 'write' operation: 'pmunxWBuf: fwrite byte count error (Invalid argument)'

**** 08:32:38 UTY8721 Error attempting to write file \\.\pipe\StoreItemPrice, return code is 12.


When I take out the //./Pipe/ it writes out the file to the NT file system without error.

I am running many fastExports using Informatca but it only seems to work on exports with a small number of columns. Even when the query will only return one row the fast export will fail if there are a lot of columns.

Any Ideas why I am getting this error? Is there some row size limit that I maybe exceeding when using the "//./Pipe/" command? The current extract I am working with has a row length of 143.


Thanks,

Mike



     
  <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: 27 Dec 2016