SAS Teradata Error

nickspencer — Wed, 31 Oct 2018 02:47:36 GMT

I have a sas code which writes into a teradata table. I have been running this code for a year now and was working perfectly fine. I haven’t made any changes to the code but since last two days it is giving me the error below.

ERROR: Teradata connection: CLI error 207 (no message text available) 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, uae the same value in the restart.
ERROR: ROLLBACK issued due to errors for data set mydata.dsn.data.

Code that inserts the data:
Proc sql;
Insert into mydata.dsn (multiload=yes tpt_restart=yes)
select a,
b,
c
from abc;
quit;

Is anyone familiar with this error message? The weird part is it was working fine and suddenly it is erroring out and nothing is updated in the code.
I am not sure if something changed in the Sas server or the database.
Any ideas or suggestions is highly apreciated. Thanks in advance.

Re: SAS Teradata Error

SASKiwi — Wed, 31 Oct 2018 03:26:39 GMT

If you Google this error you will see it pops up on Teradata forums and definitely appears to be a Teradata problem. I suggest you talk to your Teradata DBA to investigate.

topic Re: SAS Teradata Error in SAS Programming

SAS Teradata Error

Re: SAS Teradata Error