How to resolve timeout errors when running Spotfire Data Functions connecting to TIBCO Spotfire Statistics Services (TSSS).

How to resolve timeout errors when running Spotfire Data Functions connecting to TIBCO Spotfire Statistics Services (TSSS).

book

Article ID: KB0070649

calendar_today

Updated On:

Products Versions
Spotfire Analyst All Versions

Description

The following timeout errors are encountered when submitting data function jobs to the TIBCO Spotfire Statistics Services server from the TIBCO Spotfire installed client:
Timed out connecting to http://<servername>:<port>/<servicename>/api/public/JobStatus/<jobId> after 10000 ms while downloading manifest. Please verify the URL.
   at Spotfire.Dxp.Data.SPlus.FunctionClient.GetWebResponseWithTimeout(WebRequest request)
   at Spotfire.Dxp.Data.SPlus.FunctionClient.GetWebResponseWithTimeout(String serviceUrl, String resourcePath, String method, ICredentials credentials)
   at Spotfire.Dxp.Data.SPlus.FunctionClient.Eval(String functionName, String packageName, SplusDataRequest inputData, CheckForCancel checkForCancel)
   at Spotfire.Dxp.Data.DataFunctions.Executors.RemoteFunctionClient.<>c__DisplayClass17.<OnExecuting>b__13()
   at Spotfire.Dxp.Framework.ApplicationModel.Progress.ExecuteSubtask(String title, ProgressOperation operation)
   at Spotfire.Dxp.Data.DataFunctions.Executors.RemoteFunctionClient.OnExecuting(FunctionClient funcClient)
   at Spotfire.Dxp.Data.DataFunctions.Executors.AbstractFunctionClient.<RunFunction>d__3.MoveNext()
   at Spotfire.Dxp.Data.DataFunctions.Executors.SPlusFunctionExecutor.<ExecuteFunction>d__3.MoveNext()
   at Spotfire.Dxp.Data.DataFunctions.DataFunctionExecutorService.<ExecuteFunction>d__6.MoveNext()

However, the jobs appear to be running successfully to completion when checking on the TIBCO Spotfire Statistics Services server, i.e. the http://<servername>:<port>/<servicename>/api/v8/jobs page shows the jobs are running successfully.

Issue/Introduction

How to resolve timeout errors when running Spotfire Data Functions connecting to TIBCO Spotfire Statistics Services (TSSS).

Resolution

In TIBCO Spotfire Statistics Services (TSSS) 7.5.0, an issue that can cause timeout errors and the inability to display the TSSS ExtendedServerInfo, which is required for the client to download the manifest on initial connection to the TSSS server, was fixed in TSSS 7.5.0 hotfix HF-003.  If you are using TSSS 7.5.0, to resolve apply TSSS 7.5.0 hotfix HF-003.

For other versions, if you have confirmed that Statistics Services is successfully running jobs, try to increase the timeout settings in the Spotfire client. To increase the timeout, do the following:

If using Spotfire 11.4.x (HF-004 or higher), 11.5.x (HF-001 or higher), or 11.6 or higher
From Spotfire 11.4.x (HF-004 or higher), 11.5.x (HF-001 or higher), and 11.6 or higher, a preference - Server Connect Timeout Seconds - has been introduced (default value: 10 seconds). Try increasing this value - e.g. double it to 20 seconds to start with - for the relevant groups (e.g. the Everyone group to increase it for all users). 
 
For more information about this preference, please refer to the TIBCO Spotfire Administration Manager documentation > TIBCO Spotfire Statistics Services Preferences:
https://docs.tibco.com/pub/sfire-analyst/12.0.3/doc/html/en-US/TIB_sfire-analyst_AdminGuide/index.htm#t=dxpadminmanager%2Fpref_tibco_spotfire_statistics_services.htm

For information on working with preferences in general, please refer to the page "Setting Preferences for a Group" in the TIBCO Spotfire Administration Manager documentation: 
https://docs.tibco.com/pub/sfire-analyst/12.0.3/doc/html/en-US/TIB_sfire-analyst_AdminGuide/index.htm#t=dxpadminmanager%2Fpref_setting_preferences.htm


If using older versions - Spotfire 11.4.x (HF-003 or lower), 11.5.0, or 11.3 or lower.
WARNING: These changes in the local configuration files of the TIBCO Spotfire installed client will be reverted after any TIBCO Spotfire analyst client update (like a hotfix update) so the change will need to get added each time.

1). Locate the Spotfire Forms module. Its name is “Spotfire DXP Forms_<version_number>”.

It is typically installed in
      C:\Program Files (x86)\TIBCO\Spotfire\<version>\Modules

It may also be located in
      C:\Users\<user_name>\AppData\Local\TIBCO\Spotfire\<version>\Modules

Note that the Modules folder is typically a hidden folder.

If you have multiple Spotfire DXP Forms_<version_number> folders, use the one with the highest version.

2). Create a backup copy of the "Spotfire.Dxp.Main.dll.config" file in the forms module.

3). Open the "Spotfire.Dxp.Main.dll.config" file in a text editor (such as Notepad) or in an XML editor.

4). Locate the following section:

<Spotfire.Dxp.Internal.Properties.Settings>
      <setting name="DisableWindowsErrorReporting" serializeAs="String">
        <value>False</value>
      </setting>
    </Spotfire.Dxp.Internal.Properties.Settings>

5). To increase the timeout from 10000 ms to 200000 ms, add these lines:

      <setting name="ManifestDownloadTimeoutMilliseconds" serializeAs="String">
                <value>200000</value>
            </setting>

Add them right after this line:

<Spotfire.Dxp.Internal.Properties.Settings>



Example:

 <!-- Support: added to increase Manifest download time -->
    <Spotfire.Dxp.Internal.Properties.Settings>
      <setting name="ManifestDownloadTimeoutMilliseconds" serializeAs="String">
                <value>200000</value>
            </setting>
        <setting name="DisableWindowsErrorReporting" serializeAs="String">
        <value>False</value>
      </setting>
    </Spotfire.Dxp.Internal.Properties.Settings>
   <!-- Support END -->

NOTE: Comments were added to the file, to note that this section has been manually changed.

Once this is done, re-launch your Spotfire client and re-submit the data function.

WARNING: These changes in the local configuration files of the TIBCO Spotfire installed client will be reverted after any TIBCO Spotfire analyst client update (like a hotfix update) so the change will need to get added each time.

 

Additional Information

Wiki: List of hotfixes for TIBCO Spotfire Statistics Services Wiki: List of hotfixes for TIBCO Spotfire® Clients (Analyst, Web Player (Consumer/Business Author) and Automation Services)