It's all about the answers!

Ask a question

Recent upgrade of SQL causes some reports to no longer work due to New estimator


Melanie Dixon (1111) | asked Aug 04 '21, 12:01 p.m.

 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 commented Aug 04 '21, 12:31 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

Which ELM Tool version?

Be the first one to answer this question!


Register or to post your answer.