Unable to load catalog item. Incorrect syntax near ')'

Attempting to create a report that reports from the OLAP SQL Data source using a <createSQL> without providing the "<!<CDATA]" because the stored procedure is defined in with martkey on the a sepreate SQL function.  The <createSQL is still needed to setup security. If you use the MartKey= attribute on the <ReportSpec  you received the the error:
"Unable to load catalog item. Incorrect syntax near ')'."

Attempting to load without the MartKey= attribute will produce the follow error as well:
"Unable to load catalog item. Error laod spec "{NAME.EN_US}". Can not find the object {object name}, because it does not exist or you do not have permission."

Download and install the latest version and patch, if applicable. 

Environment

 2.94.1524
 4.0.131

Was this article helpful?