When you use the options MULTISTATEMENT=YES and TPT=YES in SAS/ACCESS Interface to Teradata, you might receive an error similar to the following:
ERROR: Teradata connection: streamop.dll) instance(1): RESTART method failed with status = Fatal Error Correct error and restart as an APPEND process with option TPT_RESTART=YES. Since no checkpoints were taken, if the previous run used FIRSTOBS=n or TPT_CHECKPOINT_DATA=m, use the same value in the restart.
This issue occurs because of a permission problem. Teradata creates the temporary file that is used to sort the partial checkpoint rows that are found in the log table for the recovery process. This temporary file is created in a directory where the user that is connecting might not have access privileges, resulting in the error.
When running a Teradata Parallel Transporter (TPT) MultiLoad or Multi-Statement job that requires restarting, the users must be in an administrator group on the server machine and have Write permission to the location from which they are running.
Currently, this is the only workaround.