The error occurred while verifying the spatial database connection (Oracle Spatial) graphical sources. This validation is donefrom the Geo Web Publisher Administration tool > Graphical Sources > Spatial Database by selecting the name of the spatial database connection, by mouse right clicking one can do ‘Check Sources’.
The error seen below seems to indicate a problem with the dimensions of the spatial graphical source.
Note that in general it is fitting when encountering problems publishing Oracle Spatial data to start by verifying the Oracle Spatial requirements for publishing, useful tips can be found in the Geo Web Publisher Help Document, specifically in the section: Tips for Verifying the Oracle Spatial Requirements.
The verification of the spatial metadata revealed that although there was a metadata record for the spatial table there was 2 X coordinates defined and this must be corrected. The SQL command “select * from user_sdo_geom_metadata where table_name='<tablename>';” can be executed from SQLPLUS as shown in the image.
Although with no evident certainty this could be related with the migration of data from Oracle 10g to an Oracle 11g, assuming thus the export/import of the data could have been the origin of the problem.
The metadata record must be set properly in the tables or views and. This can be achieved with the SQL command as exemplified next (where STREETLIGHTS is the table name and GEOMETRY is SDO_GEOMETRY column) where the metadata of the table is recreated.
DELETE FROM USER_SDO_GEOM_METADATAWHERE TABLE_NAME = 'STREETLIGHTS' AND COLUMN_NAME = 'GEOMETRY' ;
INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)VALUES ('STREETLIGHTS', 'GEOMETRY', MDSYS.SDO_DIM_ARRAY (MDSYS.SDO_DIM_ELEMENT('X', 713886.802849800, 715466.709941780, 0.000000050), MDSYS.SDO_DIM_ELEMENT('Y', 4908253.430391572, 4911002.398191481, 0.000000050) ), 82247);
It may be required to use the Refresh Schema button in the spatial graphical source. This button refreshes the Oracle schema cached by the Geo Web Publisher Server. This option is used if the tables published by Geo Web Publisher are modified after been added as graphical sources.