EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB15522: In MicroStrategy Engine, "[0x80042300] QueryEngine encountered error: The generated SQL/MDX string ( xxx bytes) is longer than the limitation of the corresponding connector ( 65536 bytes)" error occurs when executing a Freeform SQL report


Community Admin

• Strategy


SYMPTOM:
In Strategy Engine, when users try to run any Freeform SQL report with SQL statement over 65536 bytes, the following error occurs:
 
QueryEngine encountered error: The generated SQL/MDX string ( xxx bytes) is longer than the limitation of the corresponding connector ( 65536 bytes)
 
CAUSE:
By default, the maximum SQL/MDX size is 65536 bytes. If any Freeform SQL reports exceed the limit, the report execution will be terminated and users will receive the error described above.
 
ACTION:
To resolve the issue, users can increase the size of 'Maximum SQL/MDX Size' value by foilowing the steps below:
 

  • Go to VLDB Properties.
  • Under the Governing folder, select 'Maximum SQL/MDX Size'.
  • Uncheck 'Use default inherited value - (Default Settings).
  • Increase the value of 'Maximum SQL/MDX Size', as shown below:

Comment

0 comments

Details

Knowledge Article

Published:

July 17, 2017

Last Updated:

July 17, 2017