Error while executing Information Link with Distinct clause

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

Issue/Introduction

Error while executing Information Link with Distinct clause

Resolution

Uncheck the Retrieve column for the columns that will not be returned from the Information Link editor. See the below screenshot:

Powered by Wolken Software