Problem Note 65701: Trying to load a Teradata table into SAS® Cloud Analytic Services (CAS) might result in errors
 |  |  |  |  |
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:
ERROR: General error The user does not have CREATE TABLE access to database MY_TERADATA DATABASE.
ERROR: An error occurred while creating the Teradata table.
ERROR: Base table or view not found Object '_hpsvI1111111111' does not exist.
ERROR: Base table or view not found Object '_hpsvI1111111111' does not exist.
NOTE: Action failed during Embedded Process processing. Not retrying action due to dataTransferMode setting of parallel.
ERROR: The action stopped due to errors.
ERROR: An error occurred while creating the Teradata table.
ERROR: Base table or view not found Object '_hpsvI1111111111' does not exist.
ERROR: Base table or view not found Object '_hpsvI1111111111' does not exist.
NOTE: Action failed during Embedded Process processing. Not retrying action due to dataTransferMode setting of parallel.
ERROR: The action stopped due to errors.
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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Connector to Teradata | Linux for x64 | V.03.05 | Viya | ||
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
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-03-20 07:34:07 |
| Date Created: | 2020-03-17 15:57:50 |