Denodo Bad Connection: Tableau could not connect to the data source. Error Code: FAB9A2C5

Issue

Upon editing a workbook with Denodo data source, the following error may be displayed:

An error occurred while communicating with the Denodo data source 'calcs (xxxx.xxxx) (xxxx)'
Bad Connection: Tableau could not connect to the data source.
Error Code: FAB9A2C5
ERROR: Syntax error: Exception parsing query near 'IN';

Environment

Tableau Desktop older than 2020.4.8, 2021.1.5, 2021.2.2 and 2021.3.1
Tableau Server older than 2020.4.8, 2021.1.5, 2021.2.2 and 2021.3.1
Denodo server older than 7.0u20210818

Resolution

Upgrade the Denodo server to 7.0u20210818 or later will solve both problems.
Upgrade Tableau to 2020.4.8, 2021.1.5, 2021.2.2 or 2021.3.1 or later.

Additional Information

The Denodo server has failed to handle two types of queries. One problem is that Denodo couldn't handle queries where the IN operator was used in a boolean expression in the SELECT clause. The other problem is that Denodo couldn't handle queries where there was a complex boolean expression used in the SELECT clause.