Skip to main content
Solved

Get objectid of currently written features for further processing in shutdown script

  • June 8, 2018
  • 1 reply
  • 32 views

I'm writting features with FME to an Oracle database with ArcSDE. For further processing (e.g. call of external python functions) I need to know the objectids of the written features within a python- or tcl-shutdown script. Is there any option to get these information?

Thanks for your ideas!

Best answer by david_r

The OBJECTID value is assigned internally by ArcSDE and cannot be set by FME.

Because of this you basically have to re-read your features to determine which objectid value was assigned each feature.

It's technically possible (but much more complicated) to use two SQLExecutors rather than the regular writer / FeatureWriter and get the objectid without having to re-read the feature, but it entails short-circuiting ArcSDE and writing directly to the Oracle tables. Unless you're a fairly advanced user I wouldn't recommend it, however, as there are some important potential pitfalls you need to take into account. Starting point for the brave: https://support.esri.com/en/technical-article/000009261

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

1 reply

david_r
Celebrity
  • Best Answer
  • June 8, 2018

The OBJECTID value is assigned internally by ArcSDE and cannot be set by FME.

Because of this you basically have to re-read your features to determine which objectid value was assigned each feature.

It's technically possible (but much more complicated) to use two SQLExecutors rather than the regular writer / FeatureWriter and get the objectid without having to re-read the feature, but it entails short-circuiting ArcSDE and writing directly to the Oracle tables. Unless you're a fairly advanced user I wouldn't recommend it, however, as there are some important potential pitfalls you need to take into account. Starting point for the brave: https://support.esri.com/en/technical-article/000009261


Reply


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