Problem Note 60524: Multiple sets of quotation marks around values for publishing UDF to Greenplum returns "ERROR: CLI error trying to establish connection ..."
When you use SAS® Model Manager to publish an UDF for a model to Greenplum, the following error might occur:
ERROR: CLI error trying to establish connection: [SAS][ODBC Greenplum Wire Protocol driver]Socket closed. : [SAS][ODBC Greenplum Wire Protocol driver]Socket closed. : [SAS][ODBC Greenplum Wire Protocol driver][Greenplum]FATAL: password authentication failed for user "XXXXXXXXX"(File auth.c; Line 326; Routine auth_failed; )
The error occurs because the server and password have extra single-quotation-marks in the LIBNAME statement.
To work around the problem, ensure that there are no extra single-quotation-marks in the LIBNAME statement.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Model Manager | Microsoft® Windows® for x64 | 14.2 | 14.2_M1 | 9.4 TS1M4 | 9.4 TS1M6 |
Microsoft Windows 8 Enterprise x64 | 14.2 | 14.2_M1 | 9.4 TS1M4 | 9.4 TS1M6 |
Microsoft Windows 8 Pro x64 | 14.2 | 14.2_M1 | 9.4 TS1M4 | 9.4 TS1M6 |
Microsoft Windows 8.1 Enterprise 32-bit | 14.2 | 14.2_M1 | 9.4 TS1M4 | 9.4 TS1M6 |
Microsoft Windows 8.1 Enterprise x64 | 14.2 | 14.2_M1 | 9.4 TS1M4 | 9.4 TS1M6 |
Microsoft Windows 8.1 Pro x64 | 14.2 | 14.2_M1 | 9.4 TS1M4 | 9.4 TS1M6 |
Microsoft Windows 10 | 14.2 | 14.2_M1 | 9.4 TS1M4 | 9.4 TS1M6 |
Microsoft Windows Server 2012 Datacenter | 14.2 | 14.2_M1 | 9.4 TS1M4 | 9.4 TS1M6 |
Microsoft Windows Server 2012 R2 Datacenter | 14.2 | 14.2_M1 | 9.4 TS1M4 | 9.4 TS1M6 |
Microsoft Windows Server 2012 R2 Std | 14.2 | 14.2_M1 | 9.4 TS1M4 | 9.4 TS1M6 |
Microsoft Windows Server 2012 Std | 14.2 | 14.2_M1 | 9.4 TS1M4 | 9.4 TS1M6 |
Windows 7 Enterprise x64 | 14.2 | 14.2_M1 | 9.4 TS1M4 | 9.4 TS1M6 |
Windows 7 Home Premium x64 | 14.2 | 14.2_M1 | 9.4 TS1M4 | 9.4 TS1M6 |
Windows 7 Professional x64 | 14.2 | 14.2_M1 | 9.4 TS1M4 | 9.4 TS1M6 |
Windows 7 Ultimate x64 | 14.2 | 14.2_M1 | 9.4 TS1M4 | 9.4 TS1M6 |
64-bit Enabled AIX | 14.2 | 14.2_M1 | 9.4 TS1M4 | 9.4 TS1M6 |
64-bit Enabled Solaris | 14.2 | 14.2_M1 | 9.4 TS1M4 | 9.4 TS1M6 |
HP-UX IPF | 14.2 | 14.2_M1 | 9.4 TS1M4 | 9.4 TS1M6 |
Linux for x64 | 14.2 | 14.2_M1 | 9.4 TS1M4 | 9.4 TS1M6 |
Solaris for x64 | 14.2 | 14.2_M1 | 9.4 TS1M4 | 9.4 TS1M6 |
*
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.
Multiple sets of quotation marks around values for publishing UDF to Greenplum returns "ERROR: CLI error trying to establish connection ..."
Type: | Problem Note |
Priority: | high |
Topic: | Analytics ==> Model Management
|
Date Modified: | 2018-08-15 08:11:49 |
Date Created: | 2017-05-24 16:19:49 |