MicroStrategy ONE

SQL/MDX String Length

When you generate a report using Developer, you might see the following error message:

Error: SQL Generation Complete[]QueryEngine encountered error: The generated SQL/MDX string (xxxxx bytes) is longer than the limitation of the corresponding connector (yyyyy bytes).[]Error in Process method of Component: QueryEngineServer, Project ###, Job ###, Error Code=-2147212544

This error message is displayed when the SQL string size exceeds the maximum value set for the SQL/MDX string.

You can increase the maximum value for the SQL/MDX field in the Project Configuration dialog box as follows:

  1. In Developer, right-click the project and select Project Configuration.
  2. In the Project Configuration Editor, expand the Database instances category and select SQL Data Warehouses.
  3. Click VLDB Properties.
  4. Expand Governing and select the Maximum SQL/MDX Size VLDB setting.
  5. Clear the Use default inherited value - (Default Settings) check box.
  6. Increase the Maximum SQL/MDX Size value as required. You can enter any number between 1 and 999999999. If you enter 0 or -1, the Maximum SQL/MDX Size is set to the default value of 65536. This default size may be different for different databases. It depends on the database instance that you select.

    You should enter a value that a certified ODBC driver can handle; a large value can cause the report to fail in the ODBC driver. This is dependent on the database type you are using.

If increasing the value of this VLDB property does not resolve the issue, try simplifying the report. You can simplify a report by removing attributes, metrics, and filters. Importing large sets of elements for filters can often cause large SQL/MDX size.