Error while loading data into a Teradata table using SAS

Reply
Contributor
Posts: 44

Error while loading data into a Teradata table using SAS

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.

 

 

Super User
Posts: 5,890

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

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.
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 100 views
  • 1 like
  • 2 in conversation