connection error with Amazon RedShift

[gerrycastellino]

We get the below error with 'tuple'  when running this extract on the server.

The table has 31M records.

I can extract fine on my laptop...

Thankx in advance..

7/27/2016 3:06:51 PM: 0103  SQL SELECT

7/27/2016 3:06:51 PM: 0104      "software_coordinator_sfdc_id",

7/27/2016 3:06:51 PM: 0105      "asset_product_line_cd",

7/27/2016 3:06:51 PM: 0106      "asset_product_line_description",

7/27/2016 3:06:51 PM: 0107      "asset_product_release",

7/27/2016 3:06:51 PM: 0108      "asset_usage_type_cd",

7/27/2016 3:06:51 PM: 0109      "asset_subs_flag",

7/27/2016 3:06:51 PM: 0110      "asset_subs_history_flag",

7/27/2016 3:06:51 PM: 0111      "asset_status",

7/27/2016 3:06:51 PM: 0112      "agreement_end_date",

7/27/2016 3:06:51 PM: 0113      "account_uuid",

7/27/2016 3:06:51 PM: 0114      "account_name",

7/27/2016 3:06:51 PM: 0115      "account_csn",

7/27/2016 3:06:51 PM: 0116      "named_account_group_name",

7/27/2016 3:06:51 PM: 0117      "contract_manager_sfdc_id",

7/27/2016 3:06:51 PM: 0118      "substype"

7/27/2016 3:06:51 PM: 0119  FROM ucpprd.mktg_ops_sandbox.tblas_assetdetail

7/27/2016 3:07:20 PM:       Error: SQL##f - SqlState: 08S01, ErrorCode: 26, ErrorMsg: Communication error while getting a tuple;

7/27/2016 3:07:20 PM:       Communication error while getting a tuple

7/27/2016 3:07:20 PM:       General Script Error

7/27/2016 3:07:20 PM:       Execution Failed

7/27/2016 3:07:20 PM:      Execution finished.

[gerrycastellino · Accepted solution]

resolution on "tuple communication error from Redshift"