Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Geoserver with oracle Geometry data

Status
Not open for further replies.

BJoy

Programmer
Feb 15, 2019
4
GB
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 &quot;MDSYS.SDO_INDEX_METHOD_10I&quot;, 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 &quot;MDSYS.SDO_INDEX_METHOD_10I&quot;, line 585
</ServiceException></ServiceExceptionReport>

Can someone please help me this issue?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top