When trying to open Excel files in the 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()

All

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.

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