When you try to use DATATRANSFERMODE=PARALLEL to do a parallel load of a Teradata table into SAS Cloud Analytics Services (CAS) server, you might see errors similar to the following:
ERROR: General error in UDF/XSP/UDM SAS_SYSFNLIB.SASTBLOP_CONTRACT: SQLSTATE U1010: DS2 program failed to be prepared. TKTSPrepare returned 0x80fff802.
ERROR: General error in UDF/XSP/UDM SAS_SYSFNLIB.SASTBLOP_CONTRACT: SQLSTATE U1010: DS2 program failed to be prepared. TKTSPrepare returned 0x80fff802. Compilation error.
ERROR: Column not found.
ERROR: Line 1: Unable to prepare SQL query (rc=0x80fff802U).
ERROR: [HY000]Compilation error. (0x817ff229).
NOTE: Action failed during Embedded Process processing. Not retrying action due to dataTransferMode setting of parallel.
ERROR: Function failed.
ERROR: The action stopped due to errors.
The issue occurs when the Teradata table contains a variable defined as the Teradata timestamp(6) with the time zone data type, which is not currently supported with SAS® Viya®.
The only workaround is to use the VARS= option to specify all of the other variables that exist in the table, excluding any columns defined as a timestamp with time zone data type:
vars=((name="var1"), (name="var2"), name=("var3"))