topic Re: Communication link failure when upload table to Netezza database in SAS Data Management

Communication link failure when upload table to Netezza database

shenghuani — Wed, 15 Aug 2018 14:08:47 GMT

When I used the following codes to upload tables from SAS to Netezza

PROC SQL;

CREATE TABLE OUT.&table_name

(bulkload=YES bl_options='logdir "f:\sasuser\netlog"')

select * from &Libname..&Table;

quit;

I got the error.

ERROR: Error terminating Netezza load: Communication link failure

There were no log and bad files from Netezza.

It is difficult to find the real causes.

Re: Communication link failure when upload table to Netezza database

shenghuani — Wed, 15 Aug 2018 14:16:47 GMT

One of the common cause I found is the SAS format issue.

If the SAS numeric columns were formatted as decimal format like '8.2' , the communication link failure would be found.

The solution is to modify the SAS tables with those format to no format, using the following (column_name is an example the the column with the decimal format).

format column_name;