Defect resulting in MS Excel and Access files loaded in-process by default in versions 7.12 and 7.13

Defect resulting in MS Excel and Access files loaded in-process by default in versions 7.12 and 7.13

book

Article ID: KB0080133

calendar_today

Updated On:

Products Versions
Spotfire Web Player 7.12, 7.13

Description

By default, Access, Excel, and SAS files are loaded out-of-process, which means that a separate sub-process is launched to handle loading of the file. This is for fault tolerance reasons: if something goes wrong in the file loading, there is no impact on the main process. With LoadOutOfProcessExceptedFilePaths setting, you can specify excepted files or directories that, when accessed in the web clients, should be loaded in-process instead. To do so, you provide the full path to directories or files that should be loaded in-process, instead of out-of-process, when accessed in the web clients. Specify each file or directory in a separate <string> tag. Read more about this in the documentation.

In Spotfire versions 7.12 and 7.13, however, there is a defect resulting in all files of the mentioned type being loaded in-process with the default configuration.

More details
In Spotfire.Dxp.Worker.Host.exe.config file by default there is an empty string tag in LoadOutOfProcessExceptedFilePaths setting. The expected behavior is that services should ignore empty string and files of above mentioned type should be loaded out-of-process. But, in versions 7.12 and 7.13, the presence of the empty string results in files being imported in-process from all directories.

 

Issue/Introduction

By default, files of certain types should be loaded in a separate process, to increase fault tolerance of the Spotfire environment. But in Spotfire versions 7.12 and 7.13 there is a defect resulting in all files being loaded in-process when using the default configuration.

Environment

Spotfire web clients, versions 7.12 and 7.13

Resolution

Removing the empty string tag from the LoadOutOfProcessExceptedFilePaths section in the Spotfire.Dxp.Worker.Host.exe.config file results in files loaded out-of-process by default, as expected.

Here is how the section looks by default (resulting in all files being imported in-process from all directories in version 7.12 and 7.13 unless the empty <string/> tag is removed):
 
<setting name="LoadOutOfProcessExceptedFilePaths" serializeAs="Xml">
  <value>
    <ArrayOfString>
      <string/>
    </ArrayOfString>
  </value>
</setting>

Additional Information

Doc: Spotfire.Dxp.Worker.Host.exe.config file