topic Error loading data to Teradata via SAS ACCESS - Operation not allowed: [Table name] is being loaded in SAS Programming

Error loading data to Teradata via SAS ACCESS - Operation not allowed: [Table name] is being loaded

lukesirakos — Tue, 09 Jan 2018 17:40:34 GMT

I have been loading SAS datasets to tables in Teradata using fastload (an example of code is below) and yesterday I tried to load a table but it gave me an error that I ran out of space. I deleted a big table and tried again and I keep getting an error that says:

"ERROR: Fastload failed the end loading statement: Operation not allowed: [Table Name] is being Loaded."

Where I put [Table Name] it is a table name that isn't exactly the table I am trying to load. Let's say my table name is ThisIsMyTableName, in the error message it is saying ThisIsMyTableNa_SE2_1831116450 is being loaded.

I am guessing when I tried to load the data the first time it created some temporary tables and now it is stuck trying to load those? Any ideas on how I can fix this issue and load the data? Below is an example of the datastep code I am using to load the data:

data MyDB.ThisIsMyTableName (FASTLOAD=YES TPT=YES DBCOMMIT=0);

set work.ThisIsMyTableName;

run;

Re: Error loading data to Teradata via SAS ACCESS - Operation not allowed: [Table name] is being loa

LinusH — Tue, 09 Jan 2018 18:45:06 GMT

I'm leaning towards your guess that that there are some leftovers in TD. Since the error message is generated by TD you should talk to your TD DBA.

Re: Error loading data to Teradata via SAS ACCESS - Operation not allowed: [Table name] is being loa

lukesirakos — Thu, 11 Jan 2018 17:09:44 GMT

Issue ended up being Teradata was using the first column in my dataset as the primary index and it was not a field that should be used as such. Changed the order of the columns and it worked fine.

Re: Error loading data to Teradata via SAS ACCESS - Operation not allowed: [Table name] is being loa

kiranv_ — Fri, 19 Jan 2018 18:27:28 GMT

you need not change the order of columns. All you need to do is to use option dbcreate_table_opts as shown below

data tdtable.employee_scoring (dbcreate_table_opts= 'primary index(employee_number)');

set work.employee_scoring(keep= Job_type employee_number Sal, Sal_rating);

run;