Error message: The file '/MyFolder/MyFile' cannot be opened. It may be damaged or in an unknown format.
 
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.ExecuteWithProgressCancelable(String title, String description, ProgressOperation operation, Boolean showCancelButton)
   at Spotfire.Dxp.Forms.WebView.FormsAddDataController.OpenNewDocumentWithProgress(String title, String description, String fileName, ProgressOperation operation)
 
InvalidOperationException at Spotfire.Dxp.Framework:
The current thread does not have an open read transaction. (HRESULT: 80131509)
 
Stack Trace:
   at Spotfire.Dxp.Framework.DocumentModel.ThreadTransactionInfo.ValidateTransactionIsOpen()
   at Spotfire.Dxp.Framework.Commands.CommandHistory.SetIdleState()
   at Spotfire.Dxp.Framework.Commands.CommandHistory.RollbackOutermostTransaction(Exception exception, Object busyProof)
   at Spotfire.Dxp.Framework.DocumentModel.TransactionHandle.Dispose(Boolean disposing)
   at Spotfire.Dxp.Framework.Commands.CommandHistory.OutermostTransactionHandle.Dispose(Boolean disposing)
   at Spotfire.Dxp.Application.AnalysisApplication.<OpenPartiallyOpenedDocument>d__90.System.IDisposable.Dispose()
   at Spotfire.Dxp.Application.AnalysisApplication.ConsumeDataLoadPromptRequests(IEnumerable`1 prompts)
   at Spotfire.Dxp.Application.AnalysisApplication.OpenFromLibraryCore(Guid entryId, DocumentOpenSettings settings)
   at Spotfire.Dxp.Application.AnalysisApplication.Open(LibraryItem libraryItem, DocumentOpenSettings settings)
   at Spotfire.Dxp.Forms.Application.FormsProgressService.ProgressThread.DoOperationLoop()

Error message: The process reading data unexpectedly stopped with exit code -1073740791.
 
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 "MyData". (HRESULT: 80131500)
 
Stack Trace:
at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptModels>d__37.MoveNext()
at Spotfire.Dxp.Data.Access.AddData.DataSourceAddDataFlow.ConfigureDataSourcesStep.<GetPromptRequests>d__7.MoveNext()
at Spotfire.Dxp.Data.Access.AddData.DataSourceAddDataFlow.ConfigureDataSourcesStep.<EnumerateModels>d__6.MoveNext()
 
ImportException at Spotfire.Dxp.Data:
The process reading data has terminated unexpectedly with exit code -1073740791 (HRESULT: 80131500)
 
Stack Trace:
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__13.MoveNext()
at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptModels>d__37.MoveNext()

• Loading a .dxp file with the linked .xlsb file works without issues.
• Opening the .xlsb file into any new Spotfire analysis works without issues.

Note: This approach may interfere with the existing Office installations so ensure you validate with your IT team first.

Installation instructions:

• Download the AccessDatabaseEngine_X64.exe from https://www.microsoft.com/en-us/download/details.aspx?id=54920
• Open a PowerShell terminal with admin priviledges
• Navigate to the folder where the AccessDatabaseEngine_X64.exe file is located
• To install the OLEDB driver, run the command: .\AccessDatabaseEngine_X64.exe /quiet

Note: This is required in order to install this version of the 64-bit redistributable alongside a 32-bit installation of Office 2016


Option 2) Install "Microsoft Access Database Engine 2010 Redistributable" (64 bit):

Results:

• Loading a .dxp file with the linked .xlsb file works without issues.
• When opening the .xlsb file in a empty Spotfire analysis we got the "External table is not in the expected format." error message from the driver. However, this can be ignored this by closing the dialog and pressing OK in the summary view.

Installation instructions:

• Download the AccessDatabaseEngine_X64.exe from https://www.microsoft.com/en-us/download/details.aspx?id=13255
• Double click the AccessDatabaseEngine_X64.exe file to install the OLEDB driver.

Option 3) Importing data in-process
By default, Access, Excel, and SAS files are loaded out-of-process by Spotfire, which means that a separate sub-process is launched to handle loading of the file. You can check the following article for more information on the in-process/out-of-process concept:

• KB: How to access 32-bit data files with 64-bit Spotfire on a 64-bit operating system.

• KB: How to turn off out-of-process operations in a Spotfire client.

Note: This requires that a 64-bit OLEDB driver is installed.


Option 4) Use another file format

• Open the .xlsb file in Microsoft Excel and save as an .xlsm file instead.
• Update your TIBCO Spotfire analysis files to use the .xlsm file instead.

• https://support.tibco.com/s/article/Tibco-KnowledgeArticle-Article-43035

• https://support.tibco.com/s/article/Tibco-KnowledgeArticle-Article-42485