Unable to Register Feature Class which is created using FME to Enterprise GeoDatabase

[ArshiyaNisa]

We're having trouble registering a feature class, created using FME with my Enterprise Geodatabase (SQL Server) so that ArcGIS Pro can recognize it as a valid geodatabase feature class.

When I try Register With Geodatabase or even open the Properties of the table in Pro, we are getting below error:

All the datatypes are valid and supported by SQL server and are aligned with ArcGIS. The table loads into SQL Server successfully and we can see the data as well. 

Below are our observations:

• “Register With Geodatabase” fails

• Opening Properties gives Invalid entity type

  

  Question:

  1. Is there a recommended workflow for creating feature classes with FME that ArcGIS can register correctly?

[RyanUthoff · Accepted solution]

I suspect there is a record(s) with invalid geometry and it fails when trying to register with the geodatabase.

What you might be able to do is register an empty feature class with the geodatabase first, then use FME (using the SDE writer) to write your records that way. If there is an invalid geometry, FME might tell you the specific record when Esri rejects it when attempting to write it.

[ArshiyaNisa]

Hi @RyanUthoff 
Our first record on table has geometry issue, hence pro was unable to register the feature class with GDB. Thank you for your time.

[Priya_Das]

Hi @ArshiyaNisa 

To register a dataset with the geodatabase use the Register with Geodatabase geoprocessing tool. To do this, you must connect as the owner of the input dataset.

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/register-with-geodatabase.ht...

https://support.esri.com/en-us/knowledge-base/000026901