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.
