Spotfire client: Unable to open Excel files using a Citrix based Spotfire client.

When running the Spotfire client using a Citrix system and opening data from an Excel file the following error is seen: 'Failed to execute data source query'. 

When opening Excel files, temporary processes are opened with names similar to 'SPOTFIRE.TMP822C.EXE' (the 822C part is random). 

If the Citrix system is blocking Spotfire from launching these processes, you will get an error similar to the below.

This is due to insufficient user rights on the Citrix system. 

In order to make this work, you need to allow Spotfire to launch the temporary processes on the Citrix system.

USERNAME is not authorized to execute SPOTFIRE.TMP822C.EXE

Error message: Could not open data source.

TargetInvocationException at Spotfire.Dxp.Framework:

Exception has been thrown by the target of an invocation. (HRESULT: 80131604)

Stack Trace:

   at Spotfire.Dxp.Framework.ApplicationModel.ProgressService.ExecuteWithProgress(String title, String description, ProgressOperation operation)

   at Spotfire.Dxp.Application.RichAnalysisApplication.Open(String filePath, DocumentOpenSettings documentOpenSettings)

   at Spotfire.Dxp.Forms.Application.FileUserActions.LoadFileCallback(LoadCallbackParameters parameters)

   at Spotfire.Dxp.Forms.Framework.Utilities.LoadFileHelper.LoadFile(LoadCallback callback, LoadCallbackParameters parameters, Form owningForm)

ImportException at Spotfire.Dxp.Data:

Failed to execute data source query. (HRESULT: 80131500)

Stack Trace:

   at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptModels>d__2.MoveNext()

   at Spotfire.Dxp.Data.DataSource.Connect(IServiceProvider serviceProvider, DataSourcePromptMode promptMode, Boolean

updateInternalState)

   at Spotfire.Dxp.Application.AnalysisApplication.<OpenDocumentFile>d__f.MoveNext()

   at Spotfire.Dxp.Forms.Application.FormsApplicationThread.<>c__DisplayClass5.<ExecutePromptingOperation>b__4()

   at Spotfire.Dxp.Forms.Application.FormsProgressService.ProgressThread.DoOperationLoop()

InvalidOperationException at Spotfire.Dxp.Data:

Operation is not valid due to the current state of the object. (HRESULT: 80131509)

Stack Trace:

   at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.Init()

   at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.<GetPromptModelsCore>d__24.MoveNext()

   at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptModels>d__2.MoveNext()