"Get message from subprocess timed out" error is seen when opening Excel file in Spotfire Analyst

Product:TIBCO Spotfire Analyst
Versions:12.0 and higher

Summary:
When attempting to open an Excel file in the Spotfire client, users are confronted with the error message "Get message from subprocess timed out."

Details:
When trying to open Excel files in the TIBCO Spotfire installed client, you get the following error message:

Error message: Could not read the selected data. AggregateException at : One or more errors occurred. (HRESULT: 80131500) 
Stack Trace: Aggregated exception: ImportException at Spotfire.Dxp.Data: Failed to execute data source query for data source "OTDOnTimeLateDetailsAllSites". (HRESULT: 80131500) 
Stack Trace: at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptModels>d__47.MoveNext() at Spotfire.Dxp.Data.Access.AddData.DataSourceAddDataFlow.ConfigureDataSourcesStep.<GetPromptRequests>d__7.MoveNext() at Spotfire.Dxp.Internal.EnumerableExtensions.<EnumerateWithExceptionHandling>d__6`2.MoveNext() ImportException at Spotfire.Dxp.Data: Get message from subprocess timed out. (HRESULT: 80131500) Stack Trace: at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.<GetMessage>b__17_0() at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.<>c__DisplayClass21_0`1.<TryExecute>b__0() at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.TryExecute(Action f) at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.TryExecute[T](Func`1 f) at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.<GetPromptModelsCore>d__14.MoveNext() at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptModels>d__47.MoveNext()

Resolution:
To resolve this error, follow the below steps to increase the timeout in the Spotfire.Dxp.Main.dll.config file to be able to import the data from Excel:

1. Navigate to the client install folder, typically located at:
   - For local admins: C:\Program Files (x86)\TIBCO\Spotfire\xxx\Modules\Spotfire DXP Forms_xx.xx.xx.xx
   - For non-admin users: C:\Users\USERID\AppData\Local\TIBCO\Spotfire (The modules or AppData folder may be hidden, enable hidden folders if necessary).
   Note: You may find many folders with different versions, please select the latest version

2. Locate the Spotfire.Dxp.Main.dll.config file (.....\Modules\Spotfire DXP Forms_XX.XX.XXXX.XXXX\Spotfire.Dxp.Main.dll.config) 
   Note: Take a backup of the file and use Notepad or Notepad++ to edit it.

3. In the <applicationSettings> section, add the following <Spotfire.Dxp.Data.Properties.Settings> setting:

<applicationSettings>
      ...
      <Spotfire.Dxp.Data.Properties.Settings>
         ...
         <setting name="DataImport_LoadOutOfProcessTimeoutMinutes" serializeAs="String">
            <value>X</value>
         </setting>
      </Spotfire.Dxp.Data.Properties.Settings>
      ...
   </applicationSettings>

   where X is the timeout value in minutes. Consider increasing it, perhaps to 15 minutes.

4. Ensure that Spotfire.Dxp.Data.Properties.Settings is defined in <applicationSettings> by adding it to the

<configSections>:
<configSections>
      ...
      <sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
         ...
         <section name="Spotfire.Dxp.Data.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false"/>
         ...
      </sectionGroup>
      ...
   </configSections>

Note: As this is a configuration file specific to each version, you will need to reapply the changes for every client update.