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?

 

Thanks,

Tommaso

Outcomes