When the options MULTISTATEMENT=YES and TPT=YES are used with the SAS Workspace server, 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 found in the log table for the recovery process. This temporary file is created in a directory where the user that is connecting from the workspace server might not have access privileges. If this user is in the administrator group on the server machine, they should not encounter this problem. But if the user is in another group, they might not have access to the file system where the temporary file is created. If they are in a different group then the error might occur.