Geoserver with oracle Geometry data
Geoserver with oracle Geometry data
(OP)
Hi,
I've created Geoserver Layers using Oracle Geometry Views. The geometry column in the table has been indexed and inserted an entry into USER_SDO_GEOM_METADATA for 27700 SRID reference. while saving the geometry 27700 is added into the geometry details. see the matching coordinates on the screenshot below.
But when I open geoserver layers I'm getting the error says "window SRID does not match layer SRID".
<?xml version="1.0" ?>
<ServiceExceptionReport
version="1.2.0"
xmlns="http://www.opengis.net/ogc"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.opengis.net/ogc http://schemas.opengis.net/wfs/1.0.0/OGC-exception...">
<ServiceException>
java.lang.RuntimeException: java.io.IOException
java.io.IOExceptionORA-29902: error in executing ODCIIndexStart() routine
ORA-13208: internal error while evaluating [window SRID does not match layer SRID] operator
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 585
ORA-29902: error in executing ODCIIndexStart() routine
ORA-13208: internal error while evaluating [window SRID does not match layer SRID] operator
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 585
</ServiceException></ServiceExceptionReport>
Can someone please help me this issue?
I've created Geoserver Layers using Oracle Geometry Views. The geometry column in the table has been indexed and inserted an entry into USER_SDO_GEOM_METADATA for 27700 SRID reference. while saving the geometry 27700 is added into the geometry details. see the matching coordinates on the screenshot below.
But when I open geoserver layers I'm getting the error says "window SRID does not match layer SRID".
<?xml version="1.0" ?>
<ServiceExceptionReport
version="1.2.0"
xmlns="http://www.opengis.net/ogc"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.opengis.net/ogc http://schemas.opengis.net/wfs/1.0.0/OGC-exception...">
<ServiceException>
java.lang.RuntimeException: java.io.IOException
java.io.IOExceptionORA-29902: error in executing ODCIIndexStart() routine
ORA-13208: internal error while evaluating [window SRID does not match layer SRID] operator
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 585
ORA-29902: error in executing ODCIIndexStart() routine
ORA-13208: internal error while evaluating [window SRID does not match layer SRID] operator
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 585
</ServiceException></ServiceExceptionReport>
Can someone please help me this issue?