I've a view defined in Oracle 10g which joins a spatial table with a
non-spatial attribute table. Both of these are owned by user X and
I've a datastore configured using the same user. When I add the
spatial table as a layer and view it with "Layer Preview" /
"OpenLayers", it works just fine. However when I add the view as a
layer, I get the following error in OpenLayers and no map
code="Internal Error "org.vfny.geoserver.wms.WmsException: Rendering
process failed
Rendering process failed
Exception rendering layer FeatureCollectionMapLayer[SUBNATIONAL2,
VISIBLE, UNSELECTED, style=StyleImpl[ name=point],
data=org.vfny.geoserver.global.
GeoServerFeatureSource@anonymised.com, query=Query
feature type: SUBNATIONAL2
filter: [Filter.INCLUDE AND Filter.INCLUDE]
[properties: ALL]]
java.io.IOException
null
ORA-29902: error in executing ODCIndexStart() routine
ORA-13208: internal error while evaluating [window SRID does not match
layer SRID] operator
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 333
And when I click within the map box (where the above error shows) I
get the following
java.lang.RuntimeException: java.io.IOException: Error occured
calculating count java.io.IOException: Error occured calculating count
Error occured calculating count 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 333
I've configured both layers using the same SRID 4326 and the view
does include the geometry column
--
Jeff Gerbracht
Lead Application Developer
Neotropical Birds, Breeding Bird Atlas, eBird
Cornell Lab of Ornithology
607-254-2117
Jeff Gerbracht ha scritto:
I've a view defined in Oracle 10g which joins a spatial table with a
non-spatial attribute table. Both of these are owned by user X and
I've a datastore configured using the same user. When I add the
spatial table as a layer and view it with "Layer Preview" /
"OpenLayers", it works just fine. However when I add the view as a
layer, I get the following error in OpenLayers and no map
code="Internal Error "org.vfny.geoserver.wms.WmsException: Rendering
process failed
Rendering process failed
Exception rendering layer FeatureCollectionMapLayer[SUBNATIONAL2,
VISIBLE, UNSELECTED, style=StyleImpl[ name=point],
data=org.vfny.geoserver.global.
GeoServerFeatureSource@anonymised.com, query=Query
feature type: SUBNATIONAL2
filter: [Filter.INCLUDE AND Filter.INCLUDE]
[properties: ALL]]
java.io.IOException
null
ORA-29902: error in executing ODCIndexStart() routine
ORA-13208: internal error while evaluating [window SRID does not match
layer SRID] operator
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 333
And when I click within the map box (where the above error shows) I
get the following
java.lang.RuntimeException: java.io.IOException: Error occured
calculating count java.io.IOException: Error occured calculating count
Error occured calculating count 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 333
I've configured both layers using the same SRID 4326 and the view
does include the geometry column
Usually this happens because GeoServer could not figure out the
native SRID of the column. This is done by inspecting the
MDSYS.USER_SDO_GEOM_METADATA or the MDSYS.ALL_SDO_GEOM_METADATA
views.
Did you register the view inside those metadata views?
Cheers
Andrea
--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.
Thanks that was it
On Wed, Sep 2, 2009 at 8:52 AM, Andrea Aime<aaime@anonymised.com> wrote:
Jeff Gerbracht ha scritto:
I've a view defined in Oracle 10g which joins a spatial table with a
non-spatial attribute table. Both of these are owned by user X and
I've a datastore configured using the same user. When I add the
spatial table as a layer and view it with "Layer Preview" /
"OpenLayers", it works just fine. However when I add the view as a
layer, I get the following error in OpenLayers and no map
code="Internal Error "org.vfny.geoserver.wms.WmsException: Rendering
process failed
Rendering process failed
Exception rendering layer FeatureCollectionMapLayer[SUBNATIONAL2,
VISIBLE, UNSELECTED, style=StyleImpl[ name=point],
data=org.vfny.geoserver.global.
GeoServerFeatureSource@anonymised.com, query=Query
feature type: SUBNATIONAL2
filter: [Filter.INCLUDE AND Filter.INCLUDE]
[properties: ALL]]
java.io.IOException
null
ORA-29902: error in executing ODCIndexStart() routine
ORA-13208: internal error while evaluating [window SRID does not match
layer SRID] operator
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 333
And when I click within the map box (where the above error shows) I
get the following
java.lang.RuntimeException: java.io.IOException: Error occured
calculating count java.io.IOException: Error occured calculating count
Error occured calculating count 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 333
I've configured both layers using the same SRID 4326 and the view
does include the geometry column
Usually this happens because GeoServer could not figure out the
native SRID of the column. This is done by inspecting the
MDSYS.USER_SDO_GEOM_METADATA or the MDSYS.ALL_SDO_GEOM_METADATA
views.
Did you register the view inside those metadata views?
Cheers
Andrea
--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.
--
Jeff Gerbracht
Lead Application Developer
Neotropical Birds, Breeding Bird Atlas, eBird
Cornell Lab of Ornithology
607-254-2117