Select to view content in your preferred language

Strange behaviour with ST_INTERSECTS

5890
11
02-05-2014 11:02 PM
StefanoIacovella
Occasional Contributor
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
0 Kudos
11 Replies
StefanoIacovella
Occasional Contributor
Hi Stefano,

Are you using 11.2.0.3 or 12.2.0.3 (is this released yet)? From what I can tell it is fixed in a patch set on top of 11.2.0.2 and in 12.1.0.1. I suggest checking the info in this KB article and then following up with Oracle if you get an hs_core file as described:

KB38823 - Bug: Spatial Type for Oracle: st_intersects can fail with error ORA-028579

Otherwise yes, please open an incident with your local distributor.

Thanks.


Sorry, it was a typo, I mean 11.2.0.3.
I will check if the behaviour is like the one described in the Oracle bug.

Thanks for your support

Stefano
0 Kudos
JeffPace
MVP Alum

we are on 11.2.0.3 and experiencing this issue after the 10.2.2 upgrade.  Any solutions?

0 Kudos