Spotfire Client: Error while running modified SQL for an on-demand data table: "Could not load on-demand data for table XXX" "Failed to execute data source query."

Error while running on-demand table: "Could not load on-demand data for table XXX" "Failed to execute data source query" can be due to various reasons. 

When on-demand fails, the Spotfire Server sql.log file is updated with the wrong query, but in this case, there is nothing updated in the sql.log file, because the query is not getting formed. 

The following error appears in the Spotfire Server server.log file, instead:

The On-Demand query fails because the runtime query is not being formed, due to a missing <conditions> tag in the SQL query for the on-demand table's information link.

Add the <conditions> tag in the information link SQL as shown below.

WHERE
   <conditions>
or

WHERE
column1 = column2
and
  <conditions>

Note: The modified SQL is not validated before execution. For this reason, you should not do any of the following:
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>, because it will be replaced by any conditions applied at runtime