Kinetic Export to Excel Error

[Olga (Olga Klimova)]

This means SQL is generated incorrectly.
You need to track down what is wrong. If it is BAQ, then one of the options - dump all BAQ SQL statements into log, like described here

Extract BAQ actual SQL queries

I fear I already know the answer here, but here goes I have a gigantic BAQ, consisting of 1 CTE, and 22 subqueries. The BAQ was constructed from working SQL code (this is a migration of an old Crystal Report that used an ODBC connection for a subreport). I have completed the conversion from SQL to BAQ, the SQL code shown in the BAQ query window looks ok, but when trying it out, I get those nonsensical errors: Incorrect syntax near 'm'. Incorrect syntax near 'Sub…