Problem Note 59600: Publishing a UDF to Greenplum returns "ERROR: Failed to drop the external table"
 |  |  |  |  |
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 Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Model Manager | Microsoft® Windows® for x64 | 13.1 | 14.2 | 9.4 TS1M2 | 9.4 TS1M4 |
| Microsoft Windows 8 Enterprise x64 | 13.1 | 14.2 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro x64 | 13.1 | 14.2 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise x64 | 13.1 | 14.2 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro x64 | 13.1 | 14.2 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 10 | 13.1 | 14.2 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 | 13.1 | 14.2 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 R2 | 13.1 | 14.2 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 for x64 | 13.1 | 14.2 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Datacenter | 13.1 | 14.2 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 13.1 | 14.2 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Std | 13.1 | 14.2 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Std | 13.1 | 14.2 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Enterprise x64 | 13.1 | 14.2 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Home Premium x64 | 13.1 | 14.2 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Professional x64 | 13.1 | 14.2 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Ultimate x64 | 13.1 | 14.2 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| 64-bit Enabled AIX | 13.1 | 14.2 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| 64-bit Enabled Solaris | 13.1 | 14.2 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| HP-UX IPF | 13.1 | 14.2 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Linux for x64 | 13.1 | 14.2 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Solaris for x64 | 13.1 | 14.2 | 9.4 TS1M2 | 9.4 TS1M4 | ||
A fix for this issue for SAS Model Manager 14.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/V85.html#59600A fix for this issue for SAS Model Manager 13.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/S15.html#59600
Publishing a model in UDF to Greenplum fails, "ERROR: Failed to drop the external table"
| Type: | Problem Note |
| Priority: | high |
| Topic: | Analytics ==> Model Management |
| Date Modified: | 2020-02-25 14:40:58 |
| Date Created: | 2016-12-23 11:55:12 |