Error message "An error occurred in the external data source" appears in the Spotfire client when running a long-running query using the Snowflake connector

Error message "An error occurred in the external data source" appears in the Spotfire client when running a long-running query using the Snowflake connector

book

Article ID: KB0070311

calendar_today

Updated On:

Products Versions
Spotfire Analyst 10.3 and higher

Description

When running queries against Snowflake databases, using the Snowflake connector, an error similar to below sometimes appears: 
Error message: An error occurred in the external data source.

ImportException at Spotfire.Dxp.Data:
An error occurred in the external data source.
External error:
ERROR [HY000] [Snowflake][Snowflake] (1) 
      Query has timed out. User specified timeout in seconds=30, Elapsed=45

This error appears when running long-running queries against a Snowflake database using the Snowflake connector, while shorter-running queries are completed successfully. 

Issue/Introduction

When running long-running queries using the Snowflake connector, either in Web Player or Analyst client, the error message "An error occurred in the external data source" (with "Query has timed out" in the details) appears.

Resolution

The issue occurs because of query timeouts. This can be addressed using the configurable timeouts that have been introduced for the Snowflake connector in the following versions (note: the default value has also been increased to 30 minutes):
  • TIBCO Spotfire 10.3.3 LTS hotfix HF-014
  • TIBCO Spotfire 10.8.0 hotfix HF-002
  • TIBCO Spotfire 10.9 and higher

Additional Information

List of hotfixes for Spotfire Clients (Analyst, Web Player (Consumer/Business Author) and Automation Services)
Keywords: snowflake, connector, An error occurred in the external data source, ERROR [HY000] [Snowflake],  Query has timed out, User specified timeout in seconds=30, Elapsed=45
Powered by Wolken Software