Skip to main content
Question

Insert operation failed

  • January 14, 2014
  • 5 replies
  • 20 views
G
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

5 replies

fmelizard
Contributor
Forum|alt.badge.img+17
  • fmelizardContributor
  • Contributor
  • January 15, 2014
Hi,

 

 

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

 

 

Itay
G
  • gamze
  • Author
  • January 15, 2014
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 [-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)
J
  • jocsch
  • October 22, 2015
Hi,

 

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

 

Cheers, Jochen
J
  • jocsch
  • October 22, 2015
Hi again,

 

with that issue I get something like

 

[...]

 

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

 

[...]

 

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
tednorcott

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


Helpful Members This Week

Community Stats

30,951
Posts
117,298
Replies
38,743
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.