Skip to main content
Question

ArcObjects error 2147221230


fallingdog
Contributor
Forum|alt.badge.img+6

log.txtMy writer into an esri fgdb is failing.

An error occurred while attempting to store a row into the table 'PriOHElectricLineSegment'. The error number from ArcObjects is: '-2147221230'. The error message from ArcObjects is: {}

 

The error message of "{}" is not very helpful. I attempted to look it up with esri without any luck.

Does anyone know the source of the problem?

Thanks

 

9 replies

nielsgerrits
VIP

From the log:

No subtype value/code found for the field 'subtypecd' in table/feature class 'PriOHElectricLineSegment'. Using the default code of '1'

Does that have anything to do with it? 

I also found this topic when googling "2147221230 fme". Do you read from another GDB? Something from source might be interfering?


fallingdog
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • May 13, 2019

Thanks for the feedback @nielsgerrits.

 

I don't think that is the problem. I think all that is indicating is that I am not populating the subtype field form the source data: therefore, it is populating the subtype with the default value from the target (I have a lot more work to do on this and will be adding more and more input fields over time--subtype is on the list at some point). To test this I placed the only target feature class in a fgdb alone and was able to write to it without any problem. So, I am thinking that it must be other objects in the original fgdb that are causing the problem.

 

To populate the target fgdb with data I am copying a feature dataset that contains a geometric network from sde. This copy operation grabs everything in the feature dataset as well as a number of objects outside it that have relationships to objects within the dataset. Then I am deleting the network and trying to write with FME. Later we plan on recreating the network. Could the relationship classes be causing a problem?


nielsgerrits
VIP
fallingdog wrote:

Thanks for the feedback @nielsgerrits.

 

I don't think that is the problem. I think all that is indicating is that I am not populating the subtype field form the source data: therefore, it is populating the subtype with the default value from the target (I have a lot more work to do on this and will be adding more and more input fields over time--subtype is on the list at some point). To test this I placed the only target feature class in a fgdb alone and was able to write to it without any problem. So, I am thinking that it must be other objects in the original fgdb that are causing the problem.

 

To populate the target fgdb with data I am copying a feature dataset that contains a geometric network from sde. This copy operation grabs everything in the feature dataset as well as a number of objects outside it that have relationships to objects within the dataset. Then I am deleting the network and trying to write with FME. Later we plan on recreating the network. Could the relationship classes be causing a problem?

One of the replies in the email suggests problems when writing relations using a basic license.

...a common problem when writing to a Geodatabase, is that FME tries to write into a Geodatabase with Relationships with an ArcView license.
Try forcing FME to use an ArcEditor / ArcInfo - Licence if this is the case or use another geodatabase. 

Hard to say if this is your issue but it's a good habit to exclude problems other people found with the same symptoms.

Working with relations seem to require a Standard or Advanced license, according to the documentation.

This topic also points to license related problems.


nielsgerrits
VIP

I found -2147221230 documented as "E_GSE_BAD_DISTANCE_VALUE" / "Bad distance value in parcel."


fallingdog
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • May 14, 2019

Nice find! I was unable to find it on the esri page I was looking at. Thanks!


fallingdog
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • May 14, 2019
nielsgerrits wrote:

One of the replies in the email suggests problems when writing relations using a basic license.

...a common problem when writing to a Geodatabase, is that FME tries to write into a Geodatabase with Relationships with an ArcView license.
Try forcing FME to use an ArcEditor / ArcInfo - Licence if this is the case or use another geodatabase. 

Hard to say if this is your issue but it's a good habit to exclude problems other people found with the same symptoms.

Working with relations seem to require a Standard or Advanced license, according to the documentation.

This topic also points to license related problems.

Good to know. Looks like it is checking out the advanced license on its own. But I did find this article on forcing the license level if needed.

 

https://knowledge.safe.com/articles/31613/setting-different-license-levels-for-arcgis-and-fm.html


fallingdog
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • May 14, 2019
nielsgerrits wrote:

One of the replies in the email suggests problems when writing relations using a basic license.

...a common problem when writing to a Geodatabase, is that FME tries to write into a Geodatabase with Relationships with an ArcView license.
Try forcing FME to use an ArcEditor / ArcInfo - Licence if this is the case or use another geodatabase. 

Hard to say if this is your issue but it's a good habit to exclude problems other people found with the same symptoms.

Working with relations seem to require a Standard or Advanced license, according to the documentation.

This topic also points to license related problems.

I was able to identify a problem annotation relationship class. Deleting the relationship class in the target fgdb solved the problem. The target feature class has about 8 relationships. A number of them are annotation. So, I am not sure yet why this one is tripping up FME....


nielsgerrits
VIP
fallingdog wrote:

Nice find! I was unable to find it on the esri page I was looking at. Thanks!

I always have a hard time finding ESRI's errorcodes and often give up looking if Google does not return anything useful. Like most things, if you know where to look...


nielsgerrits
VIP
fallingdog wrote:

I was able to identify a problem annotation relationship class. Deleting the relationship class in the target fgdb solved the problem. The target feature class has about 8 relationships. A number of them are annotation. So, I am not sure yet why this one is tripping up FME....

So nothing to do with "Bad distance value in parcel." ? If you can create a test set (sample of input, workspace, target gdb) it is easier to reproduce and look.


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