KB17282: 'Improper column reference in the search condition of a joined table' error message appears when running a report in MicroStrategy Developer or Web against a Teradata database

SYMPTOM:
The following error message appears when running a report in Strategy Desktop or Web 8.x against a Teradata database:
 
QueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. Improper column reference in the search condition of a joined table.
Error in Process method of Component: QueryEngineServer, Project XXXXXXX, Job 448244, Error Code= -2147212544.
CAUSE:
This issue occurs because the incorrect Structured Query Language (SQL)standard is used by the Strategy SQL Engine to generate the SQL.
 
ACTION:
Change the VLDB property Join Type to use 'SQL 92' or 'SQL 89 Inner join and SQL 92 outer join' (if using outer joins) instead of 'SQL 89' as shown below:
 

 
The Join Type VLDB property can be changed at the report level or at the project level. To change the Join Type at the Report Level follow the steps below:
 

1. Open in Edit mode or execute the report, go to the Data menu and select VLDB Properties.
2. Expand the Joins folder and select Join Type.
3. Uncheck default inherited value and choose 'Join 92' or 'SQL 89 Inner join and SQL 92 outer join' .
4. Save and Close on the VLDB Properties.
5. Save and Close the report.

To change the Join Type VLDB Property at the Database Instance Level used by the Project follow these steps:
 

1. Select the Project, give a right click and go to Project Configuration.
2. Expand the Database Instances section and select the General section.
3. Select the Database Instance you want to modify and click on VLDB Properties..
4. Expand the Joins folder and select Join Type.
5. Uncheck default inherited value and choose 'Join 92' or 'SQL 89 Inner join and SQL 92 outer join' .
6. Save and close on the VLDB Properties.
7. Click OK . If the setting has been modified in 3-tier mode, then the user would need to restart the Strategy Intelligence Server for the setting to take place.