I have an interesting problem. I was trying to set application in MapViewer which would include geometry over google tiles. I created a new table with county geom in srid 3785 by transforming a existing layer to that srid. I verifyied the srid in the geometry, and updated the user_sdo_geom_metadata to reflect the new table/geometry/
I create a theme using mapbuilder, and it display fine within application. I went ahead and created a short javascript application using the example in the demo tutorial. When running, I could the google maps to display, but not county geometry. I looked at the log on the server and it provided the following error messages:
Aug 23, 2013 2:22:19 PM oracle.sdovis.CacheMgr2 createGeomGroup
INFO: Creating/replacing a geometry cache group: sdovis_subreg_wycare_v_jdbc:oracle:thin:@itis-db3.com:1521:orcl1 : TBL_IXN_COUNTIES_3785_GEOMETRY_PDT_GEOM.
Aug 23, 2013 2:22:19 PM oracle.sdovis.SRSCache get
WARNING: Cannot find SRS definition for srid 3857.
Aug 23, 2013 2:22:20 PM oracle.sdovis.CacheMgr2 createGeomGroup
INFO: Creating/replacing a geometry cache group: sdovis_subreg_wycare_v_jdbc:oracle:thin:@itis-db3.com:1521:orcl1 : TBL_IXN_COUNTIES_3785_GEOMETRY_3857_PDT_GEOM.
Aug 23, 2013 2:22:20 PM oracle.sdovis.theme.PredGeomThemeProducer loadFeaturesInAdjustedMBR
INFO: [ IXN_GOOGLE_COUNTIES_3785 ] sql exec time: -1377292940032ms, total time loading 0 features: 123ms.
Aug 23, 2013 2:22:20 PM oracle.sdovis.theme.PredGeomThemeProducer loadFeaturesInWindow
WARNING: ORA-13199: SRID does not exist.
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.SDO_CS", line 5264
ORA-06512: at "MDSYS.SDO_CS", line 3034
I went back an attempted to run the demo/tutorial google and got the following:
Aug 23, 2013 2:24:09 PM oracle.sdovis.SRSCache get
WARNING: Cannot find SRS definition for srid 3857.
Aug 23, 2013 2:24:09 PM oracle.sdovis.theme.PredGeomThemeProducer loadFeaturesInAdjustedMBR
INFO: [ CUSTOMERS ] sql exec time: -1377293049773ms, total time loading 0 features: 125ms.
Aug 23, 2013 2:24:09 PM oracle.sdovis.theme.PredGeomThemeProducer loadFeaturesInWindow
WARNING: ORA-13199: SRID does not exist.
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.SDO_CS", line 5264
ORA-06512: at "MDSYS.SDO_CS", line 3034
I have check the coordinate system creation for 3875, and it appears to be correct.
I am running Oracle 11.2.0.1.0