SUPPORT

Select Your Region

Visit the Cary, NC, US corporate headquarters site

Americas

Europe

Middle East & Africa

Asia Pacific

View our worldwide contacts list for help finding your region

Americas

Europe

Middle East & Africa

Asia Pacific

Sign In

Get access to My SAS, trials, communities and more.

Sign Out

Get access to My SAS, trials, communities and more.

SAS Sites

sas.com
Support
Blogs
Communities
Developer
Curiosity
Videos

Documentation

Learn
Brand
PartnerNet
Merchandise
SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 59600: Publishing a UDF to Greenplum returns "ERROR: Failed to drop the external table"

DetailsHotfixAboutRate It

In SAS Model Manager, when you publish a model as a UDF to the Greenplum database, the following error might occur:

ERROR: Failed to drop external table

This error occurs when the Greenplum user ID contains a single quotation mark.

A workaround is to remove the single quotation mark from the user ID.

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Model ManagerMicrosoft® Windows® for x6413.114.29.4 TS1M29.4 TS1M4
Microsoft Windows 8 Enterprise x6413.114.29.4 TS1M29.4 TS1M4
Microsoft Windows 8 Pro x6413.114.29.4 TS1M29.4 TS1M4
Microsoft Windows 8.1 Enterprise x6413.114.29.4 TS1M29.4 TS1M4
Microsoft Windows 8.1 Pro x6413.114.29.4 TS1M29.4 TS1M4
Microsoft Windows 1013.114.29.4 TS1M29.4 TS1M4
Microsoft Windows Server 200813.114.29.4 TS1M29.4 TS1M4
Microsoft Windows Server 2008 R213.114.29.4 TS1M29.4 TS1M4
Microsoft Windows Server 2008 for x6413.114.29.4 TS1M29.4 TS1M4
Microsoft Windows Server 2012 Datacenter13.114.29.4 TS1M29.4 TS1M4
Microsoft Windows Server 2012 R2 Datacenter13.114.29.4 TS1M29.4 TS1M4
Microsoft Windows Server 2012 R2 Std13.114.29.4 TS1M29.4 TS1M4
Microsoft Windows Server 2012 Std13.114.29.4 TS1M29.4 TS1M4
Windows 7 Enterprise x6413.114.29.4 TS1M29.4 TS1M4
Windows 7 Home Premium x6413.114.29.4 TS1M29.4 TS1M4
Windows 7 Professional x6413.114.29.4 TS1M29.4 TS1M4
Windows 7 Ultimate x6413.114.29.4 TS1M29.4 TS1M4
64-bit Enabled AIX13.114.29.4 TS1M29.4 TS1M4
64-bit Enabled Solaris13.114.29.4 TS1M29.4 TS1M4
HP-UX IPF13.114.29.4 TS1M29.4 TS1M4
Linux for x6413.114.29.4 TS1M29.4 TS1M4
Solaris for x6413.114.29.4 TS1M29.4 TS1M4
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.