iacovellas

Strange behaviour with ST_INTERSECTS

Discussion created by iacovellas on Feb 5, 2014
Latest reply on Oct 14, 2014 by jeff.pace
Dear all,

I am experiencing a strange behaviour with ST_INTERSECTS.
The environment is as follow:
ArcSDE 10.1 SP 1 on Oracle 11.2.0.3 64-bit
Red Hat server

ST_LIBRARIES is correctly deployed and configured.

When I run the following query I got an error:

SQL*Plus: Release 11.2.0.3.0 Production on Thu Feb 6 09:51:59 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SELECT
    IBOW.SEAGRASS_RL13.OBJECTID,
    IBOW.SEAGRASS_RL13.RLSTATUS
FROM
    IBOW.SEAGRASS_RL13,
    IBOW.ITALYF2_REV1_AU
WHERE
    SDE.ST_INTERSECTS (IBOW.ITALYF2_REV1_AU.SHAPE, IBOW.SEAGRASS_RL13.SHAPE) = 1;

SELECT
*
ERROR at line 1:
ORA-28579: network error during callback from external procedure agent
ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 100
ORA-06512: at "SDE.ST_RELATION_OPERATORS", line 340



Running the query on a small subset of features works:

SELECT
    IBOW.SEAGRASS_RL13.OBJECTID,
    IBOW.SEAGRASS_RL13.RLSTATUS
FROM
    IBOW.SEAGRASS_RL13,
    IBOW.ITALYF2_REV1_AU
WHERE
    SDE.ST_INTERSECTS (IBOW.ITALYF2_REV1_AU.SHAPE, IBOW.SEAGRASS_RL13.SHAPE) = 1
    AND IBOW.SEAGRASS_RL13.OBJECTID IN (27);

  OBJECTID  RLSTATUS
------------------------------------------------------------------------------------------
        27      LC


My guess is that probably the external process run out of memory when pperforming the intersect on many features. Is there a way to check for the error in the external process?

Thanks in advance for any hint.

Kind Regards,

Stefano

Outcomes