Skip to main content

Hi,

getting the following error writing to filegeodatabase and or esri geodatabse. Our work bench work perfect in FME 2018, but ift fails in 2019.0, 2019.1 and 2019.2. If you disable the writer, and run with feature caching, up to the writer, enable the writer, and just run the last part it works.

I have tested the same work bench today in 2020, and working perfectly

also tested it in 2019, writing to shapefile and geojson - both worked OK

the same happens when you use LineonAreaOverlay

imsge 1 - shows success, image 2 show failure in 2019

Writer mode is 'INSERT'

Transactions are being used by the Geodatabase Writer

Geodatabase Writer: Truncating table/feature class `ShrubBedCandidates'

Geodatabase Writer: The field 'OBJECTID' in table 'ShrubBedCandidates' will not be updated since it is not editable

Geodatabase Writer: The field 'SHAPE.STLength()' in table 'ShrubBedCandidates' will not be updated since it is not editable

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

Storing feature(s) to FME feature store file `M:\\Production\\Development\\VogtRudy\\repositories\\quality-assurance\\appcode\\fmw\\candidate\\ShrubBedCandidates_log.ffs'

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

 

@rudy_v Did you also install ArcPro. This question seems similar: https://knowledge.safe.com/questions/108266/sde-write-error-2147418113.html


@rudy_v Did you also install ArcPro. This question seems similar: https://knowledge.safe.com/questions/108266/sde-write-error-2147418113.html

Hi @markatsafe

Yes we are using ArcGIS Pro 2.4.3 - All our users have a similar problems, writing fail to FileGeodatabase / ESRI Geodatabase - in all all versions of 2019. I have tested the same work bench and works fine in 2020, and 2018.

I am running the same work bench on my PC / FME Server, it works perfect in 2018.1 and 2020, but fails with the above error in 2019.0 / 2019.1 and 2019.2. The work bench are set to Python 3.7+

In my opinion it is bug in 2019

 


Hi @markatsafe

Yes we are using ArcGIS Pro 2.4.3 - All our users have a similar problems, writing fail to FileGeodatabase / ESRI Geodatabase - in all all versions of 2019. I have tested the same work bench and works fine in 2020, and 2018.

I am running the same work bench on my PC / FME Server, it works perfect in 2018.1 and 2020, but fails with the above error in 2019.0 / 2019.1 and 2019.2. The work bench are set to Python 3.7+

In my opinion it is bug in 2019

 

@rudy_v It is an issue with FME 2019. It's related to the new libraries available to FME in ArcPro. There is incompatibility between the older ArcGIS ArcObjects 10 and ArcPro libraries. Were you able to try the steps outline in the Forum question https://knowledge.safe.com/questions/108266/sde-write-error-2147418113.html


@rudy_v It is an issue with FME 2019. It's related to the new libraries available to FME in ArcPro. There is incompatibility between the older ArcGIS ArcObjects 10 and ArcPro libraries. Were you able to try the steps outline in the Forum question https://knowledge.safe.com/questions/108266/sde-write-error-2147418113.html

Hi @markatsafe

I have worked it out in fme 2019, it works correctly if you change the Preferred Python Interpreter to arcgis pro 2.1-2.5. In FME 2018 and FME 2020, i left it as python 3.7+


Reply