DATA Step, Macro, Functions and more

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

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 6
Accepted Solution

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

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;


Accepted Solutions
Solution
‎01-11-2018 12:09 PM
Occasional Contributor
Posts: 6

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

Posted in reply to lukesirakos

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.

View solution in original post


All Replies
Super User
Posts: 5,852

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

Posted in reply to lukesirakos
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.
Data never sleeps
Solution
‎01-11-2018 12:09 PM
Occasional Contributor
Posts: 6

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

Posted in reply to lukesirakos

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.

PROC Star
Posts: 503

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

Posted in reply to lukesirakos

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;

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 127 views
  • 1 like
  • 3 in conversation