Error while loading data into a Teradata table using SAS

Banu — Mon, 04 Jun 2018 01:24:24 GMT

Hi Team,

One of my job loading data from SAS to Teradata by using below syntax.
However job is running fine for few days back. Currently it is failing with below error message.

Please help me what would be the permanent solution for this issue.

CODE:
=======
data TD_TABLE(TPT=YES FASTLOAD=YES TPT_MAX_SESSIONS=4 SLEEP=5 TENACITY=4);

set SAS_TABLE;

run;

ERROR:
========
NOTE: Appending WORK.SAS_TABLE to TD_TABLE
NOTE: There were 1 observations read from the data set WORK.SAS_TABLE.
NOTE: 0 observations added.
NOTE: The data set TD_TABLE has . observations and 1 variables.
ERROR: Teradata connection: 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, use the same value in the restart.

Please help me for permanent fix for this issue.

Re: Error while loading data into a Teradata table using SAS

LinusH — Mon, 04 Jun 2018 06:27:09 GMT

Well the message doesn't really tell what the actual error is. If this is not a temporary connection issue, I'll put a few cents that you are violating a Teradata constraint. Try
Options sastrace = ',,,d' sastraceloc = saslog nostsuffix;
which might give some info about what's going on in Teradata.

topic Error while loading data into a Teradata table using SAS in SAS Programming

Error while loading data into a Teradata table using SAS

Re: Error while loading data into a Teradata table using SAS