Exporting large data sets from Web Player results in partial export or garbled text in the exported file

Exporting large data sets from Web Player results in partial export or garbled text in the exported file

When exporting huge data sets from the TIBCO Spotfire Web Player, only a partial export is done and the exported file may contain garbled characters at the end. Follow the steps below.

1). Open a command-line interface and export the service configuration from Spotfire Server by using the export-service-config command. Specify the Web Player capability and the deployment area.  

Example :export-service-config --capability=WEB_PLAYER --deployment-area=Production
 
The following configuration files are exported. By default, these files are located in the <TSS install dir>\tomcat\bin\config\root directory.

•     Spotfire.Dxp.Worker.Core.config
•     Spotfire.Dxp.Worker.Host.exe.config
•     Spotfire.Dxp.Worker.Web.config

2). Make the following changes to Spotfire.Dxp.Worker.Web.config in section configuration/spotfire.dxp.web/performance/application .

From Spotfire.Dxp.Worker.Web.config,

Change: requestTimeoutSeconds="300" to requestTimeoutSeconds="3600"

and add:

connectionIdleTimeoutSeconds="1200"
 
After this, change the section which should look like the following.

<application checkUserSessionTimeoutIntervalSeconds="120"
                   userSessionTimeout="00:20:00"
                   maxConcurrentWebServiceCallsPerCore="16"
                   maxReceivedMessageSizeMb="1024"
                   maxReaderQuotasSizeKb="256"
                   requestTimeoutSeconds="3600"
                   connectionIdleTimeoutSeconds="1200"
/>

Save the changes to file.

3). In the command-line interface, import the configuration file back into the Spotfire Server and name the configuration by using the import-service-config command.

 Example: import-service-config --config-name=WebPlayerConfiguration

4). In the command-line interface, assign the created Spotfire Web Player configuration to the Spotfire Server to make it possible to use for the service:

 Example: set-service-config --service-id=value –config-name=WebPlayerConfiguration Doc: Manually editing the service configuration files

• https://docs.tibco.com/pub/spotfire_server/7.11.1/doc/html/TIB_sfire_server_tsas_admin_help/GUID-958A3AB5-7243-4837-9AEA-78AA274A6F7E.html