AnsweredAssumed Answered

SDE callback error on st_intersects AND st_buffer

Question asked by n.braccini on Jul 1, 2016
Latest reply on Jul 4, 2016 by n.braccini

Hi everybody.


I am having a problem with the following query run on Oracle 11g with SDE 10.1:


SELECT mg.codice

  FROM mg_table mg,


     SELECT ct.shape

     FROM ct_table ct

     WHERE ct.strno = 'xxx' AND ct.anno = 2015

  ) c

  WHERE SDE.st_intersects(mg.shape, SDE.st_buffer(c.shape, 30)) = 0


produces the following generic exception:


ORA-28579: network error during callback from external procedure agent:

ORA-06512: at 'SDE.ST_GEOMETRY_SHAPELIB_PKG', line 325

ORA-06512: at 'SDE.ST_GEOMETRY_OPERATORS', line 1331


I tried to reproduce the error on a different server with an identical database but with SDE 10.2 installed and the exception never occurs.


Does SDE 10.1 version include a different implementation of st_buffer or st_intersects respect to 10.2 or 10.3 version? Upgrading the first server to 10.3 could solve this kind of problems?