SUPPORT / SAMPLES & SAS NOTES
Problem Note 67782: The error "...ROLLBACK...Table...does not exist" occurs in SAS/ACCESS® Interface to Vertica when you try to drop a Vertica view
 |  |  |  |  |
When you use SAS/ACCESS Interface to Vertica with a DROP VIEW statement, the Vertica engine attempts to drop a table instead.
When you encounter this issue, you receive an error similar to the following:
ERROR: CLI execute error: ROLLBACK 4876: Table "view-name" does not exist
The workaround is to use an explicit SQL query to drop the view. Here is a syntax example:
proc sql ;
connect to vertica as dbcon (connection-options) ;
execute (drop view view-name) by dbcon;
quit ;
connect to vertica as dbcon (connection-options) ;
execute (drop view view-name) by dbcon;
quit ;
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Vertica | Microsoft® Windows® for x64 | 9.4_M5 | 9.4_M8 | 9.4 TS1M5 | 9.4 TS1M8 |
| 64-bit Enabled AIX | 9.4_M5 | 9.4_M8 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| 64-bit Enabled Solaris | 9.4_M5 | 9.4_M8 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| HP-UX IPF | 9.4_M5 | 9.4_M8 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Linux for x64 | 9.4_M5 | 9.4_M8 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Solaris for x64 | 9.4_M5 | 9.4_M8 | 9.4 TS1M5 | 9.4 TS1M8 | ||