SRS error when accessing Oracle spatial based WFS layer from GWP

My guess is that the WFS client isn’t reading the correct coordinate extensions of the layer.

The error message may point to an issue with the projection not being specified or recognized. In the Oracle Spatial graphical source in the Geo Web Publisher Administration, can you read the coordinate system directly from the spatial database when you click ‘Read’, or did you set it manually, or is it set to none?

Can you verify the SRID specified in your spatial metadata (select * from all_sdo_geom_metadata).

Regards
Carlos

Thanks for the response Carlos. Initially we had the SRID set to null (which it is in production where it works). We did update the SRID to 2958, however, we get the same error.

Thanks for the update. So in fact it only works with EPSG:2958 when SRID is set null. I will try this at my end.
Regards
Carlos

That is only for the projection confirmation in the administrator. The WFS layer is still throwing the projection error.

Can you calculate the extent from one of the tables using a statement like
select SDO_AGGR_MBR(a.<geometry_column_name>) from <tablename> a;
Then compare it with the metadata for the same table in USER_SDO_GEO_METADATA.

Hi Carlos,
For addresses, I get the following in USER_SDO_GEOM_METADATA

MDSYS.SDO_DIM_ELEMENT('X',594082.794000022,621521.106000082,5E-8)
MDSYS.SDO_DIM_ELEMENT('Y',4812575.36899907,4846301.14099907,5E-8)

and the query returns:
MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(596369.320000027,4815385.84999907,619234.580000077,4843490.65999907))

The query shows that the GEOMETRY column (SDO_GEOMETRY) does not include the SRID as it is set to NULL, the second value.
MDSYS.SDO_GEOMETRY(2003,NULL,...
This could be the problem

The query shows that the GEOMETRY column (SDO_GEOMETRY) does not include the SRID as it is set to NULL, the second value.
MDSYS.SDO_GEOMETRY(2003,NULL,...
This could be the problem

Do you have any recommendations to how we would set that reference? If I update the table with an SRID, we get the projection issues in the administrator I wrote about earlier and the log still shows the SRS error.

Hi Simon,

1. I modified the data in my spatial table rows setting the SRID to null. But I maintained in the metadata in USER_SDO_GEOM_METADATA the SRID.

2. I created the Oracle Spatial graphical source setting with the coordinate system ; Then created the WFS Service and added the feature to the Service.

3. From a WFS client I connected to the WFS Service but cannot display the data. I verified the logs and see "An error occurred : The GML Writer requires a Spatial Reference System set on the features to write proper GML.".

As this is the same exact message I think this replicates the same issue and validates what I suspected, the spatial data in the rows must include also the SRID in order to work.

4. To update the spatial table rows in order to modify the SRID from null to an SRID you can execute a query similar to the example below. First the spatial index must be dropped then the SRID updated, then the spatial index recreated. In my case my data is using SRID 82247.

-------
drop index BLOCK_IDX;
update block a set a.geometry.sdo_srid=82247;
CREATE INDEX "EAST_SPATIAL"."BLOCK_IDX" ON "EAST_SPATIAL"."BLOCK" ("GEOMETRY")
INDEXTYPE IS "MDSYS"."SPATIAL_INDEX" PARAMETERS ('layer_gtype=multipolygon');
------

5. After executing this SQL I tested in the WFS client and this turn it worked correctly, the data is queried and retrieved and the info tool works correctly.

I hope this helps
Regards
Carlos

Updating the projection SRID in both is working. Thanks for the help.