MyAlteryx
Community
Academy
Help Docs

Welcome to the Alteryx Knowledge Base

Knowledge Base / Designer / Error: "SQLExtendedFetch: [Simba][Hardy] Error from server: error code: '0' error message: '[Si...
Error: "SQLExtendedFetch: [Simba][Hardy] Error from server: error code: '0' error message: '[Simba][Hardy] (134): A retriable error occurred while attempting to download a result file from the cloud store but the retry limit had been exceeded"
user

Created/Edited - 12/6/2024 by London Hanson | Alteryx

Summary
When exporting a large amount of data from Databricks (over 500k rows), a result file download error is received.
Environment

Error: “SQLExtendedFetch: [Simba][Hardy] (35) Error from server: error code: '0' error message: '[Simba][Hardy] (134) File 9a570f01-7ebe-4c15-861c-5f89b6d1f8d6: A retriable error occurred while attempting to download a result file from the cloud store but the retry limit had been exceeded. Error Detail: File 9a570f01-7ebe-4c15-861c-5f89b6d1f8d6: The result file URL had expired on 1668634666916 (Unix timestamp)'. (ToolId: 1)”

 

Environment Details

When exporting a large amount of data from Databricks (over 500k rows), a result file download error is received.

Error SQLExtendedFetch: [Simba][Hardy] (35) Error from server: error code: '0' error message: '[Simba][Hardy] (134) File 9a570f01-7ebe-4c15-861c-5f89b6d1f8d6: A retriable error occurred while attempting to download a result file from the cloud store but the retry limit had been exceeded. Error Detail: File 9a570f01-7ebe-4c15-861c-5f89b6d1f8d6: The result file URL had expired on 1668634666916 (Unix timestamp)'. (ToolId: 1)
 
  • Alteryx Designer, Server
  • Apache Spark
  • Apache Spark on Databricks driver
    • Version 2.6.23.1039
Cause

Cause

 

This error message comes from Apache Spark/Databricks and indicates the resulting query file cannot be downloaded. This can be due to many reasons, such as security policies, available space, or throttle limits.

Resolution

Resolution

 

Solution

Add "EnableQueryResultDownload=0" as a parameter in the connection string. This disables CloudFetch, preventing the download attempt. Example:
odbc:Driver={Simba Spark ODBC Driver};Host=[databrickshost];Port=443;HTTPPath=[sqlpath];ThriftTransport=2;SSL=1;UseNativeQuery=1;EnableQueryResultDownload=0;FastSQLPrepare=1;AuthMech=3;UID=token;PWD=[token]
Additional Information

Additional Resources

Was this article helpful?