I am joining a data table with polygons, via a FeatureJoiner using a common value between the two datasets, both data sources come from a sql database.
I am outputting a spatial table (the polygons, joined with the data) to another database.
I am encountering a strange issue when I try to open this data with ArcGIS Pro, I have never come across this before - The ESRI_OID does not exist. I was not aware this was required previously either.
This is causing various issues with viewing the data and publishing it, or joining it within ArcPro. I am getting this error on the esri GIS server when I try to view the polygons/or view the table.
here is what the output data rows look like:
It is a very simple dataset with geometry.
I’ve never had to make esri_oids before in any of my workbenches, does anyone have any insight to what might be going wrong?