Archives of the TeradataForum

Message Posted: Thu, 26 Apr 2007 @ 09:38:20 GMT

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

UTY4014 Access module error '34' received during 'set position' operation

This error occurs when the job has been restarted due to a previous failure. The application is trying to read the data from the last successful checkpoint. The error usually occurs because the input file is a pipe, rather than a file.

If the input file is a pipe then the user needs to use the Named Pipe Access Module available on either the Load/Unload or Teradata Utilities Pack CD.

This module will temporarily store the data from the pipe in a temporary disk file between successful checkpoints.

Without

     Fexp >> pipe << MLoad

With the access module

     Fexp >> pipe << axsmod >>  tmp file << mload

(mload is fed the data by axsmod at the same time it is buffered)

If the job fails now the tmp file will contain all the data since the last successful checkpoint.

For example, if we checkpoint every 100000 rows and have successful checkpoints at 100000, 200000, 300000 then the job fails before 400000 all the data from 300000 on is in the tmp file, so the job will restart successfully.

Note that the Named Pipe Access module is only available for reading, not writing.

This means that if you use FastExport to output data to a named pipe which is read by MultiLoad or one of the other load utilities, the Named Pipe Access Module cannot be applied to the FastExport job in an attempt to buffer the data. It must be applied to load utility by specifying the appropriate Assumed parameter on the .import command line of a MultiLoad script. See the appropriate Load utility documentation for instructions on how to do this.

Best Regards,

Rehan A. Khan, PMP
Teradata Certified Master
Teradata, A Division of NCR

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