Skip to main content
Solved

Writing to SDE, get error with feature caching off, works with feature caching on!


oliver.morris
Contributor
Forum|alt.badge.img+12

Hi,

I have spent most of the morning going down a rabbit hole and really am none the wiser. I am writing out some content to a feature class in SDE. When I run the full process with feature caching on or off I get a failure to write with a very unhelpful ESRI error:

An error occurred while attempting to insert a row into the table 'DBO.xxxx' using a cursor. The error number from ArcObjects is: '-2147418113'. The error message from ArcObjects is: {}

However if I run it with feature caching on, up to the last transformer and then run to the writer afterwards the content goes into the SDE, no error.

If I write to a ffs file then push that to sde. It works.

My suspicion is that I am using a feature reader, it seems like SDE doesnt recieve all the right info about the schema before FME tries to write to it, whereas it does when feature caching is enabled?

Any ideas very much appreciated.

Thanks

Oliver

 

Best answer by ebygomm

I've seen the same 'helpful' error recently, although the circumstances were slightly different. What do you have your python compatibility set to?

View original
Did this help you find an answer to your question?

4 replies

ebygomm
Influencer
Forum|alt.badge.img+31
  • Influencer
  • Best Answer
  • June 22, 2020

I've seen the same 'helpful' error recently, although the circumstances were slightly different. What do you have your python compatibility set to?


oliver.morris
Contributor
Forum|alt.badge.img+12
  • Author
  • Contributor
  • June 22, 2020
ebygomm wrote:

I've seen the same 'helpful' error recently, although the circumstances were slightly different. What do you have your python compatibility set to?

3.7+ at the moment. Thanks for the help.


oliver.morris
Contributor
Forum|alt.badge.img+12
  • Author
  • Contributor
  • June 22, 2020
ebygomm wrote:

I've seen the same 'helpful' error recently, although the circumstances were slightly different. What do you have your python compatibility set to?

I changed to ESRI Pro 2.1-2.5 (Python 3.6) and this sorted the issue bizarre. Wow, only lost a days work debugging this. Thank you so much for the help @ebygomm


ebygomm
Influencer
Forum|alt.badge.img+31
  • Influencer
  • June 22, 2020
oliver.morris wrote:

3.7+ at the moment. Thanks for the help.

The answer provided by @markatsafe here resolved the issue for us

https://knowledge.safe.com/questions/108266/sde-write-error-2147418113.html


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