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

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

book

Article ID: KB0080032

calendar_today

Updated On:

Products Versions
Spotfire Analyst All Versions

Description

Description:
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'. 


Symptoms:
When trying to open an Excel file you get an error similar to the one below:

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()

Cause:
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 the error described earlier. This is due to insufficient user rights on the Citrix system.

Issue/Introduction

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

Resolution

Allow Spotfire to launch the temporary processes on the Citrix system.