Skip to main content
Question

SQL to FGDB - The error number from ArcObjects is: '-2147210926'.


canerakin
Contributor
Forum|alt.badge.img+6

An error occurred while attempting to add a shape to a feature buffer. The error number from ArcObjects is: '-2147210926'. The error message from ArcObjects is: {Closed polylines not allowed with network features [class name = wLateralLine, object id = 3688]}

I am having this error all the time. I checked the geometry and realized that there are some arcs.Then I used GeometryCoercer but it didnt fix the problem.

11 replies

geosander
Forum|alt.badge.img+7
  • October 26, 2017

Try the ArcStroker. That converts arcs into lines.


canerakin
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • October 26, 2017
geosander wrote:

Try the ArcStroker. That converts arcs into lines.

Same problem did not work. it stops at 2533. till this number there is no Arc. Is this a common problem?

 

 

 

An error occurred while attempting to add a shape to a feature buffer. The error number from ArcObjects is: '-2147210926'. The error message from ArcObjects is: {Closed polylines not allowed with network features [class name = wLateralLine, object id = 3688]}

 

 

 


geosander
Forum|alt.badge.img+7
  • October 26, 2017

Well, then the problem probably relates to the error you are seeing. It's not an FME error, but an Esri error.

This feature class you are writing to (wLateralLine)... does that already exist by any chance? And does it participate in a network dataset (there should also be a junction feature class in that case)? Notice you can set the Geodatabase type on the writer feature class. Valid values are mentioned here.

  • If you are trying to simply write polylines and the target feature class is a polyline feature class, be sure to set the type to geodb_polyline.
  • If you are trying to add lines to an actual network feature class, this will only work if the feature class already exists (according to this, FME does not fully support network feature classes so it seems). I am not sure to what type you should set the geodb_type, but it's probably geodb_simple_edge or otherwise geodb_complex_edge might do the trick for you. You might need to split your line (e.g. using a Chopper after the ArcStroker) into 2 parts for example, since an ellipse really isn't a valid network edge. Be aware though that you'll also have to add an extra junction (point) in that case.

Good luck..!


geosander
Forum|alt.badge.img+7
  • October 26, 2017
geosander wrote:

Well, then the problem probably relates to the error you are seeing. It's not an FME error, but an Esri error.

This feature class you are writing to (wLateralLine)... does that already exist by any chance? And does it participate in a network dataset (there should also be a junction feature class in that case)? Notice you can set the Geodatabase type on the writer feature class. Valid values are mentioned here.

  • If you are trying to simply write polylines and the target feature class is a polyline feature class, be sure to set the type to geodb_polyline.
  • If you are trying to add lines to an actual network feature class, this will only work if the feature class already exists (according to this, FME does not fully support network feature classes so it seems). I am not sure to what type you should set the geodb_type, but it's probably geodb_simple_edge or otherwise geodb_complex_edge might do the trick for you. You might need to split your line (e.g. using a Chopper after the ArcStroker) into 2 parts for example, since an ellipse really isn't a valid network edge. Be aware though that you'll also have to add an extra junction (point) in that case.

Good luck..!

Ah yes, also note that FME has a TopologyBuilder, which has been designed to create networks. It can clean up your line geometry as well, turning it into valid edges, that hopefully can be written to your Geodatabase...

 

 


trentatsafe
Safer
Forum|alt.badge.img+6
  • Safer
  • October 27, 2017

Hello @canerakin111,

 

 

If you want to find the closed polylines you could try the following:

 

1) Add a counter to the workspace to set a unique ID to each line.

 

2) Then send them to an Area Builder with the Group by setting set to the ID attribute.

 

3) Unclosed lines will be output through the Incomplete port, while any lines that closed on themselves will exit the Area port.

 

Alternatively, a GeometryFilter may also reveal the problem features.

 

 

Once found, a GeometryValidator may be able to correct the geometry errors.

canerakin
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • October 27, 2017
trentatsafe wrote:

Hello @canerakin111,

 

 

If you want to find the closed polylines you could try the following:

 

1) Add a counter to the workspace to set a unique ID to each line.

 

2) Then send them to an Area Builder with the Group by setting set to the ID attribute.

 

3) Unclosed lines will be output through the Incomplete port, while any lines that closed on themselves will exit the Area port.

 

Alternatively, a GeometryFilter may also reveal the problem features.

 

 

Once found, a GeometryValidator may be able to correct the geometry errors.
All the steps worked perfectly but how will I use geometryValidator here. 2 areas were founded.

 

 


canerakin
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • October 27, 2017
canerakin wrote:
All the steps worked perfectly but how will I use geometryValidator here. 2 areas were founded.

 

 

this is the result.

 


trentatsafe
Safer
Forum|alt.badge.img+6
  • Safer
  • October 27, 2017
Hello @canerakin111,

 

 

A colleague of mine suggested, with the fact you have the problem features identified. Use a GeometryCoercer on the Area features to convert them to lines, this should allow them to be written now.

 


trentatsafe
Safer
Forum|alt.badge.img+6
  • Safer
  • October 27, 2017
canerakin wrote:

this is the result.

 

Hello @canerakin111,

 

 

A colleague of mine suggested, with the fact you have the problem features identified. Use a GeometryCoercer on the Area features to convert them to lines, this should allow them to be written now.

 


canerakin
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • October 27, 2017
trentatsafe wrote:
Hello @canerakin111,

 

 

A colleague of mine suggested, with the fact you have the problem features identified. Use a GeometryCoercer on the Area features to convert them to lines, this should allow them to be written now.

 

I tried that after trying your instructions in the previous comment. It didnt work too.

canerakin
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • October 27, 2017
trentatsafe wrote:
Hello @canerakin111,

 

 

A colleague of mine suggested, with the fact you have the problem features identified. Use a GeometryCoercer on the Area features to convert them to lines, this should allow them to be written now.

 

Do you think that is going to affect?

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