BUG-000141972 for No Product Found

Número de ID del error	BUG-000141972
Enviado	August 5, 2021
Última modificación	June 25, 2025
Relacionado con	No Product Found
Versión encontrada	N/A
Sistema operativo	Windows OS
Versión de sistema operativo	2019 64 Bit
Estado	Will Not Be Addressed

Información adicional

We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support.

Solución alternativa

Reversing the arguments of the function 'st_intersects' allows the user to get all buildings. However, no spatial index is used and the execution takes much longer, 45 seconds as opposed to 1 second.

Select count (*)

From krb.w_bauw_stm punkte

Where

sde.st_intersects(sde.st_geomfromwkb((

Select

sde.st_asbinary(sde.st_aggr_union(bezirke.geom))

From

krb.fd_glk_verw_fe_stm_w5 bezirke

Where

bezirke.pkey IN(40000235724048, 40000235724042)), 25832), punkte.geom) = 1;

Result: COUNT (*) 1147