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=" xmlns:xsi=" xsi:schemaLocation=" <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=" xmlns:xsi=" xsi:schemaLocation=" <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?