Error when rebuilding cube with comments in the cube query
While rebuilding a cube with comments in the cube query is throwing the below error of ‘Incorrect syntax’. Whereas my other cubes with comments in the query are getting rebuilt properly.
This type of error may occur with some JDBC drivers for SQL server (jTDS, Microsoft driver, etc.). Some drivers will have difficulty in parsing the query with comments. In such cases, it throws an error.
As a solution, it is advised to remove the comments from the query.