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.