Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

can not find definition for srid 3857

Gerald Dildine - ITISAug 23 2013 — edited Sep 4 2013


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

This post has been answered by jsharma-Oracle on Aug 26 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 2 2013
Added on Aug 23 2013
4 comments
3,162 views