• State Verified Answer
  • Replies 5 replies
  • Subscribers 58 subscribers
  • Views 3429 views
  • Users 0 members are here

Geospatial Administrator & Oracle XE

ece
Offline

Hello

I have geographic data, that are stored in Oracle XE 11g (SRID 25832).

There is no problem to query and delete features. But, when I try to create or update an feature, I get this error "Error Inserting Feature (class: TEST_BUILDING, id: 28)

Invalid geometry for table TEST.BUILDING, column SDO_GEOMETRY.54668

ORA-54668: a 2D SRID cannot be used with a 3D geometry

Irreparably invalid geometry."

The problem is that SRID’s do not match.

Is there an easy way around this problem?

  • 0 Offline
    Are you in a 3d model  when posting to the Oracle spatial table ? If you try this in a 2d model does it work ?
     
    Jerry Walter
    Geospatial Advisor
    Mapping - US and Canada
    +1 937 205 3674 (office)
    +1 937 205 3674 (mobile)
    Skype : jerry.walter.troy
     

     

  • 0 Offline in reply to Jerry Walter - Bentley
    The problem is the same, regardless of using 3D or 2D files.
  • 0 Offline
    Please make sure you are using the right versions and installs of Oracle XE
     
    Oracle
    For use of Oracle Spatial functionalities the minimum server and client installation requirements are as follows:
    Server
    Oracle Database 11g Release 2 Enterprise Edition, Standard Edition or Standard Edition One
    Oracle Database 11g Release 1 Enterprise Edition, Standard Edition or Standard Edition One
    Oracle Database 10g Release 2 Enterprise Edition, Standard Edition or Express Edition ***
    Client
    Oracle Database 11g Release 2 Full Client Installation *
    Oracle Database 11g Release 1 Full Client Installation *
    Oracle Database 10g Release 2 Full Client Installation **

    * Required for those users planning to leverage direct connections to Oracle Spatial databases. Installation and use of an Oracle 11g 32-bit client is required for all Microsoft Windows 32-bit and 64-bit operating systems. Use of Oracle 11g 64-bit clients are not supported at this time.

    ** For those users not planning to make use of Oracle Spatial functionalities (e.g. RDBMS properties only, no geometries) the Oracle 10g and Oracle 11g full client installations are supported since these capabilities make use of the underlying MicroStation database server support.

    *** For Express Edition installations, both client and server must be installed together on the client workstation. For those planning to use the conflict resolution functionality, Oracle 10g Release 2 10.2.0.3 or higher is required.
    Patches
    For Oracle 10g server instances, patches 6056355 and 6330165 are required for users working with topology.
    For Oracle 11g server instances running on Intel platforms, please see the "Known Issues" section for information regarding required version and patch set numbers for users working with Oracle Spatial 3D geometries.
     
     
     
    Jerry Walter
    Geospatial Advisor
    Mapping - US and Canada
    +1 937 205 3674 (office)
    +1 937 205 3674 (mobile)
    Skype : jerry.walter.troy
     

     

  • 0 Offline
    You could probably test to update the spatial metadata and assign NULL to the SRID, I expect you to be able to post then as the error clearly suggests the issue is in the SRID. This SRID does not seem suitable for 3D data, your spatial index was also created with 3 coordinate dimensions?

    Regards
    Carlos



    Answer Verified By: Sebastien Lefrancois 

  • 0 Offline in reply to CMartins
    Thanks for your right observation Carlos.
    After I did as you suggested, everything works great.
Communities
Support and Services
Training and Learning
Social Media