Skip to main content
  • EN
Hi,

 

I am trying to get CAD data into Smallworld GIS. I did get one dataset in, one layer from the Cad drawing into Smallworld. I tried it with another layer from CAD file and I got the message "insert operation failed" which resulted no data being inserted into Smallworld GIS. I am able to see all data in Universal Viewer so I am thinking that there must be something wrong with the writer. Is there anyone that can help me with this problem?

 

Thank you

 

gamze
Hi,

 

 

There are not many Smallworld users in this community, but possibly a more deatiled description (logifle text) might be helpfull.

 

 

Itay
This is one example I am getting. This info repeats for every object I am trying to write into Smallworld. I am not sure if this will help or not.

 

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Error r-1] occured during transaction: Insert operation failed

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Feature Type: `gas_distribution.gd_valve'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(32 bit integer)                    : `Source Brancher 2.BranchingFactory.Count' has value `1'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(32 bit integer)                    : `Source Feature Router.BranchingFactory.Count' has value `1'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(string)                            : `__wb_out_feat_type__' has value `gas_distribution.gd_valve'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(string)                            : `autocad_attributes_follow' has value `false'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(encoded: utf-16)                   : `autocad_block_name' has value `PE-VALVE'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(entangled: 32 bit unsigned integer): `autocad_color' has value `1'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(64 bit real)                       : `autocad_column_distance' has value `0'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(string)                            : `autocad_entity' has value `autocad_insert'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(encoded: utf-16)                   : `autocad_entity_handle' has value `16F'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(string)                            : `autocad_entity_visibility' has value `visible'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(encoded: utf-16)                   : `autocad_layer' has value `PE-VALVE'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(string)                            : `autocad_layer_type' has value `not_frozen'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(encoded: utf-16)                   : `autocad_linetype' has value `ByLayer'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(string)                            : `autocad_linetype_scale' has value `1'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(string)                            : `autocad_lineweight' has value `-1'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(32 bit integer)                    : `autocad_number_columns' has value `1'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(32 bit integer)                    : `autocad_number_rows' has value `1'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(string)                            : `autocad_original_color' has value `ByLayer'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(string)                            : `autocad_original_entity_type' has value `autocad_insert'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(encoded: utf-16)                   : `autocad_resolved_linetype' has value `CONTINUOUS'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(64 bit real)                       : `autocad_rotation' has value `358'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(64 bit real)                       : `autocad_row_distance' has value `0'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(string)                            : `autocad_source_filename' has value `O:\\MRT\\MRT_GIS\\BowLake\\Gas system - Copy2010Corrected.dwg'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(string)                            : `autocad_space' has value `model_space'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(64 bit real)                       : `autocad_thickness' has value `0'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(64 bit real)                       : `autocad_xscale' has value `1'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(64 bit real)                       : `autocad_yscale' has value `1'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(64 bit real)                       : `autocad_zscale' has value `1'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(encoded: utf-8)                    : `connection type' has value `Unknown'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(encoded: utf-8)                    : `connection_type' has value `Unknown'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(encoded: utf-8)                    : `date installed' has value `1/1/1111'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(encoded: utf-8)                    : `date_installed' has value `1/1/1111'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(encoded: utf-8)                    : `design_pressure' has value `IP'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(encoded: utf-8)                    : `diameter' has value `Unknown'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(entangled: string)                 : `fme_color' has value `1,0,0'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(string)                            : `fme_feature_type' has value `PE-VALVE'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(string)                            : `fme_geometry' has value `fme_point'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(entangled: string)                 : `fme_type' has value `fme_point'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(encoded: utf-8)                    : `job number' has value `unset'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(encoded: utf-8)                    : `material' has value `PE'

 

2014-01-14 13:48:19|   3.2|  0.0|ERROR |Attribute(32 bit integer)                    : `multi_reader_full_id' has value `2'

 

2014-01-14 13:48:20|   3.2|  0.0|ERROR |Attribute(32 bit integer)                    : `multi_reader_id' has value `2'

 

2014-01-14 13:48:20|   3.2|  0.0|ERROR |Attribute(string)                            : `multi_reader_keyword' has value `ACAD_3'

 

2014-01-14 13:48:20|   3.2|  0.0|ERROR |Attribute(string)                            : `multi_reader_type' has value `ACAD'

 

2014-01-14 13:48:20|   3.2|  0.0|ERROR |Attribute(string)                            : `multi_writer_id' has value `2'

 

2014-01-14 13:48:20|   3.2|  0.0|ERROR |Attribute(encoded: utf-8)                    : `nominal_diameter' has value `Unknown'

 

2014-01-14 13:48:20|   3.2|  0.0|ERROR |Attribute(encoded: utf-8)                    : `normal status' has value `Open'

 

2014-01-14 13:48:20|   3.2|  0.0|ERROR |Attribute(encoded: utf-8)                    : `normal_status' has value `Open'

 

2014-01-14 13:48:20|   3.2|  0.0|ERROR |Attribute(encoded: utf-8)                    : `owner type' has value `Company Owned'

 

2014-01-14 13:48:20|   3.2|  0.0|ERROR |Attribute(encoded: utf-8)                    : `owner_type' has value `Company Owned'

 

2014-01-14 13:48:20|   3.2|  0.0|ERROR |Attribute(encoded: utf-8)                    : `pressure' has value `IP'

 

2014-01-14 13:48:20|   3.2|  0.0|ERROR |Attribute(encoded: utf-8)                    : `pse_job_num' has value `unset'

 

2014-01-14 13:48:20|   3.2|  0.0|ERROR |Attribute(encoded: utf-8)                    : `source data' has value `Unk'

 

2014-01-14 13:48:20|   3.2|  0.0|ERROR |Attribute(encoded: utf-8)                    : `source_data' has value `Unk'

 

2014-01-14 13:48:20|   3.2|  0.0|ERROR |Attribute(encoded: utf-8)                    : `status' has value `Temporary'

 

2014-01-14 13:48:20|   3.2|  0.0|ERROR |Attribute(string)                            : `sworld_geom_type' has value `sworld_point'

 

2014-01-14 13:48:20|   3.2|  0.0|ERROR |Attribute(string)                            : `sworld_name' has value `location'

 

2014-01-14 13:48:20|   3.2|  0.0|ERROR |Attribute(string)                            : `sworld_type' has value `sworld_point'

 

2014-01-14 13:48:20|   3.2|  0.0|ERROR |Attribute(encoded: utf-8)                    : `type' has value `Unknown'

 

2014-01-14 13:48:20|   3.2|  0.0|ERROR |Attribute(encoded: utf-8)                    : `use' has value `Unknown'

 

2014-01-14 13:48:20|   3.2|  0.0|ERROR |Coordinate System: `WA83-NMM'

 

2014-01-14 13:48:20|   3.2|  0.0|ERROR |Geometry Type: IFMEPoint

 

2014-01-14 13:48:20|   3.2|  0.0|ERROR |Coordinate Dimension: 3

 

2014-01-14 13:48:20|   3.2|  0.0|ERROR |(390173417.32831138,50076309.034107208,0)
Hi,

 

I had the same issue today. Did you solve yours actually?

 

Cheers, Jochen
Hi again,

 

with that issue I get something like

 

p...]

 

FME|15|2015-10-22 12:15:44|DBG|Attempting to insert record sof_erl_lfp610-detached:(0) False

 

FME|15|2015-10-22 12:15:44|DBG|+++ Failed to insert record from detached record sof_erl_lfp610-detached:(0)

 

FME|15|2015-10-22 12:15:44|DBG|Error: Die Werte entsprechen keinem Eintrag im LFP Katalog ART-Katalog

 

(Value does not match any Catalogue entry)

 

FME|15|2015-10-22 12:15:44|DBG|Unable to continue processing this transfer record

 

p...]

 

on the comand line.

 

The catalogue entry though is definitly available in the alternative i'm trying to wirite in.

 

Possible solution (worked for me): It seems that Catalogue entries must be available in the top-Alternative and not only in the alternative you try to write in.

 

Cheers so far, Jochen

Error [-1] occured during transaction: Insert operation failed

Solved it!

  1. Make sure all required attributes are populated in your source GDB, SHAPE GIS database
  2. Make sure the Smallworld catalogue values are relevant based on your attribute combinations
  3. Use the Counter Transformer to count objects coming through. Set the following:
    1. Count Start :1
    2. Count Scope: Global
    3. Count Domain: counter
    4. Output Attribute Names:
      1. Count: _count
      2. Group ID: <blank>
  4. Aggregator Transformer: Set the following:
    1. Group By: _count
    2. Complete Groups: When All Features Received
    3. Aggregation Mode: Merge Incoming Attributes
    4. check box Generate List:
      1. List Name: sworld_geometry
      2. Add To List: All Attributes
    5. Aggregate Type: Homogeneous Collection if Possible
    6. Geometry Name Attribute: sworld_name

I hope this works for you!

Reply


Community Stats

30,110
Posts
114,303
Replies
37,745
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.