Update Geodatabase Reader to support Feature Classes with Attribute Rules

This begs the question about leveraging rules (i.e Arcade) during Workbench processing, or risk breaking some business rules. Not trivial.

Thanks for reading and your contribution @bruceharold I see you are on the Interoperability Team at Esri. The most important first step would be for FME to successfully read these features and copy them, not necessarily leverage the rules during processing.

Our use case for this FME feature is to support this structure: Edit database -->one-way-replication--> Published database --> Web Services / Read Users. The Copy Features GP tool in pro will copy successfully and it abandons attribute rules in the process (which is fine for our use case) - this is also documented in the Esri Dev summit video. Our published database does not need any attribute rules as it is read-only in function.

Hi, replication is back at Pro 2.5 due out shortly so you should be able to use core tools for publishing.

And yes, I'm on the DI 'team', which is a slight stretch for the term ;-).

Hello,

2 years later, any update on supporting reading/writing features from an SDE feature class with attribute rules configured ?

Is there any version available that support this request ? I can't see anything in changelog unfortunately :(

If not, any ETA ? It's preventing us from using these powerful attributes rules.

Thanks !

Hello @biboba​ 

I think this should be supported now, we added support to be able to read from or write to an SDE Feature class with attribute rules configured. I believe this should be available as of 2020.1(can test with 2021 to confirm). The one caveat is you need to ensure you have ArcGIS Pro Installed on the machine with FME.

If you test this and are still experiencing issues, would you mind submitting a case here please: https://community.safe.com/s/submit-case

Hello @trentatsafe​ ,

Thanks for your reply ! Much appreciated.

Indeed, you are right !  Acutally, I had to switch "Esri ArcGIS Compatibility" to "Esri ArcGIS Pro" rather than "auto".

But I am still facing an issue: while I can add a feature class with attributes rules as reader, I cannot add the very same feature class as writer:

An error occurred while attempting to open the table, feature class or relationship class 'FOO.BAR'. The error number from ArcObjects is: '-2147211773'. The error message from ArcObjects is: {The item does not have a definition.}
 
It could have failed to open because it contains ArcGIS Pro-only features, for example Arcade expressions. If this is the case, please install ArcGIS Pro or Pro-compatible ArcGIS Server and 64-bit FME

Was writing introduced as a second step ? 

I am running 2021.0.1.

I guess I will open a ticket as you suggest.

Thanks

Hello @biboba​ 

This might be an issue tied to the esri library that loads when adding a reader/writer. If you have 64-bit Background Geoprocessing + ArcGIS Pro installed it may through a conflict when adding a writer. If you try uninstalling your 64-bit Background Geoprocessing, then re-launching FME and try adding the Writer for the Attribute Rule geodatabase. Does it still fail?

Probably best to file a case anyway just to be sure.