Issue while Inserting/Appending Records in Teradata Table through SAS

RahulG1 — Fri, 20 Sep 2019 13:44:25 GMT

I am trying to read/select records from SQL server and insert/append the same records to a Teradata Table.

When Using Mload Teradata Utility through 'DATA' Step in SAS.

SAS Enterprise Guide crashes when it encounters MLOAD.

SAS Version is SAS 9.4 TS Level 1M3

The Error meassage is

“Read Access Violation APPEND (2)

Exception occurred at (0A67F9EC)”

The Code is

----------------------------------------------------------------------------------------------------

%let uid = xxx;
%let pwd = xxx;

OPTIONS sastrace=",,,d";

LIBNAME DUMMY TERADATA USER= "&uid.@LDAP" PASS="&pwd." mode=ansi server="DUMMY_SERVER" schema="DUMMY_SCHEMA";
LIBNAME DUMMY_SQL ODBC DSN="DUMMY" USER="&uid.@LDAP" PASSWORD="&pwd." SCHEMA="TEST_SCHEMA";

PROC SQL;
CONNECT TO ODBC(DSN="DUMMY" USER="&uid.@LDAP" PASSWORD="&pwd.");
CREATE TABLE WORK.INTERMEDIATE_TABLE AS
SELECT * FROM CONNECTION TO ODBC(SELECT top 2000 COLUMN_1 FROM TEST_TABLE
);
QUIT;

DATA DUMMY.TARGET_TABLE(DBCREATE_TABLE_OPTS="PRIMARY INDEX(COLUMN_1)" MultiLoad=YES
ML_LOG=TEST_LOG ML_CHECKPOINT=500);
SET WORK.INTERMEDIATE_TABLE;
RUN;

--------------------------------------------------------------------------------------------------

Also, tried using TPT Utility too, faced the same issue

DATA DUMMY.TARGET_TABLE(DBCREATE_TABLE_OPTS="PRIMARY INDEX(COLUMN_1)" TPT=YES MultiLoad=YES
ML_LOG=TEST_LOG ML_CHECKPOINT=500);
SET WORK.INTERMEDIATE_TABLE;
RUN;

Re: Issue while Inserting/Appending Records in Teradata Table through SAS

JosvanderVelden — Fri, 20 Sep 2019 17:30:38 GMT

Which OS?
Have you read the paper: http://support.sas.com/resources/papers/teradata.pdf

Re: Issue while Inserting/Appending Records in Teradata Table through SAS

RahulG1 — Mon, 23 Sep 2019 10:14:39 GMT

The OS is windows

Windows Version 6.2.9200

Thanks for the paper, I have gone through this. The problem still persists

topic Re: Issue while Inserting/Appending Records in Teradata Table through SAS in SAS Programming

Issue while Inserting/Appending Records in Teradata Table through SAS

Re: Issue while Inserting/Appending Records in Teradata Table through SAS

Re: Issue while Inserting/Appending Records in Teradata Table through SAS