Recent upgrade of SQL causes some reports to no longer work due to New estimator
Upgrade from SQL 2012 TO SQL 2019
Have 4 very complex reports that are failing:
Error: The query processor ran out of internal resources and could not create query plan.
I would like to put into my advanced SQL the following to force the use of the 2012 CE but it does not seems to be reading correctly in JRS.
OPTION (USE HINT (‘FORCE_LEGACY_CARDINALITY_ESTIMATION’)
this will give us time to rebuild the report and move forward.
Has anyone been able to use this type of SQL command in JRS?
Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Aug 04 '21, 12:31 p.m.Which ELM Tool version?