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

Date Posted: 2019-09-05
Product: TIBCO Spotfire®

Problem:

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

Solution:

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. 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, use the following instructions:

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:


    <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>
   

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.
Wiki: List of hotfixes for TIBCO Spotfire Statistics Services

https://community.tibco.com/wiki/list-hotfixes-tibco-spotfire-statistics-services

Related articles