Error while executing Information Link with Distinct clause

Error while executing Information Link with Distinct clause

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

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