How to configure timeout settings for the Snowflake, Drill and Dremio connectors in TIBCO Spotfire

How to configure timeout settings for the Snowflake, Drill and Dremio connectors in TIBCO Spotfire

book

Article ID: KB0074518

calendar_today

Updated On:

Products Versions
Spotfire Analyst 10.9 and higher

Description

From TIBCO Spotfire Analyst version 10.9, it is possible to add and configure timeout setting for the Snowflake, Drill and Dremio Connectors. This is done by adding the setting "CommandTimeoutInSeconds" to Spotfire.Dxp.Main.dll.config file, located in the folder <Spotfire Analyst installation dir>\Modules\Spotfire DXP Forms_xxx.

Note: settings of this kind are overwritten when you update TIBCO Spotfire Analyst (to a new version, or just with a new hotfix), so you will need to configure this again after updates.  

Issue/Introduction

From TIBCO Spotfire version 10.9, it is possible to add and configure timeout setting for the Snowflake, Drill and Dremio connectors. This is done by adding the setting "CommandTimeoutInSeconds" in the Spotfire.Dxp.Main.dll.config file.

Environment

All

Resolution

How to add the CommandTimeoutInSeconds setting:
1. Go to folder "<Spotfire installation directory>\Modules\Spotfire DXP Forms_xxx" and open file Spotfire.Dxp.Main.dll.config in a text editor.
2. Copy and add the line 
<section name="Spotfire.Dxp.Data.Adapters.Odbc.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false"/>

 in the following location:
  
<sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
     ...
 <section name="Spotfire.Dxp.Data.Adapters.Odbc.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false"/>
    </sectionGroup>

3. Copy and add the setting  
<Spotfire.Dxp.Data.Adapters.Odbc.Properties.Settings>
        <setting name="CommandTimeoutInSeconds" serializeAs="String">
            <value>[desired timeout in seconds]</value>
        </setting>
    </Spotfire.Dxp.Data.Adapters.Odbc.Properties.Settings>
in the following location: 
<applicationSettings>
    ...
    <Spotfire.Dxp.Data.Adapters.Odbc.Properties.Settings>
        <setting name="CommandTimeoutInSeconds" serializeAs="String">
            <value>[desired timeout in seconds]</value>
        </setting>
    </Spotfire.Dxp.Data.Adapters.Odbc.Properties.Settings>
</applicationSettings>
4. In this setting, replace "[desired timeout in seconds]" with timeout specified in seconds. The timeout is 1800 seconds (30 minutes) by default. 
5. Save and close the file.
6. Restart TIBCO Spotfire Analyst.  

Additional Information

keywords: snowflake, drill, dremio, connector, timeout, CommandTimeoutInSeconds  
Powered by Wolken Software