This is probably something I am just doing wrong, but I am having trouble loading my 3D features (buildings) into our Oracle Server (11g).
I have created me GSA project and created a couple of features, now I want to load these into Oracle. I used the 'dgn2sdo' utility to create the Oracle scripts to upload the data, but this seems to have failed.
In my DGN2SDO logfile I found these lines:
Commencing translationERROR: Error encountered while translating instances = (Exception of type 'System.NotSupportedException' was thrown.).System.NotSupportedException: Exception of type 'System.NotSupportedException' was thrown. at Bentley.EngineeringContent.Storage.Xfm.ECXfmSupport.ManufactureInstanceToStore(opaquePointer* feature, Char* pFacilityUuid, IOgcSpatialReference targetSpatialReference, ECObjectToXfmWorkingStorage workingStorage, Boolean populateOnlySimpleProperties) at Bentley.EngineeringContent.Storage.Xfm.ECXfmScanDgnInstanceCursor.Read() at Bentley.Geospatial.Dgn2Sdo.Dgn2SdoTranslator.Translate(IECInstanceCursor instanceCursor)ERROR: Error encountered while translating instances = (An unsupported Microstation element type of 94 has been encountered, and cannot be converted to an OGC geometry type.).System.ApplicationException: An unsupported Microstation element type of 94 has been encountered, and cannot be converted to an OGC geometry type. at Bentley.EngineeringContent.Storage.Xfm.ECXfmSupport.ManufactureInstanceToStore(opaquePointer* feature, Char* pFacilityUuid, IOgcSpatialReference targetSpatialReference, ECObjectToXfmWorkingStorage workingStorage, Boolean populateOnlySimpleProperties) at Bentley.EngineeringContent.Storage.Xfm.ECXfmScanDgnInstanceCursor.Read() at Bentley.Geospatial.Dgn2Sdo.Dgn2SdoTranslator.Translate(IECInstanceCursor instanceCursor)Total instances read = 2Total instances written = 2Translation completed
And when I check my DAT file the third dimension is missing from each surface of my building.
I am using Bentley Map Enterprise and Oracle 11g (not Oracle Spatial).
So what is the correct process for creating and 3D features in Oracle?
Regards Ian
Ian;
Just some additional information to help you with the error. The following are MicroStation element types:
| Type Description |
| 1 Cell Library Header |
| 2 Cell (complex) |
| 3 Line |
| 4 Line String |
| 5 Group Data |
| 6 Shape |
| 7 Text Node (complex) |
| 8 Digitizer Setup Data |
| 9 Design File Header if level 8 |
| 10 Level Symbology |
| 11 Curve |
| 12 Complex String (complex) |
| 13 Conic |
| 14 Complex Shape (complex) |
| 15 Ellipse |
| 16 Arc |
| 17 Text |
| 18 Surface (complex) |
| 19 Solid (complex) |
| 20 not used |
| 21 B-Spline Pole |
| 22 Point String |
| 23 Circular Truncated Cone |
| 24 B-Spline Surface (complex) |
| 25 B-Spline Surface boundary |
| 26 B-Spline Knot Element |
| 27 B-Spline Curve (complex) |
| 28 B-Spline Weight Factor |
| 33 Dimension Element |
| 34 Shared Cell Definition Element |
| 35 Shared Cell Element |
| 36 Multiline Element |
| 37 Attribute Element |
| 38 DgnStore Component |
| 39 DgnStore Header |
| 66 MicroStation Application |
| 87 Raster Header |
| 88 Raster Component |
| 90 Raster Reference Attachment |
| 91 Raster Reference Component |
| 92 Raster Hierarchy Element |
| 93 Raster Hierarchy Component |
| 94 Raster Frame Element |
| 95 Table Entry Element |
| 96 Table Header Element |
| 97 View Group Element |
| 98 View Element |
| 99 Level Mask Element |
| 100 Reference Attach Element |
| 101 Matrix Header |
| 102 Matrix Int Data |
| 103 Matrix Double Data |
| 105 Mesh Header |
| 106 Extended Element (graphic) (complex) |
| 107 Extended Element (non-graphic) (complex) |
| 108 Reference Override Element |
| 110 Named Group Header |
| 111 Named Group Component |
So the type 94 element is a raster frame element. You might want to either remove this element, or move the elements you are wanting to translate to another level.
Second, you need to be using Oracle Spatial. DGN2SDO assumes you will be creating/updating spatial tables. The output scripts from the DGN2SDO process assumes this.
Jerry