Trying to load a Teradata table into CAS might result in errors when the following is true:

• You are running SAS^® Viya^® 3.5.
• You are trying to run a PROC CASUTIL LOAD statement or use the LOADTABLE action.
• You are using datatransfermode='PARALLEL'.
• You do not have create table authority for the database in which the table resides.

In this scenario, the errors and notes might look similar to the following:

Here are the workarounds for this issue:

• GRANT create table on the database containing the tables/views to be loaded and make sure that the database has some perm space.
• Create a new database with views that point to the database from which the tables/views are to be loaded, and do everything in the new database.
• Switch to a datatransfermode='SERIAL' to load the table serially rather than in parallel.

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.

The hot fix addresses the issue when you use DATABASE= in the CASLIB statement. If you are currently using SCHEMA= in your CASLIB statement, you must switch to using DATABASE=.  

Operating System and Release Information

Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at