Error while executing Information Link with Distinct clause
book
Article ID: KB0075037
calendar_today
Updated On:
Products
Versions
Spotfire Analyst
All Versions
Description
The following error is returned while executing the Information Link with distinct clause. ********************************* Unable to import data. at Spotfire Dxp Foms Data Import.TableContext DataFlowBuilderContext AddData Tables(DataManager dataManager, Fom baseFom, List'1& addedTables, String& errorMessage) InfomationModelException at Spotfire.Dxp Data An Intemal Error has occurred. com.spotfire.ws.dat.OperatorException: unexpected exception (HRESULT: 80131500) ********************************
This is caused as the SQL is modified manually and the number of columns returned should not be altered.
From the manual:
Note: The modified SQL is not validated before execution. For this reason, you should not:
alter the name of a column (the AS-part of SELECT xxx AS yyy)
alter the number of columns returned
alter the datatype of columns returned
alter the order of columns returned
remove <temporary_result_#> from the FROM-clause in information links that go against multiple data sources
remove the trailing WHERE <conditions>, as it will be replaced by any conditions applied at runtime
Resolution
Uncheck the Retrieve column for the columns that will not be returned from the Information Link editor. See the below screenshot:
Issue/Introduction
Error while executing Information Link with Distinct clause