After upgrading our SDE on SQL Server to SDE 11.0 using ArcGIS Pro 3.0.3. FME workbench is not able to read feature types correctly from the database. When importing a feature type using a reader, FME cannot read any fields. Same thing is happening when using FeatureReader. Has this been tested that FME 2022 works with SDE 11.0?
Question
SQL Server with SDE 11.0
@vudangtss Do you have ArcGIS Pro installed on the machine that is running FME? Then, on FME Workbench - in the Navigator under Workspace Parameters -> Translation, check that Esri ArcGIS Compatibility = Esri ArcGIS Pro
ArcGIS Pro is installed and FME workbench is set to ArcGISPro compatibility. I found a work-around to the deal with SDE 11. After selecting a feature type to import in the reader, I manually type in the missing schema name prefix in front of the table name and click ok. FME is then able to import fields for the feature type. We also have a SDE 10.9 database and for that version FME is able to read schema name of the feature classes.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.