Error when rebuilding cube with comments in the cube query

Modified on Mon, 13 Jun, 2022 at 8:01 PM

Error when rebuilding cube with comments in the cube query

Issue:

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.




Solution


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.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article