HANA SDA SQL execution plan esx search

[shansenanalytics]

Hi,

we are facing the issue that our custom cds-view reporting is not working. The query returns with an allocation error.

The confusing situation is, that this is only in our productive system and not in our quality environment. (We are using the same dataset, the S4Q system is a copy from the productive environment S4P)

https://me.sap.com/notes/2967014/E

If we are using the following hint (WITH HINT (NO_USE_ESX_PLAN)) in our sql statement, the query works fine in S4P.

Can anyone help us, where we can fix or adjust this handing in general ?

Left side is the quality system and the left side is the productive system with slow performance and memory allocation dump.

Thanks a lo

regards

Simon

[simon25]

Hi Simon,

The issue is with the ESX engine being included in the execution plan of the query on S4P. The sql optimizer may have cached the execution plan to be re-used for each execution to include this in the sql plan cache on S4P but not on S4Q.

You can open a case with HAN-DB-PERF to investigate further.

Kind Regards
Simon

[shansenanalytics]

Thanks a lot. We are still in contact with the sap support.