connection error with Amazon RedShift

gerrycastellino — Wed, 27 Jul 2016 22:16:08 GMT

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.

Re: connection error with Amazon RedShift

gerrycastellino — Thu, 28 Jul 2016 18:31:25 GMT